README.md

What does it do?

This executable does:

1. open a template time sheet
2. update the details to match your name and date
3. save a copy of the time sheet with the updated details.
4. attach the updated time sheet to an email and send it

Quick start

1. Clone this repo.
2. Create a file called .config in the repository root directory.
3. Set up your details in the .config file:

{
  "employee_name": "The-Best-Employee",
  "microsoft_account_email": "TYPE_HERE_YOUR_MICROSOFT_ACCOUNT_EMAIL",
  "microsoft_account_pass": "TYPE_HERE_YOUR_MICROSOFT_ACCOUNT_PASSWORD",
  "email_to": "[email protected]",
  "email_subject": "Weekly time recording",
  "email_body": "<p>Hi Joe!<br>Here my records <b>:)</b></p>",
  "xlsx_template_path": "C:/Users/The-Best-Employee/template-time-sheet.xlsx",
  "delete_temp": "True"
}

4. Run timesheet.exe.

Configuration file (.config)

• employee_name: your name as shown in the time sheet template.
• microsoft_account_email: your Microsoft Account email.
• microsoft_account_pass: your Microsoft Account password.
• email_to: person to receive your email.
• email_subject: email subject.
• email_body: email body, interpreted as HTML.
• xlsx_template_path: absolute path to the time sheet template.
• delete_temp: set this value to False to remove temporary files. Otherwise, any temporary files will be deleted.

This file will only be locally for safety. DO NEVER make it public or commit it (it's listed under .gitignore on purpose).

TODO

• Support HTML in the email body.
• Remove unnecessary dependencies to reduce the binary size.