Easy Profile - Joomla Extension

Hi,
thanks for your interesting and sorry for late reply, it's a weekend for us and our offices are closed.

We not have experience with EasySocial and do not provide any migration tool. But I think this is simple.

1. Can i migrate some profile data from EasySocial to EasyProfile ? I am interested in particular about the avatar images and optional some custom fileds, but avatar is really mandatory.

Easy Profile store all user information in table #__jsn_users, so in the most of cases you can copy values from EasySocial table to Easy Profile table.
about avatars:
- Install Easy Profile Free (if in future you upgrade to basic or pro you do not lose any data, so you can test also with free version)
- Go to Components->Easy Profile
- Click on button "Sync Users" - this create into table #__jsn_users a row for each users
- With some SQL query copy values from EasySocial table avatar column into Easy Profile user table avatar column (in our table the id column is id of Joomla user), here an example:

UPDATE #__jsn_users

SET avatar = (

  SELECT avatar* 

  FROM #__easysocial_users**

  WHERE user_id*** = #__jsn_users.id

)

* I don't know if column is called "avatar" in easysocial table
** I don't know if easysocial user table is called "__easysocial_users"
*** I don't know in which column easysocial store Joomla user id

Easy Profile store in table only path of avatar (and I think also EasySocial), so you does not need to move avatar images into another folder. This is useful because you can make all tests without break easysocial avatar.

2. What about our current users that registered and are using Facebook Login provided by EasySocial? The existing accounts registered this way (facebook login) will work flawless with your Facebook Login option within EasyProfile ?

Sorry but I do not know how to works Facebook registration with EasySocial, Easy Profile simply store a code into column "facebook_id" (the code is Facebook App scope user id), but I think EasySocial do the same, if it is so you can copy column like avatar

3. I noticed that you guys have a profile plugin for showing all the users articles (joomla articles) in his profile page, am i right ?

Yes, it is free, you can test it with Easy Profile Free

4. I assume we can customize the profile template using template overrides (joomla's standard) so in case of an update to not loose any customization, right ?

Yes, Easy Profile is compatible with Joomla Template Override System. You can test this with Free version.

I want migrate from ES too....
ES avatar table - #__sosial_avatars
and it has several columns with avatars - small medium large
and inside only file names not path - f2932c74c925bfc788dce895211f3f8b_small.png

I try your example

UPDATE j25_jsn_users

SET avatar = (

  SELECT medium 

  FROM #__social_avatars

  WHERE uid = #__jsn_users.id

);

but I got error - #1242 - Subquery returns more than 1 row

and path to ES avatars - /media/com_easysocial/avatars/users/**** - ****=uder id
we need migration tool -(

Hi,
seems that #__social_avatars have duplicates. So can try something like this:

UPDATE j25_jsn_users

SET avatar = (

  SELECT medium 

  FROM #__social_avatars

  WHERE uid = #__jsn_users.id

    LIMIT 1

);

NOTE: We not have experience with EasySocial, so mine are only suppositions

Thanks, filenames of avatars was copy to __jsn_users
but files? How I can copy them from folders and in which folder are avatar' files placed in your component?
need some script to copy each file from /media/com_easysocial/avatars/users/**** - ****=user id to your component images folder...

You can leave files in current folder, Easy Profile does not require that the files are stored in some specific folder. It only need that the path in the table is correct.

there is no path in the table
in __jsn_users column avatar - only filename

Hi,
Easy Profile store path of image file in DB, default folder or file name is not important, because it retrieve image from any file path.
Normally Easy Profile store avatars into folder images/profiler (in basic/pro you can customize this path).

Valid path for DB are for example:
images/profiler/avatar80437_ea14e758b8f4414777be5e0834130d85.png
or also
media/com_easysocial/avatars/users/image-file.png

Thanks a lot
Your help and Excel - good migrators -)
all avatars was migrated.