Bulk Import Resolution date- Tied to done for reports

Janelle Williams
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 31, 2024

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?

1 answer

1 accepted

1 vote
Answer accepted
Stephen Wright _Elabor8_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 31, 2024

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
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 1, 2024

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events