Forums

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

Import from CSV - Description has multiple lines - Using double quote does not work

Dominique Cote
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 28, 2018

Im trying a simple issue import from a CSV file.  I need the description to retain carriage returns once the issues are imported.

I quoted the text that needs to be on multiple line as specified in documentation but it doesn't work.

Here is a sample of my CSV (Encoding is UTF-8):

Issue Type;Summary;Description;Priority;Due Date;Custom field (Epic Link);Custom field (Client)
Task;Configure Email;"1 This is a test.
Lorem Ipsum dolor si amet.
Liste 1
Liste 2";

This description is displayed this way in JIRA (after import):

1 This is a test.Lorem Ipsum dolor si amet.Liste 1Liste 2

 

1 answer

1 vote
Steven F Behnke
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 28, 2018

It's broken, much to my dismay -- https://jira.atlassian.com/browse/JRASERVER-46365

Dominique Cote
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 28, 2018

Thank you!  My god, such a relief.  I'll use the recommended workaround (add \\ before each line).

Cheers!

Steven F Behnke
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 28, 2018

Cheers

SHARAZUL SALLEH
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 16, 2019

Thanks. Just have this issue >.<

Steven F Behnke
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.
January 17, 2019

Apparently if you simply do not click 'Map Value' checkbox things work just fine.

Like # people like this
Adam Rocska
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 12, 2020

WTH 🤣 Thanks @Steven F Behnke . I'll give this brainfck work-around a shot now.

Niek Kaarsgaren
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 24, 2023

@Steven F BehnkeThis is apparently still the only way.. But thanks!

Fontane, Matt April 26, 2023

The "don't tick the Map field value" box thing didn't work for me. However, adding two backslash characters, \\, where I wanted the line break did work. Note: do not add a space after the \\ as this will add a space before your new line. This is super annoying issue; hopefully this will be fixed soon.

Like Nick Whitney likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events