How do I create parent child relationship using csv import

[rbalamu2]

I wanna import 1000 of issues with parent child relationship. Kindly someone help!

[Nic Brough _Adaptavist_]

You need two additional columns in your CSV.

One for a unique identifier for each issue you are importing (not a Jira issue key, just unique within the CSV) and a second one that you'll map to "parent issue", which, for each sub-task, contains the unique identifier of the parent issue you're importing.

[rbalamu2]

Hi @Nic Brough _Adaptavist_ ,
Thanks for your reply. 
I have the below sheet as csv

Issue Type	Epic Name	Summary	Status	Description	Issue Id	Parent Id
Epic	Diagnostics : Implement Visteon Manufacturing specific diagnostics functionalities	Parent Epic - [JLR CCCM] : CarPlay : WiFi Disconnection	No Specs	Parent Epic - description	102
Story	Diagnostics : Implement Visteon Manufacturing specific diagnostics functionalities	story - Summary	No Specs	story - Description		102

I am trying the import the same, Issues are newly created properly but I can't get the parent child linkage between the two.


kindly someone help!

[Nic Brough _Adaptavist_]

Ok, so you're talking about the Epic : Story relationship, not story : subtask

Your import is failing because

1) you are trying to put an Epic name on a Story.  The field does not exist for story-level issues, you can only put an Epic name on Epics

2) you have told it that one of your stories has a parent issue.  Stories are not sub-tasks, they don't have that parent/child relationship

The language people use here is unclear and confusing on a technical level  - we often talk about "parent child" relationships in the hierarchy interchangably, but they are different things in the code and data.

Take, for example, a typical hierarchy in Jira:

Initiative is a parent of Epics, the Epic is a parent of Stories, the Stories are a parent of sub-tasks.

But in Jira's code and data,

• Initiatives are linked to Epics
• Epics have a name which is displayed when a Story belongs to an Epic via an Epic Link
• Stories have sub-tasks

All of those can be described as "parent/child", but they're all totally different structures.

To make a story belong to an Epic, you need to set its Epic Link to the name of the Epic you want it to belong to.