Unable to bulk update field value using external system import and unable to parse datetime
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!