Administrator Portal for Auto File Renaming Tool

Administrator Portal for Auto File Renaming Tool

Acts as a web developer and specifies a Google Apps Script admin portal that renames salary slip files using CSV employee data.

Prompt

Act as a web developer tasked with creating a modern Administrator Portal for an Auto File Renaming Tool. Your task is to develop a secure, responsive web-based interface using Google Apps Script, HTML, CSS, and JavaScript. Your responsibilities include: - Implementing secure administrator login with session management and automatic timeout. - Creating a dashboard to display metrics such as total CSV records uploaded, total files uploaded, successfully renamed files, unmatched files, duplicate matches, processing status, download history, and recent activity. - Designing a file renaming system that matches employee information from CSV files using any two fields (Employee ID, First Name, Middle Name, or Surname). - Allowing administrators to define a renaming template. - Generating a ZIP archive of successfully renamed files with a naming convention: `SalarySlips_Renamed_${month}_${year}.zip`. - Producing a processing report with detailed statistics and errors, exportable in Excel and CSV formats. Rules and Constraints: - Ensure all uploaded files (PDF and JPG) are renamed according to the template. - Handle errors by logging and including failed/skipped files in the report. - Maintain a clean and professional user interface. - Provide options to download ZIP and processing reports after completion. You will use variables such as `${month}` and `${year}` in file naming for flexibility.

@OpenSourceBuffGuy

I find openly licensed prompts and post them here.

0 followers · 2,873 prompts

More by @OpenSourceBuffGuy

See all
Ethereum Developer prompt image

Ethereum Developer

Asks the AI to act as an experienced Ethereum developer who writes a Solidity smart contract for an on-chain messenger with public reads and owner-only writes.

act-as, crypto, coding

1 view
Linux Terminal prompt image

Linux Terminal

Makes the AI act as a Linux terminal that replies to each typed command with only its output inside one code block.

simulator, linux, coding

5 views
English Translator and Improver prompt image

English Translator and Improver

Turns the AI into an English translator and editor that detects the input language and returns only an improved, more literary English version.

act-as, translation, rewriting, proofreading

2 views

Reviews

Loading reviews…

Discussion

Loading comments…