Uploaded image for project: 'Jira Cloud'
  1. Jira Cloud
  2. JRACLOUD-65955

CSV Import with date field fails to import when dates are within the last 2 days

    XMLWordPrintable

Details

    Description

      This issue relates to JRA-42259 / JIM-1461

      Clarification

      This bug affects CSV Issue Importer

      • Click on the issue drop down from the top panel and select Import Issues from CSV
        <BASE URL>/secure/BulkCreateSetupPage!default.jspa?externalSystem=com.atlassian.jira.plugins.jira-importers-plugin:bulkCreateCsv
        

      It DOES NOT affects External System Import's CSV Importer:

      • g + g > External System Import > CSV Import
        https://clone-ribesalat.atlassian.net/secure/admin/CsvSetupPage!default.jspa?externalSystem=com.atlassian.jira.plugins.jira-importers-plugin:csvImporter
        

      Problem Description

      When Importing from CSV file, it fails to create issue for the issues that requires custom field to store the value of the date of today and tomorrow.

      Steps to replicate

      1. Create a CSV File with the following content:
        Summary,Start Date,Due Date,Issue Type
        TEST5,20150505,20150505,Task
        TEST6,20150506,20150506,Task
        TEST7,20150507,20150507,Task
        TEST8,20150508,20150508,Task
        TEST9,20150509,20150509,Task
        TEST10,20150510,20150510,Task
        TEST11,20150511,20150511,Task
        TEST12,20150512,20150512,Task
        
      2. Create a Date Picker custom field
      3. Navigate to the CSV Importer page (Click on the issue drop down from the top panel and select Import Issues from CSV)
      4. Select the CSV file created on Step 1 with the date format yyyyMMdd
      5. Map all the respective field, (Start Date to the date field on step 2)
      6. Run a validation is enough to show the error:
        The validation process has found 1 error/s
        
        Issue can't be created due to the error/s [ You did not enter a valid date. Please enter the date in the format "d/MMM/yy", eg. "6/May/15" ]
        

        On the logs

        2015-05-06 15:28:26,116 INFO - Importer started!
        2015-05-06 15:28:26,116 INFO - Engine is running in Validation-only mode
        2015-05-06 15:28:26,123 INFO - All issues will be imported to project: OP - Germany (OPG)
        2015-05-06 15:28:26,123 INFO - Creating issue: ExternalIssue{externalId=autoid-1543422131194881929, summary=TEST5, issueType=Task}
        2015-05-06 15:28:26,138 ERROR - Issue can't be created due to the error/s [ You did not enter a valid date. Please enter the date in the format "d/MMM/yy", eg. "6/May/15" ]
        2015-05-06 15:28:26,138 INFO - Creating issue: ExternalIssue{externalId=autoid-8688065971629025157, summary=TEST6, issueType=Task}
        2015-05-06 15:28:26,150 ERROR - Issue can't be created due to the error/s [ You did not enter a valid date. Please enter the date in the format "d/MMM/yy", eg. "6/May/15" ]
        2015-05-06 15:28:26,151 INFO - Creating issue: ExternalIssue{externalId=autoid-4634509001815587972, summary=TEST7, issueType=Task}
        2015-05-06 15:28:26,162 INFO - No problems found with issue 'TEST7'
        ...
        

      Workaround

      Use the External System Import for the moment (Requires Administrative permission).

      g + g > External System Import > CSV Import

      Attachments

        Issue Links

          Activity

            People

              ohookins@atlassian.com Oliver Hookins (Inactive)
              rgee Richie Gee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: