Issue about worklog update via CSV import

[Stefano Colagiacomo]

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 

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?

[Marc Koppelaar]

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]

Hello @Marc Koppelaar 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 Koppelaar]

Hi @Stefano Colagiacomo 

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