CSV Import Issue - Problem with date

[vincent beudez]

Hi,

I'm trying to create issues by importing a csv file. It works, i can create project and issues, fields are correctly filled in.
But i have a problem with the creation date.

In the Look and Field page, i set the day/month/year like this

In my excel file, i set the Creation date: 31/12/2011
I also set "this file = creation date" during importation

But i have a error message:

<form id="jimform" class="aui long-label" style="margin-top: 0px; margin-right: 0px; margin-left: 0px; color: #333333; font-family: arial, tahoma, verdana, sans-serif; line-height: 1.4; position: relative; display: inline !important; padding: 0px;" action="http://support.externis.net:8080/secure/admin/views/ImporterFinishedPage.jspa?externalSystem=CSV" method="post" name="jiraform">

Unable to parse created date: [31/12/2011]

</form>

What did i do wrong? :)

thanks

Vincent

[Nic Brough -Adaptavist- · Accepted solution]

When you import from CSV, it prompts you for a mask for importing any dates - did you set that to dd/MM/yyyy too? (I can't remember what the default is, but I always set it explicitly, just in case)

[vincent beudez]

I set the format date in excel like this:

To see if it's correct, i also opened the csv file with notepad to see if the date format is correct, and it is.

[Nic Brough -Adaptavist-]

I wasn't asking about your date formats in the file, you already said you'd checked them in the plain CSV.

What did you enter in the date mask in the importer? (This is assuming you're on an older version of Jira, where this matters - in later versions, that's dropped in favour of always using the system date)

If it's not that, then could you try it with a time clause as well? e.g. "31/12/2011 00:00:00"

[vincent beudez]

Here is what i just entered, and still the same problem:

[Wojciech Seliga]

it looks like checked the box in the "Map Value" column for "date creation" CSV column. I think you don't want it. You want CSV to automatically parse your strings as dates. Mapping values for dates would mean that you are manaully specifiing corresponding text value for every single possible string value from your CSV.

I think you miss the setting in the second CSV importer page:

[Dante Labate]

Were you able to solve this problem?

[Deleted user]

Need to edit date info in text program not in EXCEL

[Nic Brough -Adaptavist-]

CSV is text, so just open the CSV and edit it.  You'll find it easier in a spreadsheet though.