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

Allow 'Import Issues from CSV' function to populate ARJ Target Start and End date custom fields

    XMLWordPrintable

Details

    • 1
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      At present, it is possible to use Jira 'External System Import' function to import a .csv with Jira Issues and map fields to Advanced Roadmaps fields of 'Target start' and 'Target end' custom fields. This is inclusive of choosing a custom date format during import to match the format of field dates in the .csv file. Jira Admin is required for this approach.

      Attempting to import the same .csv via Jira 'Import Issues from CSV' function (non-Jira admin users can access this function) does not allow facilitate successful import when attempting to map to 'Target start' and 'Target end' custom fields and specifying a custom date format.

      An example error during import is:

      Cannot add value [ [16/12/2020] ] to CustomField Target start in Issue with summary 'x'. Exception Message: Invalid date format. Please enter the date in the format "d/MMM/yy".

      Ideally import would be successful via both .csv import tools.

      WORKAROUND:

      Using the External System Import, It is possible to import the fields “Target start” and “Target end” fields only if in the CSV file we make sure that these dates are in the format “dd/MMM/yyyy” (i.e.: 16/Aug/2023) - independently from the date format which is configured in the import config file for other date fields. Regardless of how other date fields are formatted and what format you specify during import, these two fields must be in “dd/MMM/yyyy” format.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              itrojahn@atlassian.com Ilenice
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: