Matching Exported Issue Data to Update JIRA Projects with JIRA Importers Plugin

Still need help?

The Atlassian Community is here for you.

Ask the community


It is sometimes necessary to run exports out of multiple bug trackers in order to bulk-update JIRA issues with the JIRA Importers Plugin (JIM). Some examples would be:

  • The JIRA Importers Plugin functionality Import from Bugzilla is not compatible with all fields generated by Bugzilla
  • Rolling back a JIRA update while retaining changes made post-update

In such cases, existing JIRA issues need to be updated with new data (new fields, updated existing fields, etc.). This article describes processes by which you can make these types of changes.

General Information

The JIRA Importers Plugin is used for two purposes - importing new data into JIRA as new issues and updating existing JIRA issues with modified data.

In order to update existing JIRA issues, it is important to note that the file to be imported must contain, at the least, columns containing the following data to match existing issues:

  • Issue Key
  • Summary

Furthermore, the import file needs to be arranged such that issue key is the first column in the file.

(info) This data is required, because it is how the Importers Plugin maps CSV data to JIRA issues.

Example Procedure

These steps are written using the example of updating issues in an instance of JIRA previously populated with Bugzilla data.

Generating Exports

  1. Generate CSV export(s) from Bugzilla containing:
    1. bug_id
    2. short_short_desc
    3. Any field(s) you want to update into JIRA
  2. Generate Excel export(s) from JIRA containing:
    1. Issue Key
    2. Custom field associated with bug_id from Bugzilla
    3. Summary

 By default, JIRA is set to limit Excel exports to 1000 Issues due to high memory usage. This setting can be changed but is ultimately limited by the amount of memory allocated to your Java Virtual Machine.

Appending CSV File

Process Overview

  1. Open CSV and XLS files
  2. Sort all data within both files by a common column
  3. Copy/paste desired columns to create a complete file
  4. Save as CSV
  5. Import to JIRA
Click for detailed example steps...

Prepare CSV File

  1. Open CSV file
  2. Select all rows/columns (Ctrl+A/Cmd+A may be useful here)
  3. Sort by column 'bug_id' descending
  4. Insert new column A

Prepare XLS File

  1. Open XLS file
  2. Delete header/footer rows so file contains only column names and column data
  3. Select all rows/columns (Ctrl+A/Cmd+A)
  4. Sort by column with bug_id data (example: 'External Issue ID') descending
  5. Select Issue Key column
  6. Copy (Ctrl+C/Cmd+C)

Final Steps

  1. Select cell A1
  2. Paste (Ctrl+C/Cmd+C)
  3. Rename cell A1 to "Issue Key"
  4. Save CSV file
  5. Close XLS and CSV files

When finished, the CSV file should look similar to this:

Using the CSV pictured above, it would be possible to update Issues IK-1 through IK-5 with the bug_id and/or qa_contact fields.


Last modified on Feb 26, 2016

Was this helpful?

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