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? Nov 10, 2017 at 2:23
  • Another guess, have you tried with 1/0 values for true/false?
    – SebOB
    Nov 10, 2017 at 7:16
  • @PraveenKumarBandi - I updated the post so you can see the Data Designer
    – rzr
    Nov 10, 2017 at 8:37
  • @SebOB - Do you mean changing the Source DE to have numeric fields instead of t/f?
    – rzr
    Nov 10, 2017 at 8:39
  • @rzr, I think the mobile number field on your DE should be of type "Phone" not text Nov 10, 2017 at 11:39

2 Answers 2


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.

  • This turned out to be the issue.
    – rzr
    Nov 11, 2017 at 6:41
  • I encountered the same issue just today, and this simple fix did the trick. Thanks for sharing!
    – PhilipW
    Feb 5, 2020 at 21:51
  • You are welcome, @PhilipW - remember to upvote, when an answer is helpful Feb 5, 2020 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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .