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.
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.
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!
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:
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,
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 ...
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