Reporter Application
Version 1.1.01
A dedicated client-server application designed to automate the workflow for specific weekly Excel report editing and submission, ensuring accuracy and timeliness.
Request Info
Key Features
Core Workflow & Automation
- Automated File Retrieval: Intelligently fetches the correct weekly report file or the master template.
- Seamless Excel Integration: Automatically launches and monitors the correct Excel file.
- Automated Submission: Uploads the modified report back to the server upon closing Excel.
- Server-Side Processing: Triggers backend PDF conversion and email notifications.
- Correct File Focus: Ensures users always work on the single, centrally managed file for the reporting week.
Report Management
- Centralized Master Templates: Admins manage base templates centrally via the server.
- Weekly Instance Handling: Automatically manages saving/retrieving the specific file for each week.
- Consistent Naming: Enforces correct server-side filenames (`YYYY-MM-DD - Report Name.xlsx`).
- Temporary Local Files & Cleanup: Uses a local temp directory securely and cleans up automatically.
User Experience & Security
- Secure PIN Authentication: Application-specific PIN login for users.
- Terminal Identification: Logs and identifies the client machine.
- Role-Based Report Access: Users only see assigned reports.
- Simple Client GUI: Clean interface for login and report selection (Python/Tkinter).
- Client Configuration: Uses a simple `config.json` for setup.
Infrastructure & Admin
- Automatic Client Updates: Built-in mechanism checks for and applies application updates.
- Standalone Installer: Deployed via user-friendly installer (Inno Setup).
- Admin Web Panel: Server-side interface for comprehensive management (reports, users, permissions, logs).
- Automated Email Notifications: Configurable alerts with PDF reports sent on completion.
- Data Validation (Optional): Server can compare submitted data against external CSVs and flag discrepancies.