How to import multiple new stories that are linked to one new story

Murat Stardustmedia

I try to import via CSV multiple new stories. All but one of them (let's call them Sub-Stories) should be linked "Relates to" to that one story (let's call it Main-Story). 

So in my CSV I have a column "Issue ID" and a column "Relates to".

The Main Story has the value 1 in the column "Relates To".
All Sub-Stories have the value 1 in the column "Issue ID".

The validation shows no error. But after the CSV-import, only one Sub-Story is actually linked with "Relates to" to the Main-Story. All other Sub-Stories are missing the link. 

What am I doing wrong?

Petter Gonçalves

Hello Murat,

Welcome to Atlassian Community!

To properly link stories with a specific Story in your CSV file, you must place the issue id of the "sub-Stories" in the column "Relates to" of the "Main-Story", however, you must use different Issue IDs for each "Sub-Stories".

That been said, you can not add the same value "1" as the issue ID for all the "Sub-Stories" that are been importing. You must add different values to each "Sub-Stories" (1,2,3, etc) and configuring a new "Relates to" column in the "Main-Story" for each issue ID.

Here's a practical example:

Summary,Issue Id,Relates to,Relates to,Link Two House&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span>&nbsp;</span>1 ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span>&nbsp;</span>2 ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span>&nbsp;</span>3 ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span>&nbsp;</span>2 Patio&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span>&nbsp;</span>2 ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , Garden ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span>&nbsp;</span>3 ,&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,

The file above would create three issues with correctly created issue links:

• Issue 'House' will have three links:
  • Two links of type "relates to" to issue 'Patio' and 'Garden'
  • One link of type "Link Two" to issue 'Patio'

For more information regarding this feature, you can check the documentation below:

- How to Import Issue Links from a CSV File

Let me know if you still have any questions.