Importing User Databases

14 years 2 months ago #581 by jojomd
New to joomla and community builder. Lots of possibilities with both software and I congratulate the developers.

I'd like to import flat file database of users. How's the best way to do it.

14 years 2 months ago #695 by airdee
You can do it this way:

In your PhpMyadmin, select your Mambo database and point your table to mos_users. On the SQl tab you can copy and paste your sql with the below pattern:

INSERT INTO `mos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES
(68, 'juan delacruz', 'juan', '', 'e10adc5949ba59abbe56e057f20f883e', '', 0, 0, 29, '2005-08-23 16:16:37', '2005-09-07 16:12:41', '', ''),
(69, 'pedro penduko', 'pedro', '', 'e10a6c3949ba59abbe56e057f20f883e', '', 0, 0, 18, '2005-09-25 18:13:10', '2005-09-25 18:13:38', '', '');

Ofcourse the above infos are jsut examples. Do not forget to backup your database first before doing anything.:)
14 years 2 months ago #696 by airdee
After succesful importing, you can then go to Components>>Community Builder>>Tools and select Synchronize Users It will then synch mos_users to mos_comprofiler
14 years 2 months ago #740 by jojomd
Salamat airdee :)

What do i do for the passwords? I actually have their actual unhashed passwords.
14 years 2 months ago #760 by trail
make it a php script and use the md5 alogarithm to create the hash .. i believe its a php standard function .. maybe even as simle as md5('normal pass') but do check for precise usage..

DJ Trail.
CB Co-Founder & Test-Lead.
Plugins: My Age , Starsign Matchmaking Horoscope , My Visitor , My Highscores , My ProfileID ,
My Components: Import & Invite Karma Casino (Use Test / Test)
My Modules: Many :)
14 years 2 months ago #763 by cyberspeed
Would the user import script in this thread work with CB?

you have to go down about three replies.
Moderators: beatnantkrileon
Time to create page: 0.434 seconds

Facebook Twitter LinkedIn