Opened 7 years ago

Closed 7 years ago

# Support non-comma delimited files.

Reported by: Owned by: max.vorticity@… farialima normal TicketImportPlugin normal 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.

### comment:1 Changed 7 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.