Opened 5 years ago

# Provide a way to import CVS with multi-line fields

Reported by: Owned by: ChrisNelson farialima normal TicketImportPlugin normal CVS multi-line 0.11

### Description

Comments and Description can have multiple lines but there is no way to put a line break in a CSV value. It would be nice if the import looked for "\n" (or something) and made a link break there.

### comment:1 follow-up: ↓ 3 Changed 5 years ago by AdrianFritz

Interesting, I'm able to import / insert multiple lines in those fields. I use, for example GAFYD, OpenOfice, Excel, to edit / copy / paste this fields. To insert a multiple a new line I press <CTRL>+<ENTER> keys.

### comment:2 Changed 5 years ago by AdrianFritz

.. instead of simply pressing <ENTER> .

### comment:3 in reply to: ↑ 1 Changed 5 years ago by ChrisNelson

Interesting, I'm able to import / insert multiple lines in those fields. I use, for example GAFYD, OpenOfice, Excel, to edit / copy / paste this fields. To insert a multiple a new line I press <CTRL>+<ENTER> keys.

I'm importing from CSV, not XLS. I'll try <Crtl-Enter> but I don't expect it to work there. I know spreadsheets can have multi-line fields.

### comment:4 follow-ups: ↓ 5 ↓ 6 Changed 5 years ago by farialima

You can have fields with multiple lines in an CSV file. You just have to double-quote the value

e.g.

header1,header2
value1,"value
with
multiple lines"
value2,"another value
with two lines"


but it's not easy to write by hand, I can tell you from experience :)

In any case, this is a limitation of the CSV format, not sure we can consider it as a bug/enhancement for the TicketImportPlugin plugin ? Or should we drop support for CSV ?

### comment:5 in reply to: ↑ 4 Changed 5 years ago by hasienda

• Summary changed from Provide a way to import multi-line fields to Provide a way to import CVS with multi-line fields

![...] In any case, this is a limitation of the CSV format, not sure we can consider it as a bug/enhancement for the TicketImportPlugin plugin ? Or should we drop support for CSV ?

Ok, made this clear in the ticket summary too.

### comment:6 in reply to: ↑ 4 Changed 5 years ago by hasienda

![...] Or should we drop support for CSV ?

At first glance it looks like a smart idea, since XLS is that more powerful/versatile than CVS. But many users might still not need this extra and can live with good plain CVS. So do we really want the best Trac ticket importer support less input formats, even stranger: one proprietary file format only? Looks like we should rather have ODS (open document spreadsheet - OpenOffice.org) instead of further limiting the possibilities. Just my 2 ct.