CSV import | Error after Importing CSV file in Jira cloud - Cannot add value [ [xxxx] ] to CustomField Parent Link in Issue with summary 'xxxx'
Summary
Upon performing Import with CSV file encountered with error below:
Performing CSV import customer noticed the below error :
Cannot add value [ [TEST-86] ] to CustomField Parent Link in Issue with summary 'TEST 1| Test'. Probably value was in incorrect format
Environment
Jira cloud
Diagnosis
There should be no Restriction/condition/validation set on workflow for Create on the desired Issue Type.
User should hold Create Issue permission on the destination project.
Cause
The reported error could have been encountered as a result of attempting to Map Task Issue 1 as a Parent of another Task Issue 2. The issue Type of the same hierarchy level should not be mapped as Parent and child. Rather,This can be linked them with an Inward or outward link.
Solution
Please update your CSV file as per the recommendation below. Issue 1 and Issue 2 are linked as Blocks "Issue link relation" and subtasks as parent-child and attempt to import the issue.
In the below table Inward Issue Link(Blocks) specified Linked Issue relationship of Issue-1 and Issue-2 as "Blocks" Issue relation and Parent field value is Isuse Id of Parent of the children or substask in this case it is Issue Id =2 for Issue key Issue-2
| Summary | Issue key | Issue id | Issue Type | Inward issue link (Blocks) | Parent | |
| Migration to Jira from PM | Issue-1 | 1 | Task | |||
| Phase 1 | Issue-2 | 2 | Task | DTP-1 | ||
| Sort Projects by Active or non-active | Issue-5 | 5 | Sub-task | 2 | ||
| Identifying and Sort all Project on Project Manager by Team | Issue-4 | 4 | Sub-task | 2 | ||
| Pilot (FI) | Issue-3 | 3 | Sub-task | 2 |
Untitled spreadsheet - Sheet1 (5)_2024-06-21T07_00_41.279Z.csv.
Kindly refer to this screen recording and reference CSV file for demostration steps:
Untitled spreadsheet - Sheet1 (5)_2024-06-21T07_00_41.279Z.csv
Screen Recording 2024-06-21 at 12.20.01 PM_2024-06-21T07_09_49.712Z.mp4