[#JRA-8825] CSV Import should handle date time format

JIRA

CSV Import should handle date time format

Created: 15/Dec/05 10:31 PM Updated: 30/Jul/06 07:34 PM

Component/s:

Import / Export

Affects Version/s:

3.4.2

Fix Version/s:

3.4.3

Time Tracking:

Not Specified

Participants:	Brian Nguyen and Chris Mountford [Atlassian]
Since last comment:	2 years, 33 weeks, 3 days ago
Resolution Date:	29/Dec/05 07:50 PM
Labels:

Description

« Hide

Currently Jira assumes that all date fields are date picker fields. The problem is that generally the date-time format is different to the date format, but the csv import does not take this into account and so the following error is thrown.

[16:52:26] FAILED: Customfield value 13-Feb-04 is invalid
[16:52:26] com.atlassian.jira.issue.customfields.impl.FieldValidationException: Invalid date / time format. Expected dd-MMM-yy hh:mm a
at com.atlassian.jira.issue.customfields.converters.DateTimePickerConverter.getTimestamp(DateTimePickerConverter.java:50)
at com.atlassian.jira.issue.customfields.impl.DateTimeCFType.getSingularObjectFromString(DateTimeCFType.java:50)
at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.importIssues(DefaultJiraDataImporter.java:478)
at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:86)
at com.atlassian.jira.imports.importer.impl.ImporterThread.run(ImporterThread.java:21)

Jira needs to add the time information to the date field string.

All

Comments

Work Log

Change History

Sort Order:

[ Permlink | « Hide ]

Chris Mountford [Atlassian] added a comment - 19/Dec/05 01:04 AM

To reproduce this bug, first ensure there is an existing datetime custom field and then import from the csv file with a date formatted column mapped to that existing custom field.

[ Permlink | « Hide ]

Chris Mountford [Atlassian] added a comment - 29/Dec/05 07:50 PM

Fixed and added cut-down functional tests applicable from HEAD