프롬프트 도감 › No.2470
파일 이름 자동 변경 관리자 페이지
File Renaming Admin Portal
CSV 정보와 맞춰 PDF·JPG 파일 이름을 규칙대로 바꾸는 관리자 웹페이지를 만들어 줘요. 로그인, 현황 화면, ZIP 내려받기, 결과 보고서까지 들어 있어요.
이럴 때 급여명세서 같은 파일 이름 정리, 사내 관리 도구 만들기, Google Apps Script 연습
도구 ChatGPT · Claude · Gemini
프롬프트
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.팁
- 파일 이름 규칙 예시를 먼저 정해 두어요
- CSV 칸 이름을 실제 파일과 똑같이 써요
출처
권리: CC0 (f/prompts.chat). 자유 사용. 기여자: [email protected].