Bulk change of story points

Question

Hey,

our team wants to transfer 100+ backlog features to another team (containing 1000+ issues). Problem is that they are calculating story points in a different way. Is it possible to do a bulk change of story points as well? Keep in mind that not all issues have the same story point estimation, but the correlation will be 1-1.

Thanks!

Trudy P Claspill · Answer

Hello @Maria Angeloudi

Welcome to the community.

For the 100+ issues you want to move, would all issues with a given Story Points value be changed to the same value? For instances, would all issues with a Story Point value of "1" be changed to "2", and all with a value of "5" be changed to "9"?

If so, then you could do it with an Automation rule, I believe, using if/else-if/else blocks. If you create a Schedule rule you can define a JQL that selects the issues. If you already have the JQL for all the issues you want to move, you would use that JQL.

It could also be done through the Bulk Change option, but that would be more challenging as changes would have to be done in the correct order to ensure a previous change was not overwritten.

Hannes Obweger - JXL for Jira · Answer

Hi @Maria Angeloudi

welcome to the community!

So if I understand correctly, you want to change the story points of 1000+ issues, essentially by applying some kind of "formula" on the current value (e.g., multiply any story points by 2, or divide them by 3, or whatever mapping you want to apply)?

If that's the case, with "native" Jira, you may be successful with an export to Excel/re-import to Jira round-trip, or potentially with Jira Automation.

If you're open to solutions from the Atlassian Marketplace, this would also be very easy to solve with the app that my team is working on, JXL for Jira. JXL is a full-fledged spreadsheet/table view that allows viewing and inline-editing all your issue fields, including story-points. You can also bulk-edit your fields using copy/paste, either directly in JXL, or between JXL and Excel or Google Sheets.

So what you could do is copy/paste your values to Excel, apply your calculations, and copy/paste them back to Jira. You can do this with any number of issues in one action.

This is how this looks like for the "summary" field, but you can do the exact same for any other field as well:

Hope this helps,

Hannes