CSV import of Jira issues with Insight custom field containing '-' or '(' or ')' failing

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

Problem

When trying to do a CSV import of issues with Insight custom field, user is getting an error :  

Cannot add value [ [MyObject-1] ] to CustomField Configuration Item test in Issue with summary 'Test with error on -'. Probably value was in incorrect format

At the end of the import, the issues get imported correctly, but the Insight custom field is not updated with values.

Diagnosis

Environment

  • Jira instance has Insight plugin installed

Diagnostic Steps

  • The Insight custom field value in the csv file contains special characters like '-' or '(' or ')' 


Cause

Insight custom fields are different from the regular Jira custom fields. As mentioned in this documentation Insight stores the value of custom fields in 2 parts : "Key" and "Label".

If you create your own CSV file and want to connect an Insight object, you must use the "Key" or "Label (Key)" pattern. So, for a successful csv import, the user should provide either the "Key" or a combination of both "Label (Key)" in the CSV file.

In this case, the user CSV file only has a "Label" and not the "Key" value. So this import will not work.


Sample incorrect csv : 

Issue key,Issue id,Status,Created,Updated,Custom field (Organizations),Custom field (Computer),Summary
SP-26,40424,Escalated,26/Jan/21 5:46 PM,12/Feb/21 11:46 AM,2,test-1234,test import

In this case the import failed because Jira is trying to map 'test-1234' which is a "Label" with the "Key" which it expects to receive and hence it is not able to map this value "test-1234" with an existing Insight custom field value.


Sample correct csv : 

Issue key,Issue id,Status,Created,Updated,Custom field (Organizations),Custom field (Computer),Summary
SP-26,40424,Escalated,26/Jan/21 5:46 PM,12/Feb/21 11:46 AM,2,test-1234 (RPS-7971),test import


Resolution

Provide either the "Key" or "Label (Key)" in the CSV file for a successful Insight custom field import.



Last modified on Feb 12, 2021

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.