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,298,550
Community Members
 
Community Events
165
Community Groups

How do I bulk update the create date for already imported issue records?

I have imported my old Help Desk records in full. All seemed fine until I checked the Created dates on individual issues in the project, which have all been set to dates in January 2021 somehow.

I don't want to delete the whole lot and start importing again, so is there any way that I can easily update the created date in bulk for all the imported issue records, without causing any major damage?

Please note, I'm a newcomer to this, so be gentle! :)

Thanks in advance

 

1 answer

1 accepted

0 votes
Answer accepted

Quick update - I've found an answer!

Hey Mark, can you please help me with the solution. What worked for you?

Thanks. 

Hi @Abhishek Saxena 

I used a .CSV import via External System Import. You do need Admin access to do this.

I exported a list of the records I wanted to update, including the Issue Key and Summary. I then constructed a .CSV import file that included:

  • Issue Key
  • Summary
  • A column containing the data I wanted to update.

During the import process, map the Issue Key field from the .CSV file to the Jira Issue Key field. You'll see a message at the top of the screen advising you that this mapping option has been taken. Also map the Summary field to the Jira Summary field. 

Finally, map the data field(s) that you are importing to the Jira relevant field(s).

Once mapped, continue with the import in the usual way.

I did a test on a test project just to be sure that it worked.

Hope that helps!

Like Abhishek Saxena likes this

Thanks @Mark K. I am doing the same steps, but after import all date fields are resetting to import time. So wondering if you can confirm if there is an option in the migration setup to carry forward the historical system dates e.g. Created/ Resolved date.

All other fields are imported successfully.

Thanks.

 

   

Hi @Abhishek Saxena 

I found that mapping a date to the Jira 'Date Created' worked fine. Just be careful of the date formatting in the .CSV. That's what tripped me up on the initial conversion and lead me to having to update the entries.

I used Excel to format it, saved as file type CSV UTF-8.

Using Excel, I found I had to convert the overall Date column format to Short Date, then select the actual Date cells to import and apply custom formatting using dd/MMM/yy hh:mm

I didn't use a resolved date, as I'm not sure how we'll be using teh resolution options yet. I used 'Date Modified' to record it. 

Mark

Hey Mark, This works to some extent, it is now recognizing the created date field but not parsing it correctly. Some how month is setting to January always but day, year and time is good. Wondering what's happening :( 

Attaching the system date format screen. Is it same what you had on JIRA side and in excel?

Thanks.

Changed Settings.JPG

That's the issue I had. I didn't look at our main set up, I just dealt with the import.

I had to make sure that the formatting used in the .CSV file was also specified during the import process. For example, I used dd/MMM/yy hh:mm, so:

Untitled.png

Like Abhishek Saxena likes this

This works Mark. Thanks for direction. 

I noticed, it supports other formats as well. Only this we need to keep in mind that format for all three places "Excel - Import File" , "JIRA Settings" and in "Import Wizard while import" should be same. 

Sorry for replaying late.

Thanks!

Like Mark K likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Management

Coming Soon: Insight Changing to Assets

The 2020 acquisition of Mindville added powerful asset and configuration management capabilities to Jira Service Management in the form of Insight. Following the completion of that integration, custo...

294 views 2 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you