ZEIT.IO is a platform on which you can manage your experts (freelancers & permanent employees). ZEIT.IO digitizes the business processes of agencies that invoice according to time and material. These include contracts, budget monitoring, time recording, an approval process (in which your customer can also be involved) and an invoicing module that can automatically create invoices/credit notes.

Clockwork is an integrated time tracking solution for JIRA, which is already used by many companies and professionals. Clockwork offers a CSV export of the recorded times. The file contains the booked times with date, start time, duration, comments, projects and many other columns. Since we absolutely want to avoid recording times twice, now there is the option of importing a CSV file from Clockwork into ZEIT.IO. The recorded times are then available for the billing processes.

In the dropdown for time tracking, there is now a fourth option "JIRA Clockwork CSV Import".

The upload form looks like this:

Of course you have to select a project to which the imported times should be mapped. The input for "Activity column" is optional. If a column is specified here, then this column is treated as a ZEIT.IO activity. If the values in the column have not yet been created as an activity in the ZEIT.IO project, they will be created during the import process.

Depending on the file size, the import may take a few seconds. If everything went well, you will be redirected to the times you just imported and a success message will be displayed.

No! The times that are uploaded via this upload form are provided with special meta tags and can thus be recognized later. If you upload the same file twice, the entries from the previous upload will be deleted and replaced with the data from the current upload.

Yes! All recorded times have a so-called "upsource" and the times can be filtered according to different upsources. If you set the upsource filter to "JIRA Clockwork CSV Import" then only times are displayed which have been created by this import. 

Yes! You can filter for the desired time range and you can set the upsource filter to "JIRA Clockwork CSV Import". After that you can select all, witch one click on the checkbox in the left upper corner of the table, and then you can delete all selected items with one click. 

Depending on the configuration, the CSV file can contain different columns. The following columns are absolutely necessary for the upload to ZEIT.IO:

Optionally there should also be a column that can be used for activities. You can download an example file here.