Hi Ynover,
I afraid to fix the fields association, it will be a very tedious works and you will need to understand fully how the data being stored. I believe rerun the migration will be easier for you. To re-run your JomSocial group's migration, you will first need to clear the migrated groups data. Below are the sql statements you must run in order to clear the migrated data.
Please backup your database before you execute the sql statements.
Please execute the below sql statement in the following sequence. Also, you will need to rename the jos_ to your own Joomla db table prefix.
1. Delete group streams.
delete a, b from jos_social_stream as a
inner join jos_social_stream_item as b on a.id = b.uid
where a.cluster_type = 'group'
and a.cluster_id IN (select m.uid from jos_social_migrators as m where m.component = 'com_community' and m.element = 'groups');
2. Delete group members.
delete from jos_social_clusters_nodes where cluster_id in (select m.uid from jos_social_migrators as m where m.component = 'com_community' and m.element = 'groups');
3. Delete group photos.
delete from jos_social_photos where `type` = 'group' and uid in (select m.uid from jos_social_migrators as m where m.component = 'com_community' and m.element = 'groups');
4. Delete group avatars.
delete from jos_social_avatars where `type` = 'group' and uid in (select m.uid from jos_social_migrators as m where m.component = 'com_community' and m.element = 'groups');
5. Delete group cover.
delete from jos_social_covers where `type` = 'group' and uid in (select m.uid from jos_social_migrators as m where m.component = 'com_community' and m.element = 'groups');
6. Delete group albums.
delete from jos_social_albums where `type` = 'group' and uid in (select m.uid from jos_social_migrators as m where m.component = 'com_community' and m.element = 'groups');
7. Delete group discussion.
delete from jos_social_discussions where `type` = 'group' and uid in (select m.uid from jos_social_migrators as m where m.component = 'com_community' and m.element = 'groups');
8. Delete group files.
delete from jos_social_files where `type` = 'group' and uid in (select m.uid from jos_social_migrators as m where m.component = 'com_community' and m.element = 'groups');
9. Delete group bulletin.
delete from jos_social_clusters_news where cluster_id in (select m.uid from jos_social_migrators as m where m.component = 'com_community' and m.element = 'groups');
10. Delete group data.
delete from jos_social_fields_data where `type` = 'group' and uid in (select m.uid from jos_social_migrators as m where m.component = 'com_community' and m.element = 'groups');
11. Delete group.
delete from jos_social_clusters where cluster_type = 'group' and id in (select m.uid from jos_social_migrators as m where m.component = 'com_community' and m.element = 'groups');
12. Delete group category's fields.
delete from jos_social_fields where step_id in (select id from jos_social_fields_steps where `type` = 'clusters' and uid in (select m.uid from jos_social_migrators as m where m.component = 'com_community' and m.element = 'groupcategory'));
13. Delete group category's steps.
delete from jos_social_fields_steps where `type` = 'clusters' and uid in (select m.uid from jos_social_migrators as m where m.component = 'com_community' and m.element = 'groupcategory');
14. Delete group category.
delete from jos_social_clusters_categories where id IN (select m.uid from jos_social_migrators as m where m.component = 'com_community' and m.element = 'groupcategory');
15. Delete group migration history.
delete from jos_social_migrators where component = 'com_community' and element like 'group%';
Once you've complete the execution of above sql statements, you can then re-run the JomSocial groups migrations from your EasySocial.
Hope this help and have a nice day!