Migrating from Invision Power Board
This is a 'How To' guide on importing users from an existing Invision Power Board database to your Drupal database. The following steps presume you are doing this through phpMyAdmin, though it may work with other methods.
Currently, the members will have to request new passwords, as the Invision passwords are hashed with a salt (more info here). Boris Mann and myself will be working on carrying the correct passwords over too, and I will update this once the work is finished.
Step One: Export Invision Tables
- Log in to your phpMyAdmin where your Invision database resides.
- In most cases just visit "example.com/cpanel", click 'MySQL' databases, and then the 'phpMyAdmin' link.
- Export 'ibf_members' and 'ibf_members_converge' tables (one at a time).
- To export, select your Invision database, then click the name of the table on the left. Up top, click the 'Export' tab, check the 'save as file' checkbox, and click "Go."
Step Two: Import Invision Tables into Drupal Database
- Select your Invision Database, and Import each table seperately.
- Once you are in the Drupal database, click the 'SQL' tab up top, click 'Browse', and then click the bottom-most "Go" button. Do this for each Invision table that you previously exported (two total).
Step Three: Moving the Data You Need To Drupal
- Run SQL statements to import the data.
- While in your Drupal database, click on the 'SQL' tab once again. Enter the following code, and click "Go" after each one:
INSERT INTO users (uid, name, mail, created) SELECT id, name, email, joined FROM ibf_members;
UPDATE `users` SET `status` = 1 WHERE `status` = 0;
UPDATE `users_roles` SET `rid` = 1 WHERE `rid` = 0;
1)Select your 'users' table by click it in the left sidebar.
2)Click the 'Browse' tab up top.
3)Click the 'UID' link in your database twice to sort that columb by decending order. Write down the highest number.
4)Select your 'sequences' table.
5)Click 'Browse'.
6)Click the little pencil icon next to 'users_uid' to edit it.
7)Update the number (bottom right text box in the "ID" row) to the number you wrote down. Click 'Go'.
Finished
Your users, their email, and joined date have been successfully imported, and your Drupal database has been updated. The users will now have to request a new password. Drupal will ask them for their username and email (the ones they entered in Invision), and it will send them a new password that they can use to login. They can then change that password.
As I stated earlier, we are working on converting the passwords as well so that will not be necessary, and once that is done, this will be updated.
Take care and have fun!
... and the posts?
This is all very well, but if I'm not copying the actual content, I might as well just set up a new site and tell everyone to register again...
How to convert IPB 2.3.6 to Drupal
First of all, I have to say I don't think there is a direct way. However, I managed to convert IPB v2.3.6 to phpBB v3.0.4, and then converted that to Drupal successfully.
Instructions
Especially if your forum is large, you NEED to do this locally unless you have your own dedicated server. I recommend EasyPHP to set up your local environment. I won't give instructions how to do that, you're on your own there :) (hint: if you run Skype, either exit it for the time being or disable it listening to port 80)
From Invision to phpBB
Install phpBB3 v3.0.4 locally. Don't delete the install folder.
Follow the conversion instructions at the phpBB forums, using these three files to convert with. You may need to read more in that thread to fix other problems, once again you're on your own with that... or seek help with the phpBB community.
Some tips
A few useful tips if you find your users and/or forum posts are not imported correctly into Drupal:
Open functions_ipb.php. Find this:
function phpbb_set_encoding($text, $grab_user_lang = true){
return iconv('cp1251','utf-8',$text);
}
Replace with:
function phpbb_set_encoding($text, $grab_user_lang = true)
{
global $lang_enc_array, $convert_row;
global $convert, $phpEx;
$encoding = 'ISO-8859-1';
return utf8_recode($text, $encoding);
}
If you still find your forum posts do not import correctly, go into phpMyAdmin, select your phpBB database and run the following queries:
Select table php_users and run query:
UPDATE phpbb_users SET user_type = 3 WHERE user_type = 1;Select table phpbb_posts and run query:
UPDATE phpbb_posts AS p, phpbb_topics AS t SET p.forum_id = t.forum_id WHERE p.topic_id = t.topic_id;From phpBB to Drupal
Finally, follow the instructions at the phpbb2drupal module to convert your converted phpBB forum to Drupal :) Passwords still won't be converted, but all users can request a new password at their first login.