CSV File Import

[Shaun Parker]

Good afternoon.

I am trying to import a number of issues using the CSV Import tool .. but I have hit a snag.

I want to import Issue Links and also Sub-Tasks, I am not sure how to do this.

I am importing using a standard CSV file.

Example of the Issue Links

Can anybody please provide some assistance?

Thanks

Shaun

[Petter Gonçalves]

Hello Shaun,

Thank you for reaching out!

To import sub-tasks to JIRA, you must add a new Parent ID column in your CSV, which will receive the Issue ID of the parent issue related to that sub-task. these are the specific steps:

1 - Your CSV file requires two additional columns whose headings should be named similarly to Issue Id and Parent Id.

2 - Ensure 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.

3 - 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. Do not include any value in the Issue Id fields for sub-tasks.

For example:

IssueType, Summary, FixVersion, FixVersion, FixVersion, Component, Component, Issue ID, Parent ID, Reporter
Bug, "First issue", v1, , , Component1, , 1, , jbloggs
Bug, "Second issue", v2, , , Component1, Component2, 2, , fferdinando
Bug, "Third issue", v1, v2, v3, Component1, , 3, , fferdinando
Sub-task, "Fourth issue", v1, v2, , Component2, , , 2, jbloggs

In the example above, the fourth issue will be sub-task of the second issue upon import, assuming you match the 'Issue ID' and 'Parent ID' fields in your CSV file to the Issue Id and Parent Id Jira fields, respectively during the CSV file import wizard.

The process for importing Issue Link through CSV is similar to importing of Sub-tasks:

1 - One column must be mapped as Issue ID and the other as the desired link type (e.g. "Link 'relates to'").

2 - The 'Link' column needs to have a value corresponding to the other issue 'Issue Id' value, or it needs to be an issue key of already existing issue within the JIRA instance to which the data is being imported. For example:

Summary,Issue Id,Link One,Link One,Link Two

House  ,      1,      2,      3,      2

Patio  ,      2,        ,        ,

Garden ,      3,  TEST-1,        ,

The file above would create three issues with correctly created issue links:

• Issue 'House' will have three links:
  • Two links of type "Link One" to issue 'Patio' and 'Garden'
  • One link of type "Link Two" to issue 'Patio'
• Issue 'Garden' will be linked to issue with key 'TEST-1'

You can refer to both documentations below to have more instructions:

- Importing data from CSV

- How to Import Issue Links from a CSV File

Let me know if you have any questions.

[Shaun Parker]

Many thanks for the answer and it makes perfect sense. 

I had already worked out the way to do this but your answer confirms it.

I do have one more question please?

When the Sub-Tasks are imported I have noticed that a new Jira Issue is created for the link rather than upholding the same relationship. 

2019-08-29 07:05:06,993 INFO - ------------------------------
2019-08-29 07:05:06,993 INFO - Importing: Issue Links & Subtasks
2019-08-29 07:05:06,993 INFO - ------------------------------
2019-08-29 07:05:06,993 INFO - Only new items will be imported
2019-08-29 07:05:07,031 INFO - Linking 'USM-4647' and 'USM-3084' as sub-task-link
2019-08-29 07:05:07,058 INFO - Created parent-child (sub-task) relationship between USM-4647 and USM-3084
2019-08-29 07:05:07,065 INFO - Linking 'USM-4648' and 'USM-3084' as sub-task-link
2019-08-29 07:05:07,098 INFO - Created parent-child (sub-task) relationship between USM-4648 and USM-3084
2019-08-29 07:05:07,103 INFO - Linking 'USM-4649' and 'USM-3084' as sub-task-link
2019-08-29 07:05:07,132 INFO - Created parent-child (sub-task) relationship between USM-4649 and USM-3084

The issues USM-4647, 4648, 4649 have been created as new rather than the CSV import pulling in the 'old' issue ... does this make sense?

Kind Regards

Shaun

[Shaun Parker]

I have attached a copy of the Jira and Sub-Taks and also a copy of my CSV import file.

Thanks

Shaun

My CSV Import File.

[Shaun Parker]

And this is the action I am doing on the import

[Shaun Parker]

I am not having much luck, this is another scenario I have tried.

[Shaun Parker]

Hi.

So just to clarify, I do not want to create any NEW sub-tasks, rather I want to migrate the data from Jira Server to Cloud.

This data has issues that have sub-tasks attached to them.

It is these sub-tasks that I want to migrate from Server to Cloud.

I can migrate the parent issues and I can also migrate the sub-task issues.

I just need to be able to do this in the image ...

Image attached.

Thanks

Shaun

[Shaun Parker]

I have played around with multiple file formats now and nothing works.

I am beginning to think I cannot do what I want to do.

P.S. Steps followed are:-

1. Import all the Jiras that I need to import first

2. Then try and import the Sub-Tasks that belong to some of those Jiras.

Thanks

Shaun