Using CSV Importer - get warnings when trying to link tasks

[David Blake]

I am going to have to make a lot of jira tickets so that will have epics, tasks, subtasks, and linkages. I thought I would use the CSV importer to make my job easier. 

Linking parent and child relationships is working no problem, but when trying to specify linkages between tasks (eg. "relates" or "blocks") I am getting these warnings:

The validation process has found 7 warning/s

• Issue link 'Blocks' between '3' and '9' cannot be created - at least one of the issues couldn't be found.
• Issue link 'Relates' between '3' and '6' cannot be created - at least one of the issues couldn't be found.
• Issue link 'Blocks' between '4' and '10' cannot be created - at least one of the issues couldn't be found.
• Issue link 'Relates' between '4' and '7' cannot be created - at least one of the issues couldn't be found.
• Issue link 'Blocks' between '6' and '9' cannot be created - at least one of the issues couldn't be found.
• Issue link 'Relates' between '6' and '3' cannot be created - at least one of the issues couldn't be found.
• Issue link 'Blocks' between '7' and '10' cannot be created - at least one of the issues couldn't be found.

I am just trying to link on the Issue Id column ids

Here is the CSV I am using:

Issue Type,Summary,Description,Issue Id,Parent,Relates,Blocks
Epic,[Import test] Epic Test 1,This is a description for Epic 1,1,,,
Task,[Import test] iOS tickets,This is a description for Task 1,2,1,,
Sub-task,[Import test] iOS tickets - subtask 1,This is a description for iOS Subtask 1,3,2,6,9 
Sub-task,[Import test] iOS tickets - subtask 2,This is a description for iOS Subtask 2,4,2,7,10 Task,[Import test] Android tickets,This is a description for Task 2,5,1,, 
Sub-task,[Import test] Android tickets - subtask 1,This is a description for Android Subtask 1,6,5,3,9 
Sub-task,[Import test] Android tickets - subtask 2,This is a description for Android Subtask 2,7,5,,10 
Task,[Import test] CAL tests,This is a description for Task 2,8,1,, 
Sub-task,[Import test] Remove CAL test 1,This is a description for CAL Subtask 1,9,8,, Sub-task,[Import test] Remove CAL Test 2,This is a description for CAL Subtask 2,10,8,,

 
Does anyone know where I am going wrong?

[David Blake · Accepted solution]

Ok I just decided to go ahead and import anyway. Turns out its just a problem with the validator. Importing did the linkages no problem using using just the Issue Id column

[Marc - Devoteam]

Hi @David Blake 

Welcome to the community.

Simply said, you need to reference issue links the same as parent child.

See this KB article, it says it only applies to Server and DC, but the same logic should apply to Cloud.

how-to-import-issue-links-from-a-csv-file-in-jira 

So you need to make 2 imports.

Initially import your issues, then import the links based on the created issues key

[David Blake]

Hi Marc,

Yeah - thats what I am doing (see my CSV example). 

I haven't actually tried all the way importing yet as I got the warnings. Should I try anyway then?

[Marc - Devoteam]

Hi @David Blake 

I just made an edit on my previous comment.

It's a 2 step process.

The messages you receive are correct. Linking can only be established when the issue exits.

On the initial import Jira is not aware of your issue yet 

[David Blake]

Ahhh I see. So I do the first import. Then I have to go through a build a table of all the Jira ticket Ids (eg. IOS-12345, AND-54321) - then work out the links and report that?

No way to use the Issue Id column as per setting the parent-child then?