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; } } }

Due Date CSV

Corinna Führing

Hello we have created the Due Date for the CSV Import in following format

DAIENTRY-643,,Automatic Driver Recommendation (ADR),Feature Dependency,Traffic Information,cfuehring,,2015-05-06,E21.0,FL TTS,,

But after Import another Date is shown why.......

Import-Test.txt

image2016-1-6 0:4:17.png

Accepted answers

Phill Fox

here is a version of your test file but saved with the extension .txt rather than .csv. The JIRA Import does not worry about the extension. This file has the format yyyy-MM-dd.

All comments

Phill Fox

Hi Corinna Führing

Dates are frequently challenging as there are so many configuration choices you can make. So from your example you were expecting this to be imported as 6th May 2015 or 5th June 2015? And what date did you actually get?

Once you work out the format that is correct for your configuration it will then be possible to upload and correct using the same values.

Corinna Führing

Hello thanks. i wanted it to be the 05-05-2015 but I actually got the 28-12-2014

Corinna Führing

JJJJ-MM-TT; this is the format of the Date in the Excel file, but later on we exported it to a csv file and it was text and than into Jira

Phill Fox

That is strange. I can not spot an obvious correlation between those two dates 28-12-2014 and 05-05-2015. I have just tried an import on my local development instance and that wanted dates in the format YYYY/MM/DD which is year then month then date. This might be worth a try with a single record to see what you get.

Phill Fox

@Corinna Führing
Ok lets step back and work through this one step at a time.
From your comment above you have a layout as follows.
DAIENTRY-643,,Automatic Driver Recommendation (ADR),Feature Dependency,Traffic Information,cfuehring,,2015-05-06,E21.0,FL TTS,,

So if you run the csv importer and set the date format to be yyyy-MM-dd (note the different case for Months mm means minutes.)

image2016-1-6 0:4:17.png

This should then import your file using that date format.

Corinna Führing

I will now try an import with that file again. I checked that if i introduce a Date in the Editor following format appears 10:11 AM 1/6/2016 so I wonder if your format in JIRA will work out–very confusing everything Thanks

Phill Fox

Ok so your format is not 2015-05-06 but is 10:11 AM 1/6/2016 so the date format you need to use on the mapping is hh:mm a MM/dd/yyyy assuming that the date in your example is 6th January and not 1st June

Corinna Führing

ok ill try agaon i just checked our first solution , import works perfect but agian wron date 2014-12-28 appears...maybe new format is solution thansk

Corinna Führing

Due Date.jpgby the way: this is how my due date of Parent ID appears , different from System Dates

Due Date.jpg

Corinna Führing

and my date i want to have finally is six of may of 2015

Import-Test.csv

Corinna Führing

i open this file with editor not with excel

Phill Fox

Ok in this example you have 2015-05-06 representing 6th may 2015 and so the date pattern for this is yyyy-MM-dd

Corinna Führing

ok i ll try

Phill Fox

here is a version of your test file but saved with the extension .txt rather than .csv. The JIRA Import does not worry about the extension. This file has the format yyyy-MM-dd.

Corinna Führing

Editor.jpgi am opening it with this editor i have windows excel 2013

Editor.jpg

Phill Fox

I am not familiar with Editor so this may be your text editor but Wordpad will allow you to see the file content without changing any of the display format. I would avoid Excel as it changes your display (as you have seen) and if you save from Excel it will alter your base file as well.

Corinna Führing

i did not get what you told about saving it as txt but i will make a new try opening my here attached csv file with editor windows and than save it...date appears as you saw it too and than i will give Jira yyyy-MM-dd

Corinna Führing

now i did it with this file and it worked perectly !!!!!!!but i have no clue anymore how i get this file and what i did..how can i create this files out of my excel sheets ???

Import-Test-Vox.txt

Phill Fox

Great news that this worked for you and you now have a working approach which confirms imports to JIRA are working. So what we need to do now is work through your export from Excel to CSV to understand what format (or possibly formats) are being exported from Excel. So if you now go into your Excel spreadsheet and save it as CSV then open in Editor you should be able to see the format in your file.

Corinna Führing

ok i am creating now a nex excel file with the import test dates- First question if I fill in due date now...how shall i do.. all the cells are formated Standard up tp now

Phill Fox

Ok for simplicity sake I would retain the standard formatting for now and only create 3 or 4 lines of items. Then save as csv. Open the csv in Editor (not Excel) and confirm the format of the date columns. Then load this in to JIRA setting the date format to match what you saw in Editor (NOT what you see in Excel). Confirm these are loaded correctly and then continue with all the other items.

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-administration

jira-core