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?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Issue about worklog update via CSV import

Stefano Colagiacomo_kynhw6

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?

Accepted answers

All comments

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_kynhw6

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.

unknown

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.

Vhee Van

@[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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server