Automated Biometric Report Scheduler on Windows
Budget: ₹1,500 – ₹12,500 INR
I run an eSSL face-recognition attendance system and every day I still have to open the bundled software, export the attendance report and mail it out. I’d like to hand that chore to a Windows-based task so, at several fixed times throughout each day, the exact same report is pulled and automatically emailed—always in the original Excel format and always to a single, predefined address.
Here’s what I need you to set up:
• A script or small utility that runs on Windows, connects to the eSSL application or its database, generates the standard attendance report in Excel and saves it locally.
• A reliable scheduling mechanism (built-in Task Scheduler, PowerShell, Python with Windows service—whatever you find most robust) that can trigger the job multiple times a day at the specific times I specify.
• Automatic emailing of that freshly generated Excel file to one fixed recipient, using my SMTP credentials or Outlook profile without manual intervention.
Acceptance criteria: after installation I can adjust the trigger times myself in Task Scheduler, click “Run” to test, and see the email arrive with the correct Excel file attached. Everything must persist after a reboot.
Once it works on my test day, we’re done. Please include a brief setup guide so I can re-point it to another PC in the future.
Here’s what I need you to set up:
• A script or small utility that runs on Windows, connects to the eSSL application or its database, generates the standard attendance report in Excel and saves it locally.
• A reliable scheduling mechanism (built-in Task Scheduler, PowerShell, Python with Windows service—whatever you find most robust) that can trigger the job multiple times a day at the specific times I specify.
• Automatic emailing of that freshly generated Excel file to one fixed recipient, using my SMTP credentials or Outlook profile without manual intervention.
Acceptance criteria: after installation I can adjust the trigger times myself in Task Scheduler, click “Run” to test, and see the email arrive with the correct Excel file attached. Everything must persist after a reboot.
Once it works on my test day, we’re done. Please include a brief setup guide so I can re-point it to another PC in the future.