CSV import of Jira issues with Insight custom field containing '-' or '(' or ')' failing
Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.
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.
Jira instance has Insight plugin installed
The Insight custom field value in the csv file contains special characters like '-' or '(' or ')'
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
Provide either the "Key" or "Label (Key)" in the CSV file for a successful Insight custom field import.