Modify

Opened 4 years ago

Last modified 3 years ago

#8777 new enhancement

Provide a way to import CVS with multi-line fields

Reported by: ChrisNelson Owned by: 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 (0)

Change History (6)

comment:1 follow-up: Changed 4 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 4 years ago by AdrianFritz

.. instead of simply pressing <ENTER> .

comment:3 in reply to: ↑ 1 Changed 4 years ago 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.

comment:4 follow-ups: Changed 4 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 3 years ago by hasienda

  • Keywords CVS multi-line added
  • 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.

comment:6 in reply to: ↑ 4 Changed 3 years ago 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 Comment

Modify Ticket

Action
as new The owner will remain farialima.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.