Are there any differences when importing from csv to Linux VS Win

[James Malgieri]

I was just wondering if there were any differences when importing via a csv file into Jira on Linux VS Jira on Windows in terms of formatting the csv files or any perhaps any invalid characters ( <, > & ) unique to one OS that are not invalid in the other OS?

Also are there formatting changes for date and date/time java/javascript setting between Linux/Win that I need to be aware of or are the setting for one OS good for the other?

Thanks,

Jim

[Max Malygin · Accepted solution]

Import works identically on Linux and Windows OS. But you must remember about the preparation of the CSV file - https://confluence.atlassian.com/adminjiraserver/importing-data-from-csv-938847533.html#ImportingdatafromCSV-formatPreparingyourCSVfile

All text field must be quoted with " so you will not run into a problem with invalid characters.

And consider the date format setting in your Jira instance - https://confluence.atlassian.com/jirakb/dates-are-not-properly-imported-from-csv-file-245825977.html.

[James Malgieri]

Thank you Max.

I found out there are many invalid characters in the text fields and the URL you gave for the date settings is very good information.

Thanks Again,

Jim

-----------------------------------------------------

Max, 

In the URL you gave for the date settings, it says to use javascript format data/date-time values that I am unaware of.

• d/MMM/yy = %e/%b/%y
• dd/MMM/yy h:mm a = %e/%b/%y %I:%M %p

I had been using the following for 

• MM/dd/yyyy = %m/%d/%y
• MM/dd/yyyy  hh:mm:ss a = %m/%d/%y %h:%m:%s %a

Is what I am using correct for MM/dd/yyyy hh:mm:ss a?

Jim

[James Malgieri]

I believe I have it figured out for the jira.date.time.picker.javascript.format

11/27/2019 12:55:23 AM  <=> %m/%d/%Y %I:%M:%S %p

Jim