Update MobileConnect Demographics from a Data Extension

Question

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:

And an Import Definition like so:

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:

Contact builder looks like so:

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]

Answer 1

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.

Answer 2

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