Mass Updating Issues For Same Field With Different Values

[Scott Simpson]

We are utilizing JIRA Service Management.

Each ticket has an Account ID field. 

Each ticket requires its own unique account id to be entered. 

We have a report that provides us the account ID that should be associated with each ticket.  We want to mass update all tickets to have the correct account ID based on issue ID or another unique identifier 

How can we accomplish this? 

[Hannes Obweger - JXL for Jira]

Hi @Scott Simpson

if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also supports inline bulk editing via copy/paste. This works within JXL, but also between JXL and pretty much any other app, including Excel or Google Sheets.

This is how it looks in action:

I'm updating story points here, but it works for any other issue field(s), too. 

As you can see, you have full flexibility over which values you are pasting into what issues. This works for any number of issues, and any number of values - so depending on your exact use case, you should be done with your work in no time.

I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

[John Funk]

Hi Scott,

First, what’s the point of the Account ID when the issue key is already a unique identifier for the issue.

Regardless, second, what would you be using for the Account ID field value?

[Joseph Chung Yin]

@Scott Simpson -

As referenced in the following link - https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/, please remember the following

1) You must be the Jira Admins. If you are, then click on the Clog Wheel symbol (upper right of the window) "Settings", then select "System" >> "External System Import"

https://<yoursite>.atlassian.net/jira/settings/system/external-import

2) In your CSV file, you need to 3 columns:  IssueKey, Summary, Your custom fields.  You can obtain an CSV export from your JSM site where you can obtain all the IssueKey and their associated issue summary.  Afterward, you can modify the export file to include your custom field with the appropriate "accountID" value.

Hope this helps.

Best, Joseph Chung Yin

[Valerie Knapp]

Hi @Scott Simpson , thanks for your question.

I think the simplest thing to do would be an External System Import. Please find the documentation for this here - https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/ 

Best wishes