­čÜÇ Sie sind Freiberufler:in? Jetzt kostenlos Zeit sparen.

JIRA Tempo CSV Import

Robert Reiz Robert Reiz / 04. April 2023 / 08:45 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.

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

In the time tracking drop-down, the third option is now "JIRA Tempo CSV Import".

JIRA Tempo CSV Import

The upload form looks like this:

JIRA Tempo CSV Import Form

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.

Also optional is the username. If you provide a username value, then ZEIT.IO expects that the CSV file contains a column "Username" and it will only import the lines where the username is a match. If no value is provided then all lines are imported. 

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.

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 Tempo 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 Tempo 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 Tempo 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:

  • Work date
  • Hours
  • Issue Key
  • Issue summary
  • Username

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