Is it possible to bulk edit a specific set of tickets through Import CSV?

Question

We are migrating JIRA workflows and I want to bulk edit the Description field on a specific set of tickets

The edit in the description is specific to each ticket and have the text in a csv.

I exported the set of tickets from JIRA did some data manipulation in excel and re-saved as CSV file.

The CSV file contains the set of tickets I want to edit and all the data needed. How would I proceed to bulk edit this?

joshloe · Answer

Mai,

The Issue Key option was removed from the CSV Importer on the main page, since its sole purpose is to create new issues for your instance.

If you are in JIRA Cloud, The External System Import, which can be found in the JIRA System Configuration page, is another CSV importer that allows you to set the Issue Key field.

To get to this tool navigate as a site-admin to "Settings -> System -> External System Import" and use your CSV.

Mai Trinh · Answer

Hi Josh,

When I attempted this with a small subset of 2 tickets. I created 2 new tickets and did not overwrite the existing tickets.

I am unable to map the Issue Key field on my import mapping

joshloe · Answer

Mai,

If you've already made the changes to the CSV for the description field as you stated, you can simply import the issue back into JIRA by Importing data from CSV.   When you import data, all you will need to do is map the fields that have changed and the corresponding issue key.

If you do not map the issue key JIRA will create a new issue instead of mapping it to the existing.

If you have not made the changes, you can simply open the CSV in Excel and replace the description row per ticket that you wish to change.   Then follow the steps from above.

Another option if the description is the same, is to bulk edit the issues in JIRA by Editing Multiple issues at the same time.

-Josh Loe