Hi

I have an excel spreadhseet (and comma deliminated text file mirroring it) that contains user data (several hundred accounts) from a previous web site with a format like this :



I want to automate the importing of this data in my new XOOPS (2.0.13) site (obviosuly I'll remove the values that are not needed for XOOPS registration) so that they retain the usernames and passwords and to avoid me having to manually re-input them all.

I'm trying to find a script or process to do this. Having scouled the net, I have found many references to SQL queries like this :



But I'm really not comfortable with what I am supposed to be doing. I have access to phpMyAdmin, but just want to know what values I need to replace and with what? Can anyone quickly write me some SQL that would import the values into my XOOPS site? I'd really REALLY appreciate it.

Thanks

Ted

Try doing an export of your current names to an sql text file.

Use that as your template when adding your new names.

In phpmyadmin... simply input the new sql and you should be fine. If it is wrong, sql will tell you.

You may wanna have a look to this thread

There is a mass user import script from csv file, at the basics it imports 4 fields into users table (real namen pseudo, password (you write normal, it crypts md5) and email adress.

If you wanna add more have a look to the script code, it's quite easy to adapt.

don't forget to put the right variables into database connection at the top of the script file.

All the best.

Both of these posts are very helpful...thanks. However, JDSeymour has kindly offered to try and write a script for me via PM. I have however pointed out your replies to try and make life easier for him. I will have a look myself at these scripts tonight when I get home.

Thanks

Ted