社区创作者 0810

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