• Products
  • Documentation
  • Resources

Common CSV file questions and known issues

This page answers some of the commonly asked CSV questions our technical support staff have encountered. If you are not able to find an answer from this page and our issue tracker, please contact support.

Commonly asked questions

The importer fails at date fields, why?

If you are seeing error message similar to this:

1 2 3 4 5 6 7 [00:55:28] FAILED: Customfield value 01/Nov/06 12:00 AM is invalid [00:55:28] com.atlassian.jira.issue.customfields.impl.FieldValidationException: Invalid date format. Please enter the date in the format "MMM/dd/yy". at com.atlassian.jira.issue.customfields.converters.DatePickerConverter.getTimestamp(DatePickerConverter.java:57) at com.atlassian.jira.issue.customfields.impl.DateCFType.getSingularObjectFromString(DateCFType.java:46) at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.importIssues(DefaultJiraDataImporter.java:531) at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:104) at com.atlassian.jira.imports.importer.impl.ImporterThread.run(ImporterThread.java:21)

There are a few possible reasons:

  • The format of dates is not correctly set in the import configuration file. The date format for custom fields must match the "Date format in input file" which has a default format of yyyyMMddHHmmss

  • Jira system date fields such as Created, Updated and Due Date use "yyyy-MM-dd HH:mm:ss" but may need an offset adding

  • Date Picker and Date Time Picker formats are not consistent, e.g.

    1 2 jira.date.picker.java.format=dd/MMM/yy jira.date.time.picker.java.format=MMM/dd/yy hh:mm a

    should be corrected to:

    1 2 jira.date.picker.java.format=dd/MMM/yy jira.date.time.picker.java.format=dd/MMM/yy hh:mm a

Why does the importer always ask me to map values to column (at Step 3 of 5)?

It is because you have selected Map Field Value for the particular columns. To use the values from the CSV, you need just to map the column to the Corresponding Jira field, otherwise, select the Map field value checkbox.

Still need help?

The Atlassian Community is here for you.