I am attempting to import tickets into a JSM Cloud project. When I attempt the import I am successfully importing all fields except the date time related ones.
I am importing from a .csv created by Excel.
I have tried a few different date or date/time formats in excel before saving the CSV file.
The issues all import except for the following fields:
These filed are empty after the import.
Regional settings on the computer are yyyy-mm-dd
Excel dates are formatted to dd-mmm-yy
In External System Import Date format I am changing the Date format
The log shows
2021-03-28 20:16:37,302 WARN - Unable to parse created date: 12-Dec-16
2021-03-28 20:16:37,306 WARN - Unable to parse datetime: 12-Dec-16
2021-03-28 20:16:37,311 WARN - Unable to parse date: 15-Dec-16
Hello Community! We’re excited to announce that Mindville Insight’s asset and configuration management capabilities will now be integrated into Jira Service Management Premium and Enterprise plan...
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