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:

[Yogesh Mude]

in the parent fiedl mapping you need to map it to Parent but not to Link.

[Kevin Hoang]

@Yogesh Mude There isn't a "Parent" option to map the Parent column in my CSV. Note that I'm doing this in a work management project (not software project) so the process for mapping may be different.

I've been trying to following the Jira docs, but they're all written for software projects so a lot of the steps just don't make sense for work management projects.

[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.

[Yogesh Mude]

@Kevin Hoang I double check and even if you do the CSV import for Work Management project still you have to select the Parent only.

Actually i recorded the CSV import video but im not able to attach to it due to file extension.

Also, make sure you should do the CSV import from the Jira admin setting --> External system import.

[Yogesh Mude]