[SalesForce] Updating All Subscribers List with query, extract and import

I have followed instructions from this link :

How to Query a Data Extension and Update the Subscriber list at the Child Business Unit Level?

Our current configuration allows existing users to update their email address.
This page is hosted on a e commerce engine – Hybris
Issue is that when this is updated , it is not updated in SFMC, hence all they do not receive future communication.

Issue is that the final step, import activity keeps failing (csv import). Here is a screen shot of the error log:

enter image description here

I will appreciate any help in solving this.

EDIT

I ran the first iteration and it worked. However we I tried to combine all five steps into a automation, it failed.

Import Failure 2

What I do know is that those are the values for my subscriber key, which I have manually mapped. I have checked the file on the FTP and it contains these values.

Best Answer

Since you wanting to update the All Subscribers list (not a data extension), the correct field name is Email Address (note: the space). You will need to rename the header in your file to match or choose to map fields manually in your import configuration. If subscriber key is enabled in your account, you will also need to supply a column named subscriber key along with the corresponding subscriber key values for each emailaddress.

In order to update the status, your file must contain a column named Status. The status values will need to be either "active" or "unsubscribe". That part is tricky, since the subscriber status in the Platform appears as "Active" or "Unsubscribed".

Refer to the following link for more information on configuring import activities. https://help.marketingcloud.com/en/documentation/exacttarget/interactions/activities/import_activity/ https://help.marketingcloud.com/en/documentation/exacttarget/subscribers/subscribers1/imports/

Related Topic