Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,365,126
Community Members
 
Community Events
168
Community Groups

Bulk change of story points

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

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.

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 up to 10000 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