Export CSV files from Clockify and import them into the Mission Timecards and save about 10-20 minutes per week 😁
- Processes right from Clockify's format, no additional actions needed
- If multiple time entries result in the same Activity Type and Description, the time is added so you don't get duplicated time slips
- It's fun
Clone the repository:
git clone git@github.com:vlasscontreras/clockission.git
Install the dependencies:
composer install --prefer-dist
Copy the .env.example
(and update your credentials):
cp .env.example .env
In Clockify, make sure your time entries have the following format:
[Activity Type]: [Description]
Where Activity Type can be one of the following:
- Communication
- Planning
- Production
- Review
Example:
Production: PS-9999
Then, export a report from Clockify in CSV format, with whatever dates you want, and place it wherever you want. Next, use this command:
php cm upload-slips /path/to/csv
Done! 😃
All those that are present in the .env.example
file.
To send a request to the Mission "API" so they are assigned to your profile properly.
👀 For the curious ones... (click me)
You can see more details about the usage of your credentials and the interaction with the Mission "API" in the
src/Mission/Commands/UploadSlips.php
and src/Mission/Client.php
files.
Go the timecards page and choose your option from the Select Team dropdown, then open the Browser Developer Tools, go to the Console, and put the following statement:
document.getElementById('time_slip_team_id').value
The output will be the team ID.
Go the timecards page and open the Browser Developer Tools, go to the Console, and put the following statement:
document.getElementById('time_card_id').value
The output will be the time card ID.
Go to Reports > Detailed, select Team, Client, Project, etc. and then click the Export dropdown and select the Save as CSV option.
Clockify documentation: Customize exports.
🤷🏻♂️
The Clockission project is open-sourced software licensed under the MIT license.