| Anonymous | Login | Signup for a new account | 02-09-10 21:43 GMT | ![]() |
| Main | My View | View Issues | Change Log | Roadmap |
| View Issue Details [ Jump to Notes ] | [ Print ] | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |
| 0015358 | phplist | Subscriber Import | public | 30-10-09 01:59 | 19-04-10 21:18 | |
| Reporter | crowdofone | |||||
| Priority | normal | Severity | minor | Reproducibility | always | |
| Status | resolved | Resolution | fixed | |||
| Platform | OS | OS Version | ||||
| Product Version | 2.10.10 | |||||
| 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: "name@domain.com" instead of just: name@domain.com. 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 | import delimiter textdelimiter | |||||
| Attached Files | ||||||
| Copyright © 2000 - 2010 MantisBT Group |