Hi TKABE,

I'm really sorry that delayed of this reply,

May i know what do you mean "Just the user accounts and profile data"?
Is it come from your previous site Joomla user profile data or Easysocial profile data? Please advise.

As mentioned the data resides in a SQL format. It is not in a name brand CMS system. Let me try to ask the question a different way...if I have data in SQL format can I simply import the data [SELECT FROM "old tables' INSERT TO "easysocial tables] into the EasySocial MySQL tables directly by adding user data (profile information) or will this create a problem with creating new user records in easysocial. Once these user records have been added I could manually use the easysocial group, user type and other batch functions to assign users to groups and user roles etc.

Do you have any documentation discussing the process of importing new user records from SQL?

Hi TKabe,

I am sorry for the delay of this reply.

If i understand correctly, your existing user data ( in sql format) is taken from another CMS system and you would like to migrate your existing users into EasySocial. If that is the case, you will first need to migrate your users into Joomla ( com_users ) as EasySocial still rely on Joomla users.

Next, your user data from your existing system. If your user data simply contain the username, fullname and email address, then importing your user data into Joomla already sufficient and your users can already login to EasySocial. However, if your existing system contain custom fields, then you will need to manually insert these data into EasySocial. This will be tricky because you will need to map properly the ES profile, ES custom fields and ES custom fields data for each users. Below are the tables involved for migration user custom fields data.


# for user’s profile
# note, custom fields in EasySocial are tied to user profile type.

jos_social_profiles
jos_social_profiles_maps ( this table store which users are associated to which profile type )

# each user profile has one or more steps
# and custom fields are tied to step.

jos_social_fields_steps
jos_social_fields
jos_social_fields_options ( this table stored the options for fields such as dropdown, radio and etc that has the multiple selection )
jos_social_fields_data ( this is the table that stored the actual user custom field data )

Hope this help and have a nice day!

Does stackideas provide any custom services (for a fee) to assist with the process you describe to expedite my project? If it is more appropriate to continue this discussion outside the forum, please use my email address on file or see site details for my contact info.

Hey there,

Yep, you can always contact us at https://crm.stackideas.com to request for a quote

The CMS.stackideas.com says post on forum as I did. Do you have a private forum or direct email for me to use for this quote request?

Todd

Hi there,

I'm Natasha from Stack Ideas' Marketing team. Kindly drop us an email at sales@stackideas.com for further assistance on your request