Bulk change of story points

Maria Angeloudi August 8, 2022

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! 

2 answers

0 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 8, 2022

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.

Screen Shot 2022-08-08 at 2.51.29 PM.png

 

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.

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
August 8, 2022

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:

paste-from-excel.gif

Hope this helps,

Hannes

Suggest an answer

Log in or Sign up to answer