Modify

Opened 5 years ago

Closed 4 years ago

#5546 closed enhancement (worksforme)

Support non-comma delimited files.

Reported by: max.vorticity@… Owned by: farialima
Priority: normal Component: TicketImportPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description

Tab delimited is needed if the field data itself can contain commas. It appears that using delimiter='\t' would be needed when defining the reader: reader = csv.reader(file, delimiter='\t'). So it would be great if a custom delimiter could be somehow be defined when importing the file. At least some common delimiters like tab, '|', ':', etc.

Attachments (0)

Change History (1)

comment:1 Changed 4 years ago by farialima

  • Resolution set to worksforme
  • Status changed from new to closed

Commas *are* supported. Although I haven't tested it for the Import plugin, I have used csv.reader before on other projects that had commas. CSV files must "escape" commas, i.e. put them between double quotes. a CSV with a column with commas will look like this:

ticket,description,field_with_commas
123,a description,"a field, containing commas"

Try exporting from Excel: you will see it adds the quotes. And I'm quite sure it'll work with the import plugins.

Add Comment

Modify Ticket

Action
as closed .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from farialima. Next status will be 'closed'.
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.