Converting user info from EasyProfile to Community Builder

Hello KyleSorry for the delay, just a bit crazy.Find attached the structure. Trust this is what you are looking for.

Ok, checking their install SQL file and looks like the users table structure is as follows.

_jsn_users
Fields configuration is stored in _jsn_fields and field valuess themselves I think might be stored in Joomla's _user_profiles table as it looks like they're just extending the core users class. Check the _user_profiles table and see if their profile data for those EasyProfile fields are there. Otherwise I don't have any idea where they're stored. You'll be able to migrate their _jsn_users data easy enough at least.

They store it in jsn_users. All the additional fields that I created is stored there.

That is what they are battling with since Joomla's extra fields can do most of this now, although not all. Like groups etc seems not to be possible in Extra fields.

It is just the normal Joomla 3 stuff in the Joomla User table.

The other apps use the same table jsn_users to sync user that is created through say Events Booking, Hika Shop or Membership Pro. Even linking the Joomla Easy profile users through Joomdle for Moodle is possible by a plugin but so is the Joomdle Plugin for CB.

Thanks

So those fields are stored in the `params` column of _jsn_users or as new columns added to the table? CB doesn't use Joomla user field storage either since we've existed before Joomla was even called Joomla we have our own storage, which in CB 3.x should be moving to Joomla user fields.

Depending on how the fields are stored in _jsn_users it could be really complicated, because if they're stored in `params` it's going to be difficult to extract them out exclusively with SQL.