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?

[Vhee Van]

@Ilsa Loving 

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 

[Marc - Devoteam]

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 - 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]

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.

[Ilsa Loving]

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.