csv importer: Unable to parse date

[hjune.lee@samsung.com]

I have been doing this for many times today.

I am not sure what went wrong with date format.

Does anyone have any idea?

image2016-9-7 15:7:28.png

csv file

Project,Summary,Key,Created,Priority,Component/s,Due Date,Issue Type,Status,Project Type,Project name
CZS11311001,LS32D85KTSR/EN - SK,SECZPRP-825,30/Aug/16 1:31 PM,Medium,Monitor,5/Sep/16 1:31 PM,Product,Translation Complete,software,Czech and Slovakia Product Registrations
CZS11311001,LS24E65UDW/EN - SK,SECZPRP-824,30/Aug/16 1:31 PM,Medium,Monitor,5/Sep/16 1:31 PM,Product,Translation Complete,software,Czech and Slovakia Product Registrations

csv importer configuration 

{
"config.version" : "2.0",
"config.project.from.csv" : "true",
"config.encoding" : "UTF-8",
"config.email.suffix" : "@",
"config.field.mappings" : {
"Status" : {
"jira.field" : "status"
},
"Project" : {
"jira.field" : "project.key"
},
"Issue Type" : {
"jira.field" : "issuetype"
},
"Project name" : {
"jira.field" : "project.name"
},
"Component/s" : {
"jira.field" : "components"
},
"Priority" : {
"jira.field" : "priority"
},
"Project Type" : {
"jira.field" : "project.type"
},
"Summary" : {
"jira.field" : "summary"
},
"Created" : {
"jira.field" : "created"
},
"Due Date" : {
"jira.field" : "duedate"
}
},
"config.value.mappings" : {
"Status" : {
"Translation Complete" : "3"
},
"Issue Type" : {
"Product" : "10301"
},
"Priority" : {
"Medium" : "3"
},
"Project Type" : {
"software" : "software"
},
"Summary" : {
"LS32D85KTSR/EN - SK" : "LS32D85KTSR/EN - SK",
"LS24E65UDW/EN - SK" : "LS24E65UDW/EN - SK"
},
},
"config.delimiter" : ",",
"config.project" : {
"project.type" : null,
"project.key" : "",
"project.description" : null,
"project.url" : null,
"project.name" : "",
"project.lead" : null
},
"config.date.format" : "dd/MMM/yyyy"
}

image2016-9-7 15:7:28.png

[Petar Petrov (Appfire)]

I think there are two problems - the year is in two-digit format in the CSV and it also contains time, not just date - so the proper date format should be:

dd/MMM/yy hh:mm a