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

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

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

Accepted answers

Max Malygin_rtpe6j

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.

All comments

Max Malygin_rtpe6j

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.

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

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

Welcome!

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

Quick Links

Find more posts tagged with

server

csv

jira-software

jira-software-server

import

java

windows

javascript

linux