-
Bug
-
Resolution: Done
-
High
-
7.2.8, 7.3.1
-
7.02
-
46
-
Severity 3 - Minor
-
17
-
-
Expected Behavior
Issues will be imported based on the ID specified in CSV file, which will be discarded after the import process is complete. This scenario is suggested when importing issues and subtasks on Importing data from CSV - Encapsulating JIRA data structure in your CSV file
Actual Behavior
The values to the Issue ID field during a CSV import are saved to an "External Issue ID" field. When performing new imports, they will usually not work properly because it's rather difficult to find unique ID values. We should have two different options upon import: "Issue ID" - a value that will only be used within that import process to link issues; and "External Issue ID" for when users want to map the ID that came from the source system.
Steps to Reproduce
Try to import a file containing the following data twice, mapping "id" to "Issue ID" and "parent id" to "Parent ID".
id,parent id,summary 1,,"Test" ,1,"Test sub-task"
The value set on "Issue ID" will be replicated to the "External Issue ID" value of the issue with summary "Test". Upon a new import, it will skip that issue and register the following on the import log:
External issue 1 already exists as PROJ-1, not importing.
Workaround
Find a unique value to use in that field. You may use the below database query to make it easier.
SELECT * FROM customfieldvalue WHERE customfield IN (SELECT id FROM customfield WHERE cfname = 'External issue ID');
or delete the External issue ID field after each import.
- followed by
-
JRASERVER-76235 Enhancement of External System Import Functionality – Introduction of Stateless and Stateful Import Options
- Gathering Interest
- relates to
-
JRASERVER-64477 New "External issue ID" field is created on each import
- Gathering Interest
-
RAID-3171 Loading...
- was cloned as
-
JRACLOUD-81999 Values mapped to "Issue ID" field upon import will be saved to "External Issue ID" custom field
- Gathering Impact