Being a contractor at the end of every other working week I have to log my working time into system called Gusto (https://gusto.com). Gusto has not very userfriendly interface. It takes me from 30 minutes to 1 hour to add data into that system. Additionally I have to send info table with the same data to my manager via email. I am not a fan of work duplication as well as repeat same dummy actions every other week. So I decide to use an Excel file as a source of truth. Every new spreadsheet will define biweely working period in some format. Excel file will be parsed, records collected and data populated into Gusto time tracking system.
All data is loged into BiWeekly Status
For example:
| Date | Start Work | End Work | Start Break | Break Duration | Description |
|---|---|---|---|---|---|
| 3/15/21 | 9:00:00 AM | 6:30:00 PM | 12:30:00 PM | 30 | qTest - TESLA Integration |
| 3/16/21 | 9:00:00 AM | 6:00:00 PM | 12:00:00 PM | 45 | qTest - TESLA Integration |
secrets.properties file holds user_email & user_password props that will be used to login into Gusto. File should be created under src/main/resources
Run GustoTracker.java and less than a minute you will have something similar to this:
I have used my lovely Selenium which I have never worked with for commercial projects, but that supports so much when you need to mimic user action on UIs.