We have an old 'Customer Relationship Manager' - ResultsPlus. We have several thousand individuals in this database and want to populate Jomsocial with them.. Since we will want historical data in addition to new information from Events Booking, Membership Pro and Joomdonation - using their Jomsocial compatibility - we want to populate Jomsolcial with many, eventually most, of these people. We can produce the data in Excel, csv, an SQL relation or whatever may be useful. Is there and batch process to do such a load? I anticipatethat this also would populate the Joomla! JML_USERS We would hope to populate fields we have added to the Jomsocial standard but, if necessary, we could load later.

Thank you
John McCall

Hi,

If I understand correctly, you have a site and a base of clients who's data like, name, email, and some other custom fields and would like to move all those users to JomSocial. Well, such import is not possible out of the box, I mean there's no feature that would handle it. However, you could create JomSocial multiprofiles and all those fields to match the fields on original user data and have a developer (if you can't) import the data basically with a query right into the db.

That way you'd have all users moved to JomSocial. I'm not sure about the passwords, though. But that's something you should consult with the developer. I can recommend oDesk devs: jomsocial.com/jomsocial-developers

I hope that helps.

Thank you for the quick response. Another question: I have looked at the CUser documentation, $cuser->getinfo('FIELD_CODE') will be very useful. Is there any equivalent the other direction, perhaps a setinfo(id,'FIELD_CODE'). Sure would be a lot easier than coding all the SQL in PHP! Of course, i could write a function but CUser functionality would be nice.

On my question yesterday, I think a solution is a Joomla extension called userport that adds users to the jml_users. This will, I think, make the users known to Jomsocial and I can then update other fields (with setinfo ?? ;-} )

Thanks, John

Hi,

The setInfo things only for save the specific field code with specific value, for the detail of code you can look at components/com_community/libraries/user.php, look function public function setInfo($fieldCode, $value)