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:
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.