Not able to do bulk edit more than 1000 issues

[putraj.ramaiah]

Hi ,

We are trying to do bulk edit more than 1000 testcases but only we are able to see /edit first 1000 issues .Is there any way to edit next 1000 issues ??

[Jack Brickey]

Two OOTB options:

1- You can do it in batches:

• run your JQL
• edit your issues (1000) and add a unique label as part of the edit (“BE-complete”)
• re-run the JQL but add …”AND labels != “BE-complete”
• repeat the edit operation including the label
• repeat to end

2- you can use CSV import

• there are a number of posts out there about how to update issues using CSV import but basically you do an export of the issues which will include the issue ID. Then you simply include that column in your import and also include the fields you want to update.

[Kyle Twogood]

Since this thread still shows up in search, here is the current state of things for Jira Cloud:

The native bulk change tool is still capped at 1000 issues per operation, and on Cloud there is no admin setting to raise it (that only exists on Data Center).

If you want to stay fully native, the batching approach Jack described above still works. Two refinements that make it less painful:

1. Instead of adding a tracking label, sort by key and slice the work with JQL, for example project = ABC ORDER BY key ASC. Edit the first 1000, then rerun the query. If the edit itself changes a field you can filter on, the query shrinks on its own as you go, e.g. project = ABC AND fixVersion IS EMPTY.
2. The CSV export and re-import route also works for field updates, but always include the Issue ID column and dry-run it on two or three issues first, because there is no undo on an import.

Full disclosure, I'm the developer of Bulk Ops for Jira, which I built for exactly this problem. You select issues with a JQL query and it processes the whole set in batches for you, so the 1000 issue ceiling doesn't apply, with a preview before anything is changed. There's a free trial if you'd like to see whether it fits your use case: https://marketplace.atlassian.com/apps/3844951205/bulk-ops-for-jira

[Marlene Kegel - codefortynine]

Welcome to the community, @putraj.ramaiah.

Another option would be our Jira cloud app Advanced Bulk Edit for Jira.

With our app it is possible to edit thousands of issues at once. Our app could be helpful if you do large bulk changes on a regular basis.

If you have questions or feedback about Advanced Bulk Edit for Jira, don't hesitate to contact us. 

[Joshua Dickerson]

@Marlene Kegel - codefortynine - Do you get the full version of Advanced Bulk Edit for Jira in the trial version or a paired down version?

[Hannes Obweger - JXL for Jira]

Hi @putraj.ramaiah

you may want to check out JXL in the Atlassian Marketplace. It's a spreadsheet experience for Jira in which...

a.) you may be able to do your bulk editing directly (for up to 10k issues), by simply copy/pasting a value. Below, I'm bulk-editing the assignee via copy/paste, and this works similarly for most other fields, too.

b.) alternatively, you can open the bulk editing experience by selecting and right-clicking issues. Jira's native bulk editing experience is, unfortunately, still limited (to maximum 1000 issues), but you can easily trigger it "batch by batch".

For more details, you can also check out https://jxl.app. (Disclaimer: I work on JXL.)

Hope this helps,

Hannes

[Jack Brickey]

@Hannes Obweger - JXL for Jira , if you happen to represent the company it is important to declare in your post. Unsure if that is the case as your name doesn’t include the company nomenclature.

[Hannes Obweger - JXL for Jira]

Hi @Jack Brickey 

apologies - I updated my post and my name accordingly.

Best,

- H

[Jack Brickey]

thanks! nice app implementation BTW.