Import sub-task to existing task occur id valid selection problem

[Umi]

Hi everyone, I am using jira server v8.22.2

I would like to import 'sub-task' from CSV to JIRA linking the sub-tasks to existing task, and I already get parent id from export csv

The CSV is like:

when i import i cannot find mapping "parent_key"option, so i only use parent_id mapping to make parent-child relationship. and i have tried not using issue_id, or using parent_key to map the parent-child relation. it always appear parent id error. what should i do to fix this problem?

[Alex Koxaras _Relational_ · Accepted solution]

Hi @Umi 

Please read this guide here https://confluence.atlassian.com/adminjiraserver/importing-data-from-csv-938847533.html:

Creating sub-tasks

You can create sub-tasks of issues through a CSV file import by encapsulating this structure in your CSV file. To do this:

• The CSV file must have two additional columns whose headings should be named similarly to Issue Id and Parent Id.
• Ensure that each regular (non sub-task) issue is given a unique (sequential) number in the Issue Id column. Do not include any value in the Parent Id fields for regular issues.
• ***** ----> To create a sub-task of a regular issue in your CSV file, reference the unique Issue Id number of the regular issue in the Parent Id column. Don't set any value in the Issue Id fields for sub-tasks. <-----*****

[Umi]

hi @Alex Koxaras _Relational_ 

even i don't map the issue id but it still appear same error. does it means that i need to add one more row about issue-35692 and give it an id to map the relation?

using nevigator> system > external import> update issue to create sub-tasks?

[Alex Koxaras _Relational_]

I didn't have any problem importing tasks & subtasks together:

[Umi]

I mean with the following csv example I cannot map the parent id with exist task.

is Jira server only can import sub-task with a csv file with both task and sub-tasks? 

[Alex Koxaras _Relational_]

@Umi your csv, if you want to import ONLY sub-tasks, must be like below:

In your case, copy/paste the "parent key" to the "parent id" column and delete completely the "parent key" column.

I've tried it and it works.

[Umi]

it works!!!  Thanks a lot~

[Alex Koxaras _Relational_]

Great! Kindly mark my answer as accepted, in order to help others in this community with similar questions. Thank you!