nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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:

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

</form>

What did i do wrong?

thanks

Vincent

Accepted answers

Nic Brough -Adaptavist-

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)

All comments

Nic Brough -Adaptavist-

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:

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

csv

issue

jira

import