I want to update below information for about 200 issues in our JIRA system. Can someone help with the best possible way to do it in bulk
Out of Scope
and many other custom information fields that we have.
I have the information in Excel file. Is there a way to just upload it to JIRA and update the corresponding issues with these values.
I think it will be easy and faster to use 'bulk-change' feature(look through this article).
You can get from excel-file issue keys and put it in JQL-search(advaced search).
you JQL will be look like 'key in (KEY-1, KEY-3, KEY-5')" - then edit issues by bulk change, where you set new values to your custom fields(in scope, out of scope, milestones, stakeholders).
Feel free to contact if you`ll get a questions.
Looks like you've figured it out, but I was suggesting going to Administration -> System -> External System Import (on the left sidebar). Choose CSV, and map the appropriate fields. To do this, have the name of each field in the top row of your CSV, and the corresponding value in the rows beneath. You'll need to make sure that the issue key is matched properly, and that any other fields required (such as summary, etc) are filled.
Your CSV (visualized in Excel) would look something like this:
Issue Type Summary Key Field A Field B
Story example ABC-123 sample sample
Issue Type, Summary, Key, Field A, Field B
When you go through the import process, you map each field to a field in Jira. By mapping the Issue Key to whatever you call it in CSV, it will match the key to an existing issue and update the fields that you've included in the import with their corresponding values.
To see this feature in action check out our recent dependencies demo here: https://www.youtube.com/watch?v=eQu5VsUqyZA Keeping on top of your dependencies is a key part of ensuring project success....
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events