Discover Jira Cloud products
Learn more about Jira Cloud products, features, plans, and migration.
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 2jira.date.picker.java.format=dd/MMM/yy jira.date.time.picker.java.format=MMM/dd/yy hh:mm ashould be corrected to:
1 2jira.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.
Was this helpful?
Still need help?
The Atlassian Community is here for you.