Importing User Databases

13 years 10 months ago #3374 by omegix
jojomd wrote:

Found the Joomla! User Import ComponEnt (JUICE)

If i want to insert data into other fields created with CB, which tables should i mess around with?


I am interested in this as well. I have a database already implemented, and want to transfer the values into the table I created with CB.

I tried creating a new row in the CB table and filled it in, but Joomla did not recognize it as a new user.

Anyone know how to accomplish this goal?
13 years 10 months ago #3399 by trail
joomla needs to see the user first.. then you can synch that user by using backend cb synch tool.. it will then create the user in the cB table..

There is currently no methods of synching joomla to CB..

So first get the user in joomla.. ?

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 :)
13 years 10 months ago #3447 by omegix
trail wrote:

joomla needs to see the user first.. then you can synch that user by using backend cb synch tool.. it will then create the user in the cB table..

There is currently no methods of synching joomla to CB..

So first get the user in joomla.. ?



So I could import the users into joomla using their basic login and password information, sync CB to joomla, and then do a second import (script?) of the their other fields into the CB profiler?

That sounds like it could work.
13 years 8 months ago #8349 by bascherz
I, too, am migrating into Joomla a database of some 200+ users from (of all things) an Access database. I have already created an Access report that generates working SQL to INSERT users correctly into the jos_users table. But when I use CB to sync the users, nothing happens. What step(s) am I missing?

CB looks incredibly powerful. I am almost finished setting up my new HOA site. I don't know yet how it is going to work out for me, but CB solved some privacy issues that standard Joomla couldn't deal with. I don't want to make all these residents have to sign up to use the site since I already have everything I need to get them into the Joomla user table myself. My idea is to generate random passwords and then instruct them to pretend that they forgot their password. This will reset it and send them a new one. Well, that's the plan anyway.

Help, please. Need to launch this site this weekend and I thought this would be the easy part.

Thanks in advance.

Bruce
Vienna, VA
:ohmy:

______________________
Bruce S - Vienna, VA
13 years 8 months ago #8418 by ptkho
omegix wrote:

trail wrote:

joomla needs to see the user first.. then you can synch that user by using backend cb synch tool.. it will then create the user in the cB table..

There is currently no methods of synching joomla to CB..

So first get the user in joomla.. ?



So I could import the users into joomla using their basic login and password information, sync CB to joomla, and then do a second import (script?) of the their other fields into the CB profiler?

That sounds like it could work.


Thanks to this reply it worked for me to import 600+ users! First using the JUICE, importing username and passwords, then sync CB to joomla. Second import is not done via a script, but through phpMyAdmin. In the SQL-section of the table (com_profiler)there is a way to import your CSV-file. Take care your CSV-file has the right fields in the right order according to the fields you find in com_profiler table (you can make, delete and edit the fields in CB itself, the actual very first step), then upload the CSV-file. Check then the table by browsing it in phpMyAdmin. If everything is right, it's alright in CB too!

It took a while to figure it out, but once when you've done it it's quite logical to do! Also thanks a lot to the JUICE component for making importing the users so easy!
13 years 8 months ago #8419 by ptkho
Note: before doing this what is described before, I first followed this forum-thread carefully from the beginning. A lot of things are explained here too for helping importing users from a CSV-file.

Also forgot to tell to take first the table mos/jos_users and check if the id's of users are the same as in the mos/jos_comprofiler table. So 2 tables are important to check if it's synched: the users and comprofiler tables.
Check-sync is done by downloading the tables (through 'export' as a csv-file), editing it in your spreadsheet (copy-paste the data and right fields in the right order), and upload it like described in my previous post (in the tab 'SQL' on bottom-link 'Insert data from a textfile into table'). Check the upload-settings: in this case uploading the table worked only for me with load-method 'Data local' and look if you can replace existing data in your table. As long as your CSV-file you want to upload is complete and you're sure nothing is missing, it's recommended to replace the existing table when uploading it.
Make sure first you have a backup of the CSV-file!

Hope this might help some people here... Good luck!
Moderators: beatnantkrileon
Time to create page: 0.456 seconds
Facebook Twitter Google LinkedIn