JIRA CSV Importer - Carriage Return

Vivian Escalante January 31, 2018

My scenario: 

1. Exporting as a CSV from Google Sheets

2. The JIRA field would be "Onsite Dates" and I want the field to display multiple lines like below. 

 Screen Shot 2018-01-31 at 9.06.52 AM.png

3. I did alt + enter to add a new line, but when I export it as a CSV and upload it to the CSV importer the new line is lost, so it displays "Start Dates Flr 5: 11/10-11/17 Flr 6: 11/17-11/28" and I need it to display in 3 lines. 

 

Anyone know how to resolve this? Thanks. 

2 answers

2 votes
Peter Del Sordo November 29, 2018

Our team discovered that unchecking the "Map field value" box during the third step of the external csv import process, will preserve formatting for any text field that contains special formatting or carriage returns (e.g.-Acceptance Criteria, Descriptions, and Comments).  We tested this work-around for numerous import scenarios and it works every time!

Ирина Герасименко December 28, 2018

It works! Thank you very much!

Shaun Butler October 9, 2019

Amazing - this works! Assume this is a bug?

Wiese, Scott April 1, 2024

Thank you Thank you Thank you! This saved me a bunch of time.  Worked for me also. 

0 votes
Andy Heinzer
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 1, 2018

Hi Vivian,

Sorry to hear that you have encountered this problem with Jira, I believe that this scenario is actually documented as a bug within Jira in https://jira.atlassian.com/browse/JRASERVER-46365

While that bug itself does list a work-around for having new lines appear when imported to Jira:

Workaround

It is possible to create newlines by using:

\\ 

at the beginning of each line as per the example below:

Summary,Type,Description,Status
"next csv new line test","Bug","Atlassian
\\ Testing Issue
\\ Acceptance Criteria
\\ - Line 1
\\ - Line 2
\\ - Line 3
\\ - Line 4",To Do

 However, this workaround creates another issue with the exported field as mentioned in this bug ticket: JRA-46364

There also exist other possible alternatives here.  For example the thread over in https://community.atlassian.com/t5/Jira-questions/How-can-I-import-from-CSV-with-carriage-return-and-line-feed-in/qaq-p/322723 explains through the use of a 3rd party add-on to Jira such as the Jira Command line interface, it is possible to import those CSV files as is without any additional modification to that existing file.

I hope this helps,

Andy

Mac_Calma July 4, 2018

Hi @Andy Heinzer,

 

"\\" doesn't work for me. It is imported as is together with the "

Suggest an answer

Log in or Sign up to answer