Modify ↓
Opened 15 years ago
Closed 15 years ago
#5546 closed enhancement (worksforme)
Support non-comma delimited files.
Reported by: | Owned by: | François Granade | |
---|---|---|---|
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)
Note: See
TracTickets for help on using
tickets.
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:
Try exporting from Excel: you will see it adds the quotes. And I'm quite sure it'll work with the import plugins.