Hi Danny,

Provided you already have a Profile type created in your EasySocial, and assuming you’ve already insert user’s basic data into jos_users and jos_social_users, below are the tables / steps you might need in order to migrate your user data from external source into EasySocial.


1. You need to map your users ( from jos_users.id ) into table jos_social_profiles_maps.
This is to assign your users to a correct profile type.

2. You need to get the ids of custom fields that you’ve created for your profile type. You can run the below sql to get the field id.

select a.id, a.unique_key, a.title from jos_social_fields as a

	inner join jos_social_fields_steps as b on a.step_id = b.id

where b.`type` = 'profiles'

and b.uid = 1

and a.unique_key not like ('JOOMLA_%');

3. Now you have the field ids, you will need to insert user data ( e.g birthday, gender, address and etc ) into table ‘jos_social_fields_data’. You might want to see how the data being saved into this table for your existing users.

Hope this help and have a nice day!