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

JIRA CSV Importer - Carriage Return

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

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!

It works! Thank you very much!

Amazing - this works! Assume this is a bug?

0 votes
Andy Heinzer Atlassian Team Feb 01, 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

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
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

375 views 1 3
Join discussion

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