|
|
|
Importing User Databases
|
|
Date: 2005/11/26 17:38
|
By: jojomd
|
Status: User
|
|
|
Karma: 0
|
|
Fresh Joomlapolitan
| Posts: 5 |   |
|
|
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!
|
|
The topic has been locked. |
|
 |
|
Re:Importing User Databases
|
|
Date: 2005/11/27 18:15
|
By: airdee
|
Status: User
|
|
|
Karma: -2
|
|
Fresh Joomlapolitan
| Posts: 8 | |
|
|
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.
|
|
|
The topic has been locked. |
|
|
|
|
Re:Importing User Databases
|
|
Date: 2005/11/27 18:20
|
By: airdee
|
Status: User
|
|
|
Karma: -2
|
|
Fresh Joomlapolitan
| Posts: 8 | |
|
|
|
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
|
|
|
The topic has been locked. |
|
|
|
|
Re:Importing User Databases
|
|
Date: 2005/11/28 03:55
|
By: jojomd
|
Status: User
|
|
|
Karma: 0
|
|
Fresh Joomlapolitan
| Posts: 5 | |
|
|
Salamat airdee
What do i do for the passwords? I actually have their actual unhashed passwords.
|
|
|
The topic has been locked. |
|
|
