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,301,425
Community Members
 
Community Events
165
Community Groups

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

擷取.PNG

擷取3.PNG

 * 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:

擷取.PNG

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 csv3.PNG

 

thanks a lot!

 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS

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