Unable to bulk update field value using external system import and unable to parse datetime

[Becky Li]

Hi I encounter the following issues when I try to bulk update the value in a custom datapicker field "Actual Start" using the External System Import function.

Steps:

1. Upload CSV

2. Import to Project Select  Defined in CSV

3. For Date format, I tried dd/MMM/yy h:mm a or yyyy/mm/dd HH:mm

4. Fields

 * As suggested by this ticket I leave the Summary field in my csv file as blank

Expected result: the Actual Start field can be updated in the existing issues.

Actual result:

2022-05-10 14:13:05,488 INFO - Import started by ug:2ab6e75e-1892-41c1-97df-a4075167b910 using com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean
2022-05-10 14:13:05,665 WARN - Unable to parse datetime: 2022/3/7 9:45 using the date format pattern: dd/MMM/yy h:mm a
2022-05-10 14:13:05,673 WARN - Unable to parse datetime: 2022/3/4 17:53 using the date format pattern: dd/MMM/yy h:mm a
2022-05-10 14:13:05,696 INFO - ------------------------------
2022-05-10 14:13:05,696 INFO - Importing: Users
2022-05-10 14:13:05,696 INFO - ------------------------------
2022-05-10 14:13:05,696 INFO - Only new items will be imported
2022-05-10 14:13:05,701 INFO - 0 users associated with import. All of them imported as inactive, this can be changed after import in User Access step.
2022-05-10 14:13:05,701 INFO - ------------------------------
2022-05-10 14:13:05,701 INFO - Finished Importing : Users
2022-05-10 14:13:05,701 INFO - ------------------------------
2022-05-10 14:13:05,701 INFO - 0 users successfully created.
2022-05-10 14:13:05,709 INFO - Retrieving projects...
2022-05-10 14:13:05,729 INFO - Project ExternalProject{id='null', key='TP0', externalName='null', name='Jira project 001', type='software', template='null'} exists and found correctly.
2022-05-10 14:13:05,735 INFO - ------------------------------
2022-05-10 14:13:05,735 INFO - Importing: Versions
2022-05-10 14:13:05,735 INFO - ------------------------------
2022-05-10 14:13:05,735 INFO - Only new items will be imported
2022-05-10 14:13:05,735 INFO - ------------------------------
2022-05-10 14:13:05,735 INFO - Finished Importing : Versions
2022-05-10 14:13:05,735 INFO - ------------------------------
2022-05-10 14:13:05,735 INFO - ------------------------------
2022-05-10 14:13:05,735 INFO - Importing: Components
2022-05-10 14:13:05,735 INFO - ------------------------------
2022-05-10 14:13:05,735 INFO - Only new items will be imported
2022-05-10 14:13:05,735 INFO - ------------------------------
2022-05-10 14:13:05,735 INFO - Finished Importing : Components
2022-05-10 14:13:05,735 INFO - ------------------------------
2022-05-10 14:13:05,744 INFO - Retrieving custom fields...
2022-05-10 14:13:05,752 INFO - ------------------------------
2022-05-10 14:13:05,752 INFO - Importing: Issues
2022-05-10 14:13:05,752 INFO - ------------------------------
2022-05-10 14:13:05,752 INFO - Only new items will be imported
2022-05-10 14:13:05,770 INFO - Importing issue: [externalId='autoid--4056871357475768619', summary='null']
2022-05-10 14:13:05,904 INFO - Importing issue: [externalId='autoid-246145012136923670', summary='null']
2022-05-10 14:13:05,986 INFO - 0 out of 2 issues successfully created
2022-05-10 14:13:05,990 INFO - ------------------------------
2022-05-10 14:13:05,990 INFO - Finished Importing : Issues
2022-05-10 14:13:05,990 INFO - ------------------------------
2022-05-10 14:13:05,998 INFO - ------------------------------
2022-05-10 14:13:05,998 INFO - Importing: Issue Links & Subtasks
2022-05-10 14:13:05,998 INFO - ------------------------------
2022-05-10 14:13:05,998 INFO - Only new items will be imported
2022-05-10 14:13:06,002 INFO - ------------------------------
2022-05-10 14:13:06,002 INFO - Finished Importing : Issue Links & Subtasks
2022-05-10 14:13:06,002 INFO - ------------------------------
2022-05-10 14:13:06,003 INFO - ------------------------------
2022-05-10 14:13:06,003 INFO - Importing: Issue remote links
2022-05-10 14:13:06,003 INFO - ------------------------------
2022-05-10 14:13:06,003 INFO - Only new items will be imported
2022-05-10 14:13:06,008 INFO - ------------------------------
2022-05-10 14:13:06,008 INFO - Finished Importing : Issue remote links
2022-05-10 14:13:06,008 INFO - ------------------------------

Question:

1. I select map issue key to update existing issues but it reveals 0 issues imported successfully. Is it because the datetime parse issue?

2. How should i revise the date format? below is the field value examples in the csv

thanks a lot!

[Drew Kerrigan]

I've seen the import work with any datetime format using the SimpleDateFormat: https://docs.oracle.com/javase/1.5.0/docs/api/java/text/SimpleDateFormat.html

However it always says:

"...completed with warnings..."

"Unable to parse datetime..."

The only datetime format that I have seen it accept and not throw any errors with, is this:

M/d/yyyy H:mm:ss