Work Management CSV import not working with sub-tasks

[Kevin Hoang]

Hello,

I'm in the process of migrating from Asana to Jira and need to do a historical import of tasks and sub-tasks.

I'm using the import tool available in the all work items view:

I've organized a test CSV import file with the requirements listed here: https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/

This is how I'm mapping the fields:

However, I get this error in the validation process:

[Kevin Hoang]

I've spent several hours trying to follow the docs, but still can't get the import tool to correctly assign the sub-tasks to a parent even though I following the example format.

Here's my CSV:

Work item ID,Work type,Parent,Name
1,TASK,,Asana import test
2,SUBTASK,1,Test sub-task 1
3,SUBTASK,1,Test sub-task 2

Here's the mapping the import tool. Note: This is for Jira Work Management - not Jira Software.

Here's the error I'm getting from the validation tool. You can see that the tasks are created successfully, but when trying to link sub-tasks to task "1", it can't find task "1" even though this parent task is created first:

[Prachi Bolar]

Hello,

Welcome to the community :) 

Please check this article on how to check for the parent child relationship while importing data :https://support.atlassian.com/jira/kb/keep-issue-parent-child-mapping-during-csv-import-to-jira-cloud/

Thank you,

Prachi

[Yogesh Mude]

@Kevin Hoang  Welcome to the community!

As ai can see in the mapping, you have selected Link type in the Parent which is Incorrect.

WorkType, Summary, FixVersion, FixVersion, FixVersion, Component, Component, Work item ID, Parent, Reporter 
Bug, "First work item", v1, , , Component1, , 1, , abcde-12345-fedcba 
sub-task, "Second work item", v2, , , Component1, Component2, 2, 1, fedcb-12345-edcba

If you see in the above exapmle, the work item ID of the Bug will be Parent for Sub-task.

 And you have to map the Parent with Parent field only. For details pls take a look at https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/ article.