Import issue links from a CSV File in Jira server

Still need help?

The Atlassian Community is here for you.

Ask the community

Purpose

Instructions for importing two or more JIRA issues with an issue link (such as 'Relates To') between them as a CSV file.

Importing JIRA issues with issue links was not possible until the release of the JIRA Importers Plugin v6.2.20, which is compatible with JIRA v6.2-v6.3.15 - any newer release of the add-on will also include this functionality, as well. JIRA v6.4+ comes bundled with a version of the JIRA Importers Plugin that includes this functionality.

This functionality is available for both the CSV admin and non-admin importer.

The linked issue will represent the Outward link as described in Configuring issue linking

Solution

The process for importing Issue Link through CSV is similar to importing of Sub-tasks, as described in Importing Data from CSV: one column must be mapped as Issue ID and the other as the desired link type (e.g. "Link 'relates to'" which is the Outward link Description as described in Configuring issue linking). 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'


Once the CSV file is prepared in this way, follow the steps from Running the CSV File Import Wizard to import the data.


It can be imported by menu Issues> Import issues from CSV.

As mentioned previously, specify an issue id for each row in the csv file.

Issue id is used to determine the link for CSV import and is not related to existing issues.


Sample 2 : Importing links to existing issues

The previous way does not work for this situation, it should to be imported from System> External System Import.

Here is an example. The existing issue “TEST-2” is linked to the existing issue of “TEST-1”, while the issue “TEST-3” is also possible to link to “TEST-2”.

issue key,   summary,   link one
TEST-1   , summary 1,     TEST-2
TEST-2   , summary 2,     TEST-3


In addition, if you specify as follows, the result will be the same as above.

Issue key,Issue id,   Summary, Link one
TEST-1   ,       1, summary 1,        2
TEST-2   ,       2, summary 2,        3
TEST-3   ,       3, summary 3,       



Description

This page includes Instructions for importing two or more JIRA issues with an issue link (such as 'Relates To') between them as a CSV file.

ProductJira
Last modified on Jan 14, 2020

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.