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

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: Server と Data Center のみ - この記事は、サーバーおよびデータセンター プラットフォームのアトラシアン製品にのみ適用されます。

問題

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.



最終更新日: 2021 年 2 月 12 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.