🚀 You are a Freelancer? Save time now for free.

JIRA Clockwork CSV Import

Robert Reiz Robert Reiz | March 30, 2023 | 12:50 UTC
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".

JIRA Clockwork CSV Import at ZEIT.IO


The upload form looks like this:

Upload form for the JIRA Clockwork CSV Import


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.

Success message after Clockwork CSV import


Are the times created twice if I upload the same file twice?

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.

Can I find out later which times were created by the CSV import?

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. 

Upsource filter at ZEIT.IO


Can I delete all time entries from an import at once?

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. 

What exactly does a JIRA Clockwork CSV file look like?

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

  • Started at
  • Time Spent (seconds)
  • Issue Key
  • Issue Summary
  • Comment

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