Importing a csv file

[Ankith]

Hello am trying to import a csv file into my project from rally all the fields are mapping to the custom fields but there is a problem with ACTUAL START and reflects this error every time.

• Unable to parse datetime: 2018-06-11T13:15:25.760Z using the date format pattern: dd/mm/yy h:mm
• Unable to parse datetime: 2018-05-02T19:40:43.899Z using the date format pattern: dd/mm/yy h:mm

• Issue can't be created due to the error/s [ Actual Start is required. ]

[Andy Heinzer]

It looks like your CSV file has a date in a format that is different than Jira is expecting.   During the CSV import, after you select the CSV file, there is an option for date format.  By default it is using

dd/MMM/yy h:mm a

However on that page we link to some java documentation on other possible date formats and the syntax needed for them.

Please specify the format that dates are stored in the CSV file. Please use syntax valid for SimpleDateFormat.

In which case, if all your dates are in this format for that file you could use a syntax of

yyyy-MM-dd'T'HH:mm:ss.SSSZ

when importing that file to get past this issue.    However if you have other date fields that are in a different format for the same file, I suspect that you might have to standardize the date/time formats for this csv file to single format so that you can import this in a single go.