Some of the address, city, state, zip records in the social_fields_data for my users has the correct value in the datakey field. The datakey field holds values for them like "address1", "city", "state", "zip", etc.
However other users in this table have no datakey value in the address records.
In addition the field_id values are also different between these two sets of records.
What should I do? I have having trouble creating custom membership reports because I can't reliably extract address data. In addition, I use the Appcarvers mobile app and it can't display address data in user profiles as well.
Is there harm in manually updating the datakey and field id to be consistent on all records?
I would upload screenshots to explain, but I don't see a way to make this forum post private just for stackideas Support team.
Thanks