As the old website was built by ASP + MS Sql, but now it has been re-built by Joomla and MySql.  So I need to transfer the registered  users into new website.

I got users info table from the old database. The table was stored by excel,  so in my option I’ll import the users info into MySql database from the Excel sheet.There were 4 columns in the sheet, userID, userName, userEmail, Name.

Step 1: Study the structure of joomla users table: jos_users .

You’ll find others field like password, usertype…etc.

Step 2: Add columns corresponding to the fields in jos_users. The first line setted to fields name. Rename the sheets name to jos_users.

For the password field, you may create a new user in Joomla, set the password to ‘abcdefg’, then copy the pasword fields from MySql to all users password column.

Then import the excel to MySql. I use the tool of Excel 2 mySql Ver 1.0, I got it from http://www.excel2mysql.com/ . The tool need to unlock and it is easy to use.

Step 3: After imported excel, you need to find the new database which generate by the tool of Excel 2 mySql Ver 1.0.   Export all data into sql file.

After exported, please make sure there’s only data operation script and no any structure.  Just like this:

Step 4: Come to the destination database, and import the sql file which generated in Step 3.

Please backup the users data first, then do the step 4. Before import user data from excel to MySql, you may re-set the userID make sure them won’t same with any id of destation database jos_users.

Step 5: After step 4 completed.  You may found all users data have been imported in phpmyadmin. But if you com to the back-admin of Joomla, you’ll found the old users also. And the new imported users won’t be displayed.

But if you are careful, you’ll find the pages isn’t same with the count of old users.

Why the new imported users can’t be displayed?

To be continued……