Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

1 answer

1 accepted

1 vote
Answer accepted
Max Malygin Community Leader Jan 13, 2020

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,528 views 22 32
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you