Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Mai Trinh
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 12, 2018

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?

1 answer

0 votes
joshloe
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 12, 2018

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

Mai Trinh
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 12, 2018

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
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 12, 2018

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. 

Suggest an answer

Log in or Sign up to answer