back to phpList.org

Importing Subscribers from File errors

Funcion: Import by uploading a CSV file with emails and additional data
Version 3.3.1

I noted three errors using this function:

  1. When uploading to a specific list in a vategory list, the function ‘Check Test Output’ does not work anymore.
  2. I am having problems with character outside the standard US-ASCII range.
  3. Overwrite Existing does not work as expected

Problem 1.
When uploading to a specific list in a vategory list, the function ‘Check Test Output’ does not work anymore.
Although Test output was checked no list of parsed emails was presented screen.
Instead I got this output:
Reading emails from file … …ok, 186 lines
Importing 185 subscribers to 1 lists, please wait
177 emails succesfully imported to the database and added to 1 lists.
185 emails subscribed to the lists
8 emails already existed in the database
0 subscribers were matched by foreign key, 185 by email
Import some more emails
Reset import session had no effect
All rows were commited to the datadase and list.

Problem 2.
I am having problems with character outside the standard US-ASCII range.
Although mny system had been converttoutf8 sind version 2.x or so and checking this function only reports:
The DB was already converted to UTF-8 on 2014-07-28 15:14
I have trouble uploading data from CSV file with non-usascii characters.
Example
The name Thérèse is being truncated to Th.
That is after the first NON US-ASCII character.
Also
Also the new Attribute value België is added as Belgi

Problem 3.
Overwrite Existing checkbox does not work anymore.
For subscribers that are already in the database, but are on another list, new values for ther associated attributes are not updated.
Example:
I added the attribute ‘Land’ (Dutch for Country) to the subscriber data.
The import file contains a column ‘Land’, like:
Achternaam;Voornaam;Email;Actiecode;Land
Surameofperson;Givenname;email@example.com;FXNQUZK;Nederland

In case this row for email@example.com existed but without a value for ‘Land’.
The ‘Land’ Nederland is not added to the subsccriber data.
This might not be an error but my personal intrepretation of the function ‘Overwrite Existing’

I am having the same issue as #3 above. I had to revert back to 3.2.

Same here for #3 in 3.3.1.
Reported in https://mantis.phplist.org/view.php?id=18595