Importing users from MS Access database into Joomla 1.5

[pvh123]

I had posted this item

http://forum.joomla.org/index.php/topic,200895.msg944928.html#msg944928

in de wrong place I think.

Has anybody been confronted with this dilemma and hopefully found an answer for it?

[bascherz]

Hi Pieter,

It's a non-trivial sequence of operations. You cannot just import the user information into a single table. You need to update several related tables. My recommendation would be to find out (hopefully by a reply to this post) what the tables are and how they are related. Then, model those tables and relationships in Access and export the data from there as delimited records into text files you then import into your J! database using phpMyAdmin (or equivalent).

If I had time to locate it, I believe there was a post somewhere else in here about the relationships among these tables. I believe they are among the following (this is from a 1.0.x site of mine):

• jos_users
• jos_core_acl_aro
• jos_core_acl_aro_groups
• jos_core_acl_aro_sections
• jos_core_acl_groups_aro_map

Hope this helps.

Bruce

edit: Here is the link to the other forum post that might be of some help with understanding these tables.
http://forum.joomla.org/index.php/topic,213485.0.html

[pvh123]

Thanks, Bruce for your info. At least it get me started.

[Fennopolpot]

It is very easy to import users by using Joomla 1.5 Framework. Provided code uses CSV-file sent from form element named 'fileUpload'. It loops trough file line by line and creates new user from every line. Information have to be stored to CSV-file in next order: name, username, password, email. Gid=18 is basic registered usergroup. The code uses utf8_encode -function because I dont't know how to save data from Excel to CSV in UTF-8.
 
It is easy to create a component around the code. Just add one HTML-form upload. And remember that user email have to be unique!

Code: Select all

jimport('joomla.user.helper');
$file           = JRequest::getVar( 'fileUpload', '', 'files', 'array' );
$handle     = fopen($file['tmp_name'], "r");
$new_user = array();

while (($data = fgetcsv($handle, 1000, ";")) !== FALSE) {
       $new_user['name']         = utf8_encode($data[0]);
   $new_user['username'] = utf8_encode($data[1]);
   $new_user['password']  = utf8_encode($data[2]);
   $new_user['email']          = utf8_encode($data[3]);
   $new_user['gid']             = 18;                               //Registered-usergroup
   $new_user['password2'] = $new_user['password'];

   

   // Create a new JUser object
   $user = new JUser(0);
   $user->bind($new_user);
   $user->save();
}

[pvh123]

Thanks very much. I will use this as well.

[pvh123]

It is easy to create a component around the code. Just add one HTML-form upload. And remember that user email have to be unique!

@Fennonpolpot I have been working on to get a component and   add the html form, but clobberd up my database when installing my "component". Obviously either the xml file or the rest of it was wrong.
Any change you will be able to provide me with that?

[tjay]

I have had some luck using the odbc drivers for MySql you can link access directly to your web site data base
the password encrypting is where I have ran into trouble but I am sure there is a work around

Also Navicat works great for any database jobs

[webm3442]

I'm trying to use ODBC as well. Can link my tables, but cannot establish relationships as the field definitions don't match.
Maybe you can give me some hints how to proceed to ad the necessary data in acl_core_aro and some other related tables.
Password encrypting can be solved by using CBJuice to import your userlist. But as there is still no CBJuice for 1.5 it doesn't update the core_acl tables.

[Pentacle]

@Fennopolpot

Should we do a $user->check(); or something before saving the user?

[jciconsult]

CB Juice has been updated for 1.5