nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to update existing JIRA tickets from Excel

Martin Kiemes

I am looking for a way to manage the following change management round trip:

1. export a query result into Excel (available), say all bugs of a certain project release

2. record change management decisions in on of the fields problem by problem

3. import back the changes to JIRA

So *no* new records are created, the available import methods do not help here.

Issue is to update a specificed list of fields in the record. In a change management meeting with a crowd of people it is way too slow to update the tickets online. Capuring in Excel and later reflect that in JIRA is what I want to achieve. That Excel also serves as a record, which exact list was discussed in that change management meeting. Just operating on the records does not give ability to publish the outcome of the meeting.

Kind Regards, Martin

Accepted answers

All comments

Chris Rondeau

Having worked CM for many years, the trick is to yell louder and make them respect the process.

Failing that, you can update existing issues with a CSV import.

https://confluence.atlassian.com/display/JIRA/Importing+Data+from+CSV

However, you have to maintain a 1:1 ratio in the Excel/CSV file or you risk losing data when you import.

Martin Kiemes

ok, the link gives an important hint (while all text around talks about migrating into JIRA thus creating new records):

Issue Key

You can set the issue key for an imported issue. If an issue with a given key already exists in JIRA, it will be updated instead.

I assume the following will work:

1. run a query

2. export into Excel, say, just key + summary

3. maybe just correct some typos in the summary

4. save from Excel to csv

5. import from csv

As a result I would expect that all tickets in the list get updated if the summary was updated.

The statement 1:1 I would like to understand better: I understand that I better do not change the structure of the table, but just change the cell contents.

Thanks for the help.

Chris Rondeau

You need to keep the Excel/CSV and the Fields matching at a 1:1 to ratio, you should not remove columns from the csv or you run the risk of losing that information.

You would have to export all of the fields, make your changes, save as csv, then re-import. If there are any colums missing in the csv, you run the risk of resetting the data in all the other fields to blank/default.

If you exported just key + summary, you could lose assignee, description, priority etc.. when you re-import.

Martin Kiemes

Ok, understood.

What happens then to all data, which is not exported to Excel (Export, Excel, all fields) like all the Activity information, Tempo data, sub-tasks, attachments, structure, other plug-in related data?

I would in any case suggest to change that as follows:

new tickets: unspecified fields are set to default
modified tickets: unspecified fields remain as in the DB

Kind Regards

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

ms-excel