0

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.

  • FieldNotFound _EmailAddress.. Is this field present in your csv file? – Palash Rai Dec 14 '16 at 10:25
  • Yes the field is there. However, in the Data Extension it is call EmailAddress... not sure if I have to rename it to "EmailAddress". It is the only required field. – Samuel Dare Dec 14 '16 at 10:26
  • 2
    Ok you're importing data into DE. try to do manual import and use map field by manually option. Also, its required to match Import file field with DE field and in case its not matching then you can use map field by manually option. – Palash Rai Dec 14 '16 at 10:33
  • Thank you for this. I have tried the above and now the import is failing with a different error code "Not Found". I am posting this in the question – Samuel Dare Dec 14 '16 at 17:51
3

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/

  • Thank you for this. I have tried the above and now the import is failing with a different error code "Not Found". I am posting this in the question – Samuel Dare Dec 14 '16 at 17:31
  • What is the update type on you import activity? If you search all subscribers by subscriber key, are you able to find records for 1073362717, 1073362718, 1073362719, & 1073362720 ? Also, can you provide a a screenshot of your source file? – David Devoy Dec 14 '16 at 17:58
  • You are a star!! For some silly reason I had set the import activity to update only! Thank you so much @David Devoy! – Samuel Dare Dec 14 '16 at 21:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.