Need to add 'time spent' values to existing total in ticket instead of overwriting (CSV import)

[Garrison Thomson]

Desired behavior:

I am trying to import tickets into JSM from a different ticketing system. Some tickets in the CSV file have multiple entries because time was logged at different stages throughout the life of the ticket (30 min here, an hour there, etc). When importing into JSM, I'd like those rows to be merged into a single ticket AND the time spent added together to display an accurate total.

Current behavior:

JSM is great at merging rows that have the same issue key but it isn't adding up the time spent. It is simply overwriting that field with the last imported value. For example, if a ticket had 30 minutes logged and then one hour logged the ticket would display only one hour in the time tracking field once imported into JSM.

Is there any way I can have the time spent added up during import, or will I need to somehow use SQL to do this work prior to import?

Thanks for any assistance!

[Joseph Chung Yin · Accepted solution]

@Garrison Thomson -

Hi Garrison:

Please take a look at the section "Importing worklog entries " in the following link - https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/

Through External System Import from the Systems gear, your CSV file should have the following template where you will have multiple worklog columns (each of them contains a value NOTE - in seconds)

Example - 

IssueType	Summary	Description	Worklog	Worklog2
Task	Test2	This is a demo	3600	7200

You will map both worklog and worklog2 against the same Worklog field, this is way how you can capture multiple worklogs (time spent).  Once the issue is created in Jira/JSM, then the issue itself will have the overall time spent automatically.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

[Garrison Thomson]

Thank you Joseph! That worked great.

I should note for others that initially I tried mapping my CSV worklog fields to the "Time spent (in seconds)" field in JSM but this did not work. It needs to be the "Worklog (in seconds)" field.

Thanks again!