[SOLVED] Importing from CSV to update a Foreign Key

ℹ️ Support
1

Continuing the discussion from Importing from CSV to Update Foreign Key:

Sorry to bring up an old topic.

I am running 3.2.4 and am facing a similar issue.

I can’t seem to update an existing record with a foreign key.(FK)
Overwrite Existing is ticked

Result:

All the emails already exist in the database and are member of the lists
Subscriber data was updated for 31 subscribers
0 subscribers were matched by foreign key, 31 by email

but none of them have my FKs.
and in Subscriber History / Subscription I have

No user details changed

Any suggestions appreciated.

TIA

2

@digit Importing using a foreign key seems to work for me. Ensure that the column title is “foreign key”.

1 Like
3

Thanks Duncan,
now that works for me :smile:
I was using “ForeignKey” which the system seemed to get same as "email"
ie. it didn’t ask me to identify the attributes.
Using “foreign key” it did and so now it’s updating.

Thanks very much.

1 Like