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

Stephan Gruzinski

I have tried to import a CSV file i created from MS Project task list and keep running into an issue with dates.

I was originally having issue with the date format until i looked at the text version of csv. The format in the CSV file dd-MMM-YYYY

Once i was able to clear the errors form the import. I looked at the task and the dates are not correct.

I mapped the Submitted dated date to Date Created and Due Date to Due Date.

I did not use Custom Fields.

Here is an image of date section in the task, it is making everything 27/DEC/20 and screen shot of the dates from the csv file. I know the dates are in the past but it is putting the same date for all even the ones in the future.

Accepted answers

All comments

Ivan Lima

Hi @Stephan Gruzinski, you should be using something like dd/MMM/yy. Have a look at Dates are not properly imported from CSV file, and make sure to use a plain text file and not excel to work on your file.

Stephan Gruzinski

The format in in that I see in excel is dd-MMM-YY. When i click on a cell it shows the format of mm/dd/yyyy

I opened up the .csv file in notepad and see this format dd-MMM-YY

Do i need to edit each entry in the plain text file to dd/MMM/yy?

Or is there a better way to edit all of the entries or does Jira take a different format since you can edit it during the import process?

Ivan Lima

Make sure you choose the right date format that matches exactly what you have in your CSV in the setup screen. What I normally do is using excel for the bulk of work and final edit it using VSCode with some plugins, but any text editor works. My suggestion is to use it with 2 or 3 simple lines, a text editor, the date format I mentioned, so you have better control over that. You can easily see it working and the changes you had to put in place to make it work.

Stephan Gruzinski

Thanks for the Help

Mary Jennings_76b346

I’ve run into similar issues with importing CSVs into Jira, and honestly, it can get a bit tricky, especially when the formatting isn’t just right or you have larger datasets. What’s worked for me is prepping the file in advance and double-checking that all fields match what Jira expects, but even then, it’s not always straightforward.

If you’re still stuck or want a smoother way to handle CSV imports (and exports, too), I’d suggest checking out Skyvia on this page. I found it handy for managing data between Jira and other systems without having to mess around too much with manual uploads.

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-core