View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0015358||phpList 3 application||Subscriber Import||public||30-10-09 01:59||19-05-15 16:23|
|Target Version||2.10.12||Fixed in Version||2.10.12|
|Summary||0015358: Import does not strip doublequote text delimiters when using 'import emails with the same values for attributes'|
|Description||By default Openoffice Calc uses the text delimter " when exporting CSV files. When importing to phplist it appears not to remove these which results in email addresses that look like: "email@example.com" instead of just: firstname.lastname@example.org. The actual import itself goes fine but then later these doublequotes result in the addresses being regarded as invalid by phplist.|
Line 407 of importcsv.php includes the code:
$line = str_replace('"', '', $line);
For whatever reason - i am not a competent enough coder to work out what's happening here - the code above either doesn't get called or does not have the intended effect.
As OpenOffice is a popular choice both for regular users and for those looking to convert xls files and export them as csv, i contend that this should just work without having to manually alter the text delimiter.
I have twice seen this effect. First when importing a large number of email addresses and then secondly through exporting a CSV file consisting of just two email addresses in an attempt to replicate the behaviour.
This appears consistent arcoss both 2.10.9 and 2.10.10.
|Tags||No tags attached.|