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] · Accepted solution]

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

[Claus Wobbe]

Thanks a lot! One question: The "Summary" - is that the summary of the issue, or is it the description of the work that has been done by taylor on June 7?

Former case: Why is Summary needed when you have the issue Key to identify the issue?

Latter case: Then what is "Branching"?

[Alexander Eck [Tempo]]

Claus,

this was for an example I used with both importing an issue AND the worklog.

But of course you are correct. You only need the Issue key and the Worklog part.

BR

[Stephanie Dupré]

Hi, when i am trying to load such a file, there is no Worklog field proposed in the Map fields screen. How do you map Worklog ?

thanks

[Jeff Schefer]

Hi Stephanie

When I change the language to English (unter Attlassian account settings > Account preferences) and after that run the import, I can see the field called "worklog".
I hope that helps.

Best, Jeff