https://www.icyphoenix.com/viewtopic.php?f=4&t=7147&p=48919#p48919
-----------------------------------
Mighty Gorgon
Sun 09 May, 2010 19:58

CONVERSION - Import Users From CSV File Or Other Software (phpBB 2, phpBB 3, WordPress, Joomla, vBulletin)
-----------------------------------
Hi all,
I have created a tool to import users into Icy Phoenix 1.3.

This tool allows you to import users from a CSV file or from other software like phpBB 2, phpBB 3, WordPress, Joomla, vBulletin.

Usage is very simple:
[list=1][*]Make sure you have Icy Phoenix installed.
[*]Download and decompress [b]ip_batch_users_import.zip[/b] into your hard disk.
[*]If you decide to import users from a CSV file then you need to fill the attached "demo" CSV file ([b]users_to_add.csv[/b]) with the users you would like to import, following the same schema and format:
[codeblock]"User 01","pwd01","user01@user01.com",1,"english","0.00","Y/m/d - H:i"
"User 02","pwd02","user02@user01.com",1,"english","0.00","Y/m/d - H:i"
"User 03","pwd03","user03@user01.com",1,"english","0.00","Y/m/d - H:i"[/codeblock]
[*]If you decide to import users from another software, then you first need to export your old users table (the one you would like to import) and [b]import it in the same DB where Icy Phoenix has been installed[/b]. For example if you are trying to import users from phpBB 3, then you need to export your [b]phpbb_users[/b] table and import it into your Icy Phoenix DB (there are several ways to do it, using phpMyAdmin is maybe the easiest one).
[*]If you are importing users from another table, you need to edit [b]users_add.php[/b] to reflect the name of the table where old users are stored: [b]	'source_table' => 'phpbb_users',[/b].
[*]Make sure you have correctly edited your CSV file or correctly imported the users table.
[*]Copy [b]users_add.php[/b] (and also [b]users_to_add.csv[/b] if you want to import from CSV file!) to your Icy Phoenix root and then launch it!
[*]Launch [b]users_add.php[/b] from your browser and then choose the right import method you would like to use.
[*]The script should complete the job automatically!
[*]Enjoy your new users![/list]

There are other advanced settings you may configure in the file, but you may not need them in most cases.

For software which uses a different password encryption from phpBB 2 and Icy Phoenix (next Icy Phoenix version will have a different password encryption!) a new password is generated and should be automatically sent to the users imported.

Should you need assistance with this procedure, please use the Icy Phoenix support section in the forum and please provide all necessary details to help you: Icy Phoenix version, software you are trying to import from, name of the tables, etc.


P.S.: since in Icy Phoenix some chars are not allowed in usernames, some usernames will be changed... also duplicated usernames and duplicated emails will not be imported!


