Issue about worklog update via CSV import

Stefano Colagiacomo
Contributor
October 19, 2023

Hello I have an issue with csv import.

 

I m doing the procedure via External system Import via csv, I never have a big problem with this procedure, but now I can't import the field "worklog".

 

I attach an example of my csv Screenshot 2023-10-19 alle 12.14.13.png

When I start the process Issue Key and Summary are correctly upload but not the Worklog column, I recive this error:

Exception occurred parsing worklog '28/06/2023;stefano.colagiacomo@test.it;1994400'
Could you help me?

2 answers

0 votes
Vhee Van November 15, 2024

@[deleted] 

Make sure your csv data looks like following format

2023-06-28 12:30:10;stefano.colagiacomo;1994400

And set the time format in the import wizard like this yyyy-MM-dd hh:mm:ss 

 

0 votes
Marc - Devoteam
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 19, 2023

Hi @Stefano Colagiacomo 

It probably has to do how the cell info is presented to Jira, mostly to date time notification

If you didn't change any date/time formats in Jira, the import for a worklog should look like;

Date/Time;User;Time Spent in seconds

2023-06-28 12:30:10;stefano.colagiacomo@test.it;1994400

You can make sure how it looks, if you make an export with worklogs and open that in notepad or another editor, this will show exactly how the date time is used in Jira

Stefano Colagiacomo
Contributor
October 19, 2023

Hello @Marc - Devoteam thank you. I try to make an export but I can't see any field called "worklog" maybe the problem is like this, when I try to make the mapping I can see the Worklog not custom field but Issue fields. 

So I think that your idea was make an export see the format and copy same format and than make the import, you're right but I cant obtain that field...

Marc - Devoteam
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 19, 2023

Hi @Stefano Colagiacomo 

Select the Original EstimateSpent Time and Remaining Estimate fields in your overview of the issues you want to export and then use the "Selected fields" export option.

Deleted user September 7, 2024

I'm having the same problem.  I've made sure the date/time is in the above format (assuming 24h time since there's no am/pm).  I've tried the user accountid, displayname, email... nothing works.  It only imports the worklog if I provide the seconds, but then the entry is attributed to the importer instead of the correct user.

 

Doug Slay December 10, 2024

.

Suggest an answer

Log in or Sign up to answer