Provide a way to import CVS with multi-line fields

[Chris Nelson]

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.

[Adrian Fritz]

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.

[Adrian Fritz]

.. instead of simply pressing <ENTER> .

[Chris Nelson]

Replying to 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.

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.

[François Granade]

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 ?

[Steffen Hoffmann]

Replying to farialima:

![...] 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.

[Steffen Hoffmann]

Replying to farialima:

![...] 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.