A simple application for automating the filling of work time records using Clockify reports in CSV file form.
Both the frontend and backend of the application are written in TypeScript using the Yarn package manager. To install the dependencies, run the following commands:
cd frontend/ && yarn --frozen-lockfile
# from the main project directory, use cd ../backend if you are in the frontend/ directory
cd backend/ && yarn --frozen-lockfile
To run the application, run the following commands:
cd backend/ && yarn start:dev
cd frontend/ && yarn start
These commands will run the application in development mode.
docker build -t clockify-work-time-record-frontend -f frontend/Dockerfile ./frontend
docker build -t clockify-work-time-record-backend -f backend/Dockerfile ./backend
To run the application, run the following commands:
docker run -p 3000:3000 -d clockify-work-time-record-backend
docker run -p 4200:4200 -d clockify-work-time-record-backend
The application contains Helm configuration files that allow you to automatically deploy the application to a Kubernetes cluster. To install the application, run the following command:
helm upgrade --install -n ewidencja-clockify ewidencja-clockify ./chart
The application requires a CSV file with the following structure:
"Date","Time (h)","Time (decimal)"
With data for the entire month. To export the appropriate file, follow these steps:
- Log in to Clockify
- Go to the "Reports" tab
- Select the "Summary" tab from the top navigation bar
- In the upper right corner, select the 'Last month' period (or another, if you want to fill the work time record for another month)
- In the lower part of the screen, select "Broup by" -> "Date", and (None)
- In the upper right corner, select "Export" -> "CSV"
- Save the CSV file in the appropriate place
- Open the file and verify that it contains the appropriate structure (see above)