Hi Kerry,

Regarding your inquiry, unfortunately, it is not possible currently.

Thanks for understanding

I may directly put in MySQL? how about the picture?

I think you have to understand which table will involved the way a new member come to your site and register it.

It actually not only involved 1 table from your database, if you would like to import user info + photo, this following table will be involved, for example :

#__social_avatars - stored user avatar
#__social_covers - stored user cover
#__social_fields_data - stored user info
#__social_files - stored those attached file from user profile
#__social_photos - user photo data
#__social_photos_meta - user photo meta data
#__social_profiles - user profile
#__social_profiles_maps - user profile mapper
#__social_users - Easysocial user table
#__users - need to associated with Joomla user table
#__user_usergroup_map - need to associated with Joomla user group

If you would like to manually add the data into your database, you have to understand how the Easysocial table structure, because those different table also associated with the id.

yes, table is one thing !! I wondering the picture !! you will upload an crop it now !!! if import !! where those crop function ?

Regarding the Crop function is only available when you upload your photo through Easysocial.

We do not have standalone importer allow user to import their user photo data in Easysocial.

Thanks !! I try first !!

Do you think you can help for paid service if I cannot

Would you like to explain more the structure I can import the user + pic ! I have asked to do the import !! if you can tell more !
I can tell them more !!

I am really sorry but we are actually quite tied up with our own internal development and we wouldn't be able to assist you with these customisation right now

Perhaps you can take a look of my attached screenshot below and see how the Easysocial upload user avatar/cover photo workflow and the table structure the way we store in database.

Thanks for Help!! I can imagine how the profile put in the table!!!! but for the path of the image and the name !! is that I can omit the random file name ?

I see that my data, the picture have more than one , is that easysocial only got ONE profile picture?

You're welcome.

It would be best if you can use back the same image file name as what you stored in database.

Really Thanks your Help !!
I see cover and avatar also will store in social_photo

how to know what photo is cover / avatar? in social_photo table

In field_data Table :
I guess id in unique key , uid is user id
field_id in field_data table? what that ?
datakey ? some got name,last middle , some blank? should have ?

In social_users Table:
social_params < this should store the data, so long. What is the most simple value I need to enter for a profile ?

Can a photo without the any value in social_photo_meta?

I see cover and avatar also will store in social_photo

how to know what photo is cover / avatar? in social_photo table

It based on the #__social_avatar and #__social_cover `photo_id` columns.
For example : if the #__social_avatar photo id is 4, mean it will associated with the #__social_photo table id.

In field_data Table :
I guess id in unique key , uid is user id
field_id in field_data table? what that ?
datakey ? some got name,last middle , some blank? should have ?

In social_users Table:
social_params < this should store the data, so long. What is the most simple value I need to enter for a profile ?

when the user save their profile, it will store those custom field user data in this table #__social_fields_data , let me explain the table structure :
1. id - it will auto increment the id and this is primary key
2. field_id - is based on your custom field id which under this table #__social_fields
3. uid - if that is user custom field, this uid is belong to his user id , if that is group/event/page, it will store those group/event/page id
4. type - if that is user custom field data, it will store it as `user`
5. datakey - The reason why those custom field data got the datakey is because 1 custom field it actually contain a few data like what you mentioned in earlier (name, last, middle, first), this one you have to try save one of the existing site user profile, so it will store again for those data in this table.
To simply check the user data from this table, you have use following sql query to check :

// Remember replace #__ to your current table prefix

// uid is your user id

select * from #__social_fields_data where `type` = 'user' and `uid` = 11;

6. data - this column is store what user enter the data from the custom field
8. raw - this column is store what user enter the data from the custom field

Can a photo without the any value in social_photo_meta?

Hm, it required to have those `path` data, if not it will not populate the image on the page, you can refer on my attached screenshot below.

thanks

i will study it and passed to them to try to do !

You're welcome.

after user imported !! the site is running !! hope not problem later

Great !

Dear ~~~~ should be final help and can be use! Understand you patient to help me !

I know import the photo a quite hard ! so I want to import and user using SQL ! and upload photo manually !

Would you like to provide a sample of the SQL (like import one user involve table and field) that ONLY import basic user info and user base on the attachement?

I ONLY need Email, Name, Username, Gender!

I worry I guess which table and what field will be wrong!!

Kerry

Please help

and password!!

but I dont know what password should put in !

I found that I can use md5 in DB
12341234
is ed2b1f468c5f915f3f1cf75d7068baae

Yes, it would be great if provide a sample of SQL ONLY import user !!!! NO photo !

I am really sorry but unfortunately we cannot accommodate your request currently as it is beyond our support scope's policy as outlined in http://stackideas.com/support

This is what my suggestion :
1. Try find a way to import your user into joomla
2. Once Joomla user table already have this user data, then you can update again your Easysocial to latest version, it will sync your Joomla user to Easysocial during the updating.
3. Once you have done this, you can able to add the user gender and photo from their profile.

Regarding the password, Joomla will stored those password value as encrypted value, so after you imported those user into your site, you have to manually save the password for those imported user account from backend.

OK!!

I can try !

So I add user to joomla !! and update easysocial will have user , right ?

Yes, that is correct, but you have to update your Easysocial to latest version again, because it need to sync those existing Joomla user which not sync with Easysocial during the installation.

Can I update even already latest version ? update and update again?
I have add one test user , I want to test sync first

Yes, you can perform an update to latest version with multiple times.

Yes I have manually import the User in joomla !!
but still not update !!!

if did not update, the joomla user will not be able to login ?

Try check this table #__social_users whether already exist those new add user account id?

By right, it should automatically sync the user id in Easysocial during the installation.

updated !! seem those user ok now !!! can login as well

what update will change my site !! ??? I see profile field still have my custom field !

what update will change my site !! ??? I see profile field still have my custom field !

I don't understand what you mean those profile field still have your custom field? Is it can provide us some screenshot regarding this?

yes i got 294 user now

i mean custom field !! if i update , will not change all setting ?

Yes, when you update latest version of Easysocial again, it will not affect with your existing setting.

yes, overwrite something

yes

fixed

May i know which file you customised?

Because if didn't modify the Easysocial core file, it will actually not affect anything included Easyblog image wall module.

I need careful record what change !!! it ok now !!!

one final question !! now I need to admin approve the user !! can I make user approve themselve in email ?

Yes, you can change this setting from your backend > Easysocial > profile type > general > registration type - set to 'Require user activation '

By the way, I would suggest you start a new thread with your new question so that will easier for us to manage with your current issue.

I found that if I import from joomla !!!! it have no setting for me to edit !!

That is most likely because the user doesn't have any profile assigned to it yet. You need to assign them to a profile type on the site.