Username in CSV Import

Question

I'm trying to import a csv file with worklogs but I keep getting an error for "Importing users" and in the log file for the import it says: "

Exception occurred parsing worklog 'TaskId: 71310 - Deployment til PRD;06-10-2021;jimmy.due;1800'. It will be skipped

In this case I tried using "jimmy.due" as user but I've also tried jd, my email and my AccountID. All of them failed and no worklogs are imported.

As per https://tempo-io.atlassian.net/wiki/spaces/KB/pages/341377322/Import+worklogs+using+the+native+Jira+csv+import+-+JIRA+Server+and+Data+Center I have following specified in my csv file:

Project Name,Project Key,Issue Key,Summary,Worklog,Project Type
ProjectName,ProjectKey,IssueKey,Summary,"Description;date;Author;Seconds";Software

What am I missing? what do I use as Author/Username?

Or is it something entirely else since it's skipping the worklog?

Jimmy Due · Answer

Hi Pavel.

I tried stripping my csv file to contain just Summary, Worklog like the third line above in your example.

Then I had to choose which project it was concerning since it wasn't defined in the csv anymore.

It created a new issue this time around but still not able to process the worklog.

Exception occurred parsing worklog 'TaskId: 71310 - DSU;01-11-2021;jd;1800'. It will be skipped

So it seems it's a problem with the formatting or values in this snippet. I'll try converting the date to another format to see if that helps.

I'm still not sure if there's a problem with the Author/Username though.

In the top og the log it says:

INFO - Import started by jd using com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean

"Import started by jd"

But further down in the log it says:

0 users associated with import. All of them imported as inactive, this can be changed after import in User Access step.

This message is the same though regardless of what I type as Author.

Pavel Junek · Answer

Hi Jimmy,

It looks like you're looking at the Tempo documentation for Jira Server only, but you're using Jira Cloud.

I found general information for importing Worklog into the Jira cloud at Import data from a CSV file :

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

Note that you need to use seconds in order to track time spent.

Pavel