Mass Import of Users?

14 years 5 months ago #117327 by mjwillyone
Mass Import of Users? was created by mjwillyone
Dear Friends at Joomlapolis! ... I am new to community builder and am, therefore, wondering something. Is there a way to do a mass import of users (such as from a CSV file) into CB? I am wanting to push Access Database info into CB so that each of our employees can have a profile and have it initially populated with the information we have on each of them.

Also ... is there a way to export the data so I can bring it back into our local Access database ... such as with a CSV export from the CB user list?

Thanks so much!

Mike

Please Log in to join the conversation.

14 years 5 months ago #117405 by mediaguru
Replied by mediaguru on topic Re:Mass Import of Users?
You could us phpMyadmin and create a proper mysql script to execute in there. Yes it is possible.

You'd need to update the Joomla users table and the CB users table with your data and make sure both are synced. In other words user number X in jos_users is the same number X in the CB users table.

You could set up a test site first on a local server using LAMP or MAMP (mac) to try it and see if it works.

Make a backup of all tables first in case you mess it up!

Post edited by: mediaguru, at: 2009/11/22 20:03

CB/Joomla golf site: www.thegolfspace.com
Geek/joomla site: www.tkserver.com

Check out my Joomla/CB projects:

* LIKE thumbs up system for "liking" content items
* Karma - CB user rating system
* Golf Score Tracker
* Jitter - status update system. "What's on your mind?"
* CB Author Plug - Shows CB author link and avatar in content items. J1.5 compatible and very customizable!

Found on my web site or in the Joomlapolis Directory !

Please Log in to join the conversation.

14 years 5 months ago #117407 by Rapunzl
Replied by Rapunzl on topic Re:Mass Import of Users?
You can also try CB Juice .

Jamie (Rapunzl)
Community Builder Team Member

Before posting on forums: Read all CB Articles | Specially the FAQ | Help us help you
CB links: Subscribe to CB documentation | [url=http://www.joomlapolis.com/content/view/7363/37/
]Our templates[/url] | [url=http://www.joomlapolis.com/content/blogcategory/61/74/
]Paid Subscriptions[/url] | Get Hosting | Our Forge
Visit my CB Profile

My personal site Rapunzl's Reality always under reconstruction

Please Log in to join the conversation.

14 years 5 months ago #117597 by mjwillyone
Replied by mjwillyone on topic Re:Mass Import of Users?
Thank you so much, both of you, for your reply. I am glad that it can be done and that, quite possibly, I can find a plugin that will meet my needs.

I am also glad to see that GB has plugins to meet other needs!

Thanks again,
Mike

Please Log in to join the conversation.

14 years 5 months ago #118238 by dezzell
Replied by dezzell on topic Re:Mass Import of Users?
I just completed a project where I imported 2,500 + users from Access to Community Builder using a custom PHP script. Let me know if you still need help with this and I'll send you some information.

Thanks,
Dave

Please Log in to join the conversation.

14 years 5 months ago #118251 by Rapunzl
Replied by Rapunzl on topic Re:Mass Import of Users?
dezzell, is it a script that might help others, or is it customized to your setup?

Jamie (Rapunzl)
Community Builder Team Member

Before posting on forums: Read all CB Articles | Specially the FAQ | Help us help you
CB links: Subscribe to CB documentation | [url=http://www.joomlapolis.com/content/view/7363/37/
]Our templates[/url] | [url=http://www.joomlapolis.com/content/blogcategory/61/74/
]Paid Subscriptions[/url] | Get Hosting | Our Forge
Visit my CB Profile

My personal site Rapunzl's Reality always under reconstruction

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.215 seconds