we have a created stories in Jira with a wrong story points

Question

We have a 1000 created stories in Jira with a wrong story points, now we have updated excel sheet with a new story points, so if I do bulk import it is going to create another 1000 stories we don't wanna do that rather just we want update only story points from excel to Jira issues. Please let us now what is the procedure for it.

srinath reddy pinappu · Answer

Tarun- Thanks for the information

srinath reddy pinappu · Answer

Alex- Thanks for the information.

Tarun Sapra · Answer

Hello @srinath reddy pinappu

One way to do it is via CSV as mentioned by Alexey, but it's tricky and risky to do it because of following statement in docs

"Importing a CSV to update existing issues will reset columns to their default values if they are not specified in the CSV."

So if you miss a column then the value will be reset. Hence my suggestion is to change your excel sheet to CSV having issueKeys and storyPoints only and use a scripting language like python or ruby to read each row and update the issueKey with corresponding new story points using the REST API.