View Issue Details

IDProjectCategoryView StatusLast Update
0017360phpList 3 applicationSubscriber Importpublic21-06-18 14:00
Reportergingerling Assigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
Status assignedResolutionopen 
Product Version3.0.7 
Summary0017360: csv import LOOKS like it skipping the customer id column
Descriptioncsv import process appears to skip customer id pairing to foreign key, at several stages. In the end it does actually use the id as foreign key but does not communicate this.
Steps To Reproduce1) use example data set attached (anonymised example file from prestashop export)
2) set , as deliminator
3) see attribute selection screen, the id column does not show
4) see next page, id shows as skipped
5) import the emails and see the resulting subscribers, id is used as key.

Also see screenshot showing that you can import emails where id column has repeated numbers, so three ID=255 but different names and emails, and phpList still assumes the column is ID and you end up with three identical foreign keys. (I was testing to see if phpList was assuming that is ID because the numbers were unique and sequential)
Additional InformationHave tried:

Renaming the column from ID to Foreign Key

Inserting a blank column at the start, before the ID column

moved column to the end so it is the last not the first

none of these made the column appear in the attribute selection list or affected the problem in any way



Tagsdocumentation

Activities

gingerling

05-09-14 17:56

manager  

customer_list_1.2.csv (601 bytes)   
ID,Title,Last name,First Name,Email address,Age,Enabled,News.,Opt.,Registration,Last visit
639,1,name,Gareth,email@yahoo.co.uk,-,1,0,0,2014-09-03 11:35:28,2014-09-03 11:38:40
638,2,name,Barbara,emails@onetel.com,-,1,0,0,2014-09-01 13:06:48,2014-09-01 13:01:49
637,2,name,Victoria,email@hotmail.co.uk,-,1,0,0,2014-08-30 20:08:17,2014-08-30 20:01:37
636,2,neme,johanna,email@ntlworld.com,-,1,0,0,2014-08-29 11:36:50,2014-08-29 11:34:22
635,2,name,Melissa,email@gmail.com,-,1,0,0,2014-08-28 14:56:07,2014-09-01 14:26:19
634,1,name,Gareth,email@yahoo.co.uk,-,1,0,0,2014-08-23 23:46:19,2014-08-24 23:23:58
customer_list_1.2.csv (601 bytes)   

gingerling

05-09-14 17:58

manager  

gingerling

05-09-14 18:05

manager  

id_was_imported_after_all.png (141,637 bytes)   
id_was_imported_after_all.png (141,637 bytes)   

gingerling

05-09-14 18:10

manager  

gingerling

05-09-14 18:17

manager   ~0054885

Replicated in ethical pets hosted account

and more worryingly demodev, which has never had ethical pets data on it before (so this isn't caused by us having use ID as the foreign key before on the installs)

gingerling

05-09-14 18:20

manager   ~0054886

replicated with same file made tab deliminated

michiel

05-09-14 22:13

administrator   ~0054892

don't put real data on demodev. The demodev data is meant to be published at some stage.

michiel

06-09-14 20:24

administrator   ~0054897

To avoid problems, phpList ignores column names that are system values

This includes "ID".

If you rename the column "Foreign key" it will work fine.

michiel

06-09-14 20:25

administrator   ~0054898

So, your report "LOOKS LIKE" is incorrect. It REALLY DOES skip that column

gingerling

08-09-14 10:12

manager   ~0054910

no, it imports it. see screenshot id_was_imported_after_all

that subscriber has a forin key that is directly taken from "id"

michiel

08-09-14 10:20

administrator   ~0054911

you're confused. Let's chat.

gingerling

11-10-14 12:54

manager   ~0055396

so we made a list of terms that phpList will skip because they are already part of the phpList system, but I can't find this list anywhere. We need to say what coulumn names will be ignored in the docs

michiel

13-10-14 11:01

administrator   ~0055401


The following column headers will be "Skipped"

This is because this data is managed by phpList and cannot be manipulated with an import.

id
confirmed
blacklisted
optedin
bouncecount
entered
modified
uniqid
subscribepage
passwordchanged