@ramsham355
Develop a secure and responsive Administrator Portal using Google Apps Script to manage an Auto File Renaming Tool. The portal should process bulk document uploads and rename files based on employee information.
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.
complete source code for the application + `build.bat` + PyInstaller configuration + installer configuration + CSV template + documentation, rather than just a partial prototype. i will upload csv and bulk pdf file. after clickig button match name and pdf file process file will be send to provided email id which in csv note: This error originates from a subprocess, and is likely not a problem with pip. ERROR: Failed building wheel for Levenshtein Failed to build Levenshtein error: failed-wheel-build-for-install × Failed to build installable wheels for some pyproject.toml based projects ╰─> Levenshtein ERROR: Failed to install required packages cpanel webmail Set up email on application tool PDF Auto MATCHING LOGIC: EmployeeID, FirstName, MiddleName, LastName NAME-BASED MATCHING If Employee ID is not found in the filename, implement a controlled secondary matching method based on employee name. Example: PDF: ``` Abel Harry Anthony.pdf ``` CSV: ``` 10152 | Abel | Harry | Anthony | abel@example.com ``` The application should identify: ``` Abel Harry Anthony ``` and match it with the CSV record. The matching logic can be changed so the application uses any 3 of the 4 CSV fields: * `ID` * `First Name` * `Middle Name` * `Last Name` Input PDF: 10004_Vihang_Wani_SalarySlip_March_2026.pdf no need to rename the pdf file once it's attached also show dashboard me all attachments before sending email can be built as a Windows desktop application that: 1. Imports an employee CSV. 2. Lets you select a folder containing hundreds/thousands of PDFs. 3. Extracts the Employee ID from each filename. 4. Finds the matching employee in the CSV. 5. Renames the PDF according to a defined format. 6. Shows success, unmatched, duplicate, and error reports. 7. Provides a one-click Windows build that produces a `.exe`. For your example:Input: SumitShyamraoTunkikar_0020063_Aug_2026.pdf CSV: 20063 | Sumit | Shyamrao | Tunkikar Output: 20063_Sumit_Shyamrao_Tunkikar.pdf Or Input: Abel Harry Anthony.pdf CSV: 10152 | Abel | Harry | Anthony Output:10152_Abel_Harry_Anthony.pdf Or Input: AbhishekYadav_0020311_Aug_2026.pdf CSV: 20311 | Abhishek | Yadav Output:20311_Abhishek_Yadav.pdf SAFETY Original PDFs are preserved by default. The output is written to a separate folder. Add Naming Templates: Configure rename patterns: add Placeholders: employeeid firstname middlename surname month year Define how renamed pdf should look example: Pattern employeeidfirstnamesurnameSalarySlipmonthyear Or employeeidfirstnamemiddlenamesurnameSalarySlipmonth_year Live preview 20311_Abhishek_Yadav_SalarySlip_August_2026.pdf the specification to: The matching logic can be changed so the application uses any 3 of the 4 CSV fields: * `ID + First Name + Middle Name + Surname` * `ID + First Name + Surname` * `First Name + Middle Name + Surname` when no ID is present * Handle concatenated names such as `SumitShyamraoTunkikar` * Handle spaced names such as `Abel Harry Anthony` * Normalize leading-zero IDs: `0020063` → `20063` * Preserve the original PDFs * Never overwrite an existing output PDF * Separate Input and Output folders * Add configurable naming templates: * `employeeid` * `firstname` * `middlename` * `surname` * `month I will select month` * `year I will select year` * Extract `Month` and `Year` from the original filename where available * Provide a live preview * Provide a Preview/Review table before processing * Export unmatched/duplicate/error reports * Include Undo for the current output run Match method: uses any 3 of the 4 CSV must
