How to create CSV with relationships to Epic/Story/Sub-tasks

[Pradheep Ayyanar]

I have my scope to import csv which should create an Epic, Story and sub tasks in a single import.

Summary, Issue Type, Issue Id, Parent

First Epic, Epic, 1, 

First Story, Story, 11,1

Second Story, Story, 22,1

Third Story, Story, 33,1

First sub-task, Sub-task, 111,11

Second sub-task, Sub-task, 222,11

it fails with all the possible ways i could.

I had imported separate with Epic and Story with epic link added.

Can someone help with a template that should import all in a shot.

[Pradheep Ayyanar · Accepted solution]

@Mohanraj Thangamuthu I tried and didnt work

my parent here is the story

[Mohanraj Thangamuthu]

Hi, on the parent column use the issueid instead of issuekey.

[Pradheep Ayyanar]

Thanks Mohan, but it didnt work and throwing this error and successfully imported creating issues in the project without any relationship

[Mohanraj Thangamuthu]

Hello Pradeep, Parent issue is already present in the site or its part of the .CSV file ?. 

[Pradheep Ayyanar]

its already created and i had managed now with the file and imported.

thanks for your support.

[Pradheep Ayyanar]

Thanks Mohan

let me take a quick look at to close this thread if all works 

[Pradheep Ayyanar]

Thanks @everyone for the help and I had it resolved. Closing this thread

[Luka Hummel - codefortynine]

Hi @Pradheep Ayyanar

If you are struggling with creating a functioning CSV template with the issues being linked correctly, and are willing to use a third-party app, you can try our app Deep Clone for Jira. You can create a template in Jira and then clone the template with Deep Clone.

[Mohanraj Thangamuthu]

Hello, Good day. Please refer to the screenshot available in https://confluence.atlassian.com/jirakb/csv-import-parent-child-mapping-1096095688.html