Bulk Import Resolution date- Tied to done for reports

[Janelle Williams]

I'm attempting to upload a log of our company issues that we have been tracking since January.  Most of our January - March issues have been resolved.  I have been able to set the created date to actually match when it was sent to us but can't figure out how to set a resolution date.  I've seen other describe adding resolution dates and tying them to an existing field in Jira.  My issue is that it doesn't correspond to when the item is marked done.  Therefore when we run reports it appears as thou nothing was resolved in the previous dates (January & February).  When I run a report it appears as though every item was resolved on the day I did the upload which isn't correct. 

Can someone point me the direction of either how to create a work around such that our reporting matches our back log?

[Ste Wright · Accepted solution]

Hi @Janelle Williams 

I tried this and it worked - a few things to make sure...

• The date format is correct in the CSV and the import setup
• You're setting the Resolution and the Date Resolved in the same file. You need both to ensure Resolution is imported

---

My CSV file looked like this...

Summary	Created	Resolved	Status	Resolution
Task 1	2022-01-01 22:00	2023-04-02 14:00	Done	Done

^

Then ensure the import setup contains...

• Setup...
  • Date Format = yyyy-MM-dd hh:mm
• Fields...
  • Summary > Summary
  • Created > Date Created
  • Resolved > Date Resolved
  • Status > Status
  • Resolution > Resolution

---

Let us know if this works!

Ste

[Janelle Williams]

@Ste Wright Thank you so much this worked.  The reporting is displaying correctly now.