Ticket #8777 (new enhancement)

Opened 2 years ago

Last modified 2 years ago

Provide a way to import CVS with multi-line fields

Reported by: ChrisNelson Assigned to: farialima
Priority: normal Component: TicketImportPlugin
Severity: normal Keywords: CVS multi-line
Cc: Trac Release: 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.

Attachments

Change History

(follow-up: ↓ 3 ) 05/09/11 19:15:41 changed 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.

05/09/11 19:18:28 changed by AdrianFritz

.. instead of simply pressing <ENTER> .

(in reply to: ↑ 1 ) 05/09/11 19:26:26 changed by ChrisNelson

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.

(follow-ups: ↓ 5 ↓ 6 ) 05/09/11 19:33:52 changed 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 ?

(in reply to: ↑ 4 ) 08/20/11 22:34:23 changed by hasienda

  • keywords set to CVS multi-line.
  • summary changed from Provide a way to import multi-line fields to Provide a way to import CVS with multi-line fields.

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.

(in reply to: ↑ 4 ) 08/20/11 22:42:21 changed by hasienda

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.

Add/Change #8777 (Provide a way to import CVS with multi-line fields)




Change Properties
Action