How to update Resolution & Resolution dates in Jira

Hello,
You may need to follow that procedure when you need to update resolution dates when for some reason, the tickets were not correctly “closed”, from JIRA’s POV at the right date. I had that issue due to an error in our workflow, causing the ticket to have the “Done” status but resolution date not updated.

To update these dates, first:

Prepare a CSV with all issues you want to update, wether they’re already in a resolved “Done” or not. The CSV should contains the following fields:

  • Issue key
  • Summary
  • Resolution
  • Resolved

Then, with the following field, go to :

https://<instance>.atlassian.net/secure/admin/ExternalImport1.jspa 

You need to have certain privileges to access this page & make updates on issues. Choose “CSV”. That brings you to the following page:

Update your CSV & click Next. You can use the advanced mode to change some import parameters.

In the following step, you can choose wether to update/import issue to a defined project or to have the project defined in the CSV. In my case I have only one project to update.

Then the important part is the date, because you want to update the date 🙂 so be careful to clearly set the Date format mask corresponding exactly to your date format and don’t trust Jira date format by default, it may be wrong (he didn’t parse your file to recognise it ;))

In my case, my date was “29/09/2019 11:44” so I had to update the Jira mask to

 d/M/y h:m

instead of the

"dd/MMM/yy h:mm a" 

proposed by default.

Click on Next. Time has come to map fields

Then click on Next and it’ll bring you to the “Begin import” button.

Click on “Begin import” and wait a bit. Here is the result I got for one story update

Hope it helped cause it wasn’t that easy to find, especially the right place to import the CSV & the date trick due to wrong default value (in my case).

Source:

https://community.atlassian.com/t5/Jira-questions/Is-there-a-way-to-change-the-quot-Resolution-Date-quot-in-Jira/qaq-p/385739

https://docs.oracle.com/javase/1.5.0/docs/api/java/text/SimpleDateFormat.html

https://jira.atlassian.com/browse/JRACLOUD-65502?_ga=2.63511975.921427610.1569990746-1275248540.1512504703

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.