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.

Thanks!

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', 'juan@email.com', 'e10adc5949ba59abbe56e057f20f883e', '', 0, 0, 29, '2005-08-23 16:16:37', '2005-09-07 16:12:41', '', ''),
(69, 'pedro penduko', 'pedro', 'pedro@email.com', '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.

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

Salamat airdee

What do i do for the passwords? I actually have their actual unhashed passwords.

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 www.php.net/md5 for precise usage..

Would the user import script in this thread work with CB?

forum.mamboserver.com/showthread.php?t=17358&highlight=user+import

you have to go down about three replies.