I had 1206 members I needed to import into my site as members so I wrote a concatenation function in Excel to successfully import them. See the attached excel speadsheet for reference.
Here is the process:
1. Import your CSV file into Excel into the proper fields
2. Copy cell BH2 all the way down. DO NOT overwrite BH1.
3. I have it so the user name and password are generated automatically so I didn't have to worry about that. You can overwrite that if you want.
3. Copy the entire column (Excel column BH) and paste it into the PhpMyAdmin query. On the very last values statement, change the comma to a semicolon (;) for the Boonex database to dump all the information into the Profiles table.
The last two steps I had to take was to generate the salt for each user (a simple command) and then hash the password.
If anyone is interested in the Excel script, let me know and I'll e-mail it to you. If you have trouble, I can always import your stuff into the excel and just e-mail you what you need to paste into PHPMyAdmin
Cheers!
