How to import work log entries from Excel

Claus Wobbe

I need to import work log entries from Excel into Jira (V7.4).

I would use csv file format.

However in the manual it says:

_______________________________________

Importing worklog entries

Your CSV file can contain worklog entries. For example:

Summary,Worklog
Only time spent (one hour),3600
With a date and an author,2012-02-10 12:30:10;wseliga;120
With an additional comment,Testing took me 3 days;2012-02-10 12:30:10;wseliga;259200

To track time spent, you need to use seconds.

_______________________________________

Acc. this I should map the descriptive text to Summary

I assume time spent should be mapped to Time spent

But which Date field should I use for mapping the entry?

 

 

Alexander Eck [Tempo]

Here is a csv setup that I have used with the Jira csv import option.

Project Name,Project Key,Issue Key,Summary,Worklog,Project Type

Wikkkieea Cloud,WIKK,WIKK-23,Allow branching between Learning Objects,Branching;2020-6-7;taylor;14400,software

So you select the "," as the csv separator and split the "Worklog" with a ";" (description, date, author, timespent in seconds).

BR