I seem unable to update an existing row in MobileConnect All Contacts list.

I also seem to not be the only one with the confusion:

Is there a way to update MobileConnect Subscription Data from a Data Extension?
How do I update mobile connect demographics when data for a contact changes?

My account seems to be set up correctly based on this known issue.

I have a single row in a source Data Extension:

Source DE

And an Import Definition like so:

Import Definition Import Definition Mapping

Which points to the source DE. The Contact Key field on the row in the source DE matches a Contact Key in the All Contacts list. I would expect it to then update the mobile contact with the new values but it does not. I.e., I would expect the highlighted fields (see below image) to now include the boolean values as seen in the source DE:

MobileConnect Contact

Contact builder looks like so:

Contact Builder

Question is what am I missing here? Is Contact Key not the correct upsert key? I also see a field called Contact ID - is this instead it?

Edit: I am getting the following notification email with validation errors from SFMC:

"The following import has completed with validation errors" and the csv says required field _mobileNumber although the Mobile Number in my import is not empty:

Row Number Error Number Error Code Error Details Row Data
0 133273946 RequiredField _MobileNumber [34805][1234567890][1234567890][DK][Test][Test][False][True]

  • I am just taking a guess here. Can you see all the mobile connect demographics Attribute group linked to the contact key in Contact Builder->Data Designer? – Praveen Kumar Bandi Nov 10 '17 at 2:23
  • Another guess, have you tried with 1/0 values for true/false? – SebOB Nov 10 '17 at 7:16
  • @PraveenKumarBandi - I updated the post so you can see the Data Designer – rzr Nov 10 '17 at 8:37
  • @SebOB - Do you mean changing the Source DE to have numeric fields instead of t/f? – rzr Nov 10 '17 at 8:39
  • @rzr, I think the mobile number field on your DE should be of type "Phone" not text – Praveen Kumar Bandi Nov 10 '17 at 11:39

Please check you mapping in the import definition. On some occasions, the "Map by Header Row" is failing. Even though the mapping looks correctly in the UI, it fails to map the fields properly. Switching it to "Map Manually", even though it is the exact same mapping, sometimes solves the issue.

| improve this answer | |
  • This turned out to be the issue. – rzr Nov 11 '17 at 6:41
  • I encountered the same issue just today, and this simple fix did the trick. Thanks for sharing! – PhilipW Feb 5 at 21:51
  • You are welcome, @PhilipW - remember to upvote, when an answer is helpful – Lukas Lunow Feb 5 at 21:53

Based on the error you are receiving, I would believe you should add the following to your import Data Extension:

  • Priority (which should just have default value of 1)
  • Mobile Number needs to be written as 4512345678 (i.e. 10 digits), even though you have proper locale
  • Ensure Field Lengths are equal to each other (or that the DE isn't longer than target fields in Mobile Demographics)

Hope it helps

| improve this answer | |

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.