Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

CSV Import - how to preserve whitespace?

Janene Pappas
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 31, 2020

I'm working on importing all of a team's issues from Github via a .csv file and am struggling with getting the whitespace in a field preserved during the import. I've read the doc and it says: 

Treating special characters literally

Use double-quote marks (") around a section of text to treat any special characters in that section literally. Once this data is imported, these special characters will be stored as part of Jira's field data. Examples of special characters include carriage returns/enter characters, commas, etc.

So I've attempted to put "\n" in the .csv file for those fields and I get the text just all run together on one long line with "\n" in where I expect whitespace, like so:

Imported from GitHub"\n\n"Assignee: "\n"Labels: Team-Espresso,iOS"\n"

What should I put in the .csv to have it look like this:

Imported from GitHub

 

Assignee:

Labels: Team-Espresso,iOS

TIA!

 

1 answer

1 accepted

0 votes
Answer accepted
Janene Pappas
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 31, 2020

And now I find this is an active bug. The 2nd solution in this post helped me. 

 

https://jira.atlassian.com/browse/JRASERVER-46365?_ga=2.144961780.1933347900.1585691624-2004416278.1581104812

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events