View Issue Details

IDProjectCategoryView StatusLast Update
0019934phpList 3 applicationSubscriber Importpublic11-05-19 10:47
Reportervaceklu 
PriorityhighSeverityfeatureReproducibilityalways
Status newResolutionopen 
Product Version3.4.1 
Target VersionFixed in Version 
Summary0019934: Parse CSV by CSV standard - rfc4180
DescriptionPhplist don't parse csv defined by rfc 4180 specialy point 6. I have a file that is separated by ";" and each column is in double quotes. In double quotes I have a newline. Example of that file is in attachments. I want to import that file by options "Import by uploading a CSV file with email addresses and additional data". Problem is that phplist takes newline in double quotes as two records not one. This is possible see in second attachment.

By RFC 4180 is possible to write newline in double quotes and it will be taken as newline in the column not the end of line.

This is happening from version 3.2.5 to 3.4.1.
Steps To ReproduceCreate similar file to in attachment and try to import it.
TagsNo tags attached.

Activities

vaceklu

10-05-19 13:33

reporter  

michiel

11-05-19 10:47

manager   ~0062190

Yes, we should rewrite that part using https://php.net/fgetcsv
I think that didn't exist yet, when I wrote this.