CSV File Import

Shaun Parker_vme5pj

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.