Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,501
Community Members
 
Community Events
165
Community Groups

Import SLA Values to custom field via CSV

Edited

We are trying to do an import of data via external import CSV. We would like to retain the last values of the previous SLAs that were on those issues. They do not have to be calculated but I am having trouble trying to find the format that they should be in order to just import and map the values. The value that shows in the export shows as a decimal number. How can I re-format that and import it to a "Legacy Time to First Response" field? and if at all possible maybe a value of "breached - 8h30m" "Completed- 2h" . Any suggestions would be much appreciated!
SLA values in CSV import.png

1 answer

0 votes

Hello @Allison Smith

Thank you for reaching out.

By default, the SLA fields are not exported from Jira Cloud sites in the format displayed on your CSV export.

By default, the SLA fields are exported in the format "hh:mm", as in the example below:

 Issue key  Status  Custom field (Time to first response)
 ITSAMPLE-20  Open  -671:36
 ITSAMPLE-19  Pending -671:36

That being said, I believe the SLA on your issue might be corrupted. Can you please provide us with a screenshot displaying them on Jira UI?

Also, please notice that the SLAs can not be imported directly on Jira through CSV. There's a feature request to consider this feature:

As a workaround, you may perform manual recalculation once import the issue. This will only work if all the issue history is imported as well (Using JSON instead of CSV). For more information about recalculation, kindly refer to Missing or corrupted SLA data in Jira Service Management documentation.

Additionally, feel free to vote and watch the suggestion to increase its priority and also receive notifications about any updates.

Let us know if you have any questions.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
Community showcase
Published in Jira Service Management

Coming Soon: Insight Changing to Assets

The 2020 acquisition of Mindville added powerful asset and configuration management capabilities to Jira Service Management in the form of Insight. Following the completion of that integration, custo...

289 views 2 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you