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; } } }

Mass change of existing JIRA issues if each change is individual

Marc Dahinden_6c5bon

Hello

I am aware that you can mass-create issues w/ a CSV file.
I am not aware that you can make a mass-change in one shot in existing issues like the case I should add an individual URL link per issue. This means for my case that each URL link is different per issue I need to add.

There is of course the way to process each issue one by one but this is a very time-consuming task doing this for 2000 issues.

I assume there is a way to execute a mass change via a CSV file. How would the structure of the CSV file look like?

Thanks for your support

Cheers, Marc

Accepted answers

All comments

Mark Segall

Hi @Marc Dahinden - You can definitely do this with a mass import. When mapping the csv, you'll need the issue key and summary. By mapping the issue key and summary, Jira will perform an update rather than creating new issues. Recommend you start with one or two issues as a test to make sure your mapping is good before processing the full batch.

Jack Brickey

Hi @Marc Dahinden , if you wish to update issues via csv then simply include a column in your csv with the issue key to be updated.

Marc Dahinden_6c5bon

Hi Mark

I tryed to update one story w/ story points how you recommended.

I have in csv file: key id, summary and story points.

Unfortunately it creates a new task and the story remains untouched.

Maybe I did something wrong when mapping ? Any proposal how to proceed?

Thanks, Marc

Jack Brickey

@Marc Dahinden , please share screenshot of 1 or two rows of your CSV

Marc Dahinden_6c5bon

@Jack Brickey

I attached a screenshot of the columns in the CSV file. My example contains currently one key ID for test purposes.

I want to add/change the value in the column "Story Points" for multiple stories at once.

Any change needed?

Thanks, Marc

CSV upload file screenshot.png

Hannes Obweger - JXL for Jira

Hi @Marc Dahinden

as others suggested, it is possible to bulk edit via the CSV import. If that's the approach you'd want to pursue, I trust that the existing conversations will help resolve your issues.

Just as an alternative option: If you're open to solutions from the Atlassian Marketplace, this would be very easy to do using 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. Among many other advanced features, you can also edit your issues in bulk, via copy/paste. This works within JXL, but also between JXL and pretty much any other app, including e.g. Excel. This is how this looks in action:

(I'm using story points here, but it would work the same way with any other field, including URL link custom fields.)

You can bulk update any number of issues in one go, so you should be done with your work in no time.

Any questions just let me know,

Best,

Hannes

Marc Dahinden_6c5bon

Hello Hannes
Unfortunately my company does not foresee JXL for JIRA. I am sorry.
Thanks, Marc

Marc Dahinden_6c5bon

Hi Mark

I tryed to update one story w/ story points how you recommended.

I have in csv file: key id, summary and story points.

Unfortunately it creates a new task and the story remains untouched.

Maybe I did something wrong when mapping ? Any proposal how to proceed?

Thanks, Marc

Marc Dahinden_6c5bon

@Jack Brickey

Any recommendation?

Mark Segall

Looking at what you've provided @Jack Brickey there's nothing wrong with the csv. Can you please confirm that when you perform the import, you're following the steps to map your column headers to the Jira fields and selecting Issue Key for your Key column mapping?

Marc Dahinden_6c5bon

Hello @Mark Segall

Yes I mapped column "key" to JIRA field issue key.

I used "Import Issues from CSV" in the menu "Issues" to execute the import/update.

Thanks, Marc

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-software-cloud