Import from PHPBB2

From e107 Wiki

Introduction

E107 includes a script allowing import from an existing PHPBB2 forum into a new E107 forum.

Concise walk through of migration:

please note, steps 1.3 - 1.4 - 1.5 - 2.2 - 2.3 - 2.4 are optional for keeping your emoticons successfully.

pre steps:

PHPBB forum and database prepping:

1.1. clear your phpbb database to less than 15 mb by using either forum pruning or manual deletion of posts. (100% vital as the script will timeout otherwise.)

1.2. Delete ALL custom plugins installed on the phbbb core, including calendar plugins.

1.3. go into your admin panel of phpbb and check your emoticons (admin panel

> general admin > smilies, take note of each picture and its reference code

e.g. :) = ": )"

<php img emotes>

1.4. Download all emoticons from your phpbb ftp area i.e. www.yourwebsite.com/forum/images/smiles/ and upload them to ftp.yourwebsite.com/e107_images/emotes/default/

1.5. If you want your users to be able to use their old avatars, simply download them from ftp.yourwebsite.com/phpbbforum/images/avatars. I then zipped them up and added them as a download on the e107 site.

1.6 Lock all forums on the phpbb site now, so that the users can't post.

_______________________________________________________________________________________________

E107 website/forum preparation:

2.1. in your admin panel on the e107 site, install and enable the forum using the "plugin manager".

2.2. in your admin panel, click "Emoticons", on this page, tick "Activate emoticons?" and click "update".

2.3. you will now see the standard e107 emoticons + the ones you have uploaded (1.4).

2.4. following on from 2.3 now click "edit / configure this pack". once in here update your phpbb emoticons, to use the same code as it did on the phpbb forum.*

2.5. delete all users except for userid 1 aka the admin account. **

  you can do this either by using the admin > users menu in e107
  or by editing your phpmyadmin database, table  e107_user

___NOTES_______________________________________________________________________________________

• note the e107 smilies do not support spaces in the name, for example ":oh

crap:" will mean that any time somebody enters "oh" or "crap" the :oh crap: smilie will appear. to fix this just remove the space. this will NOT update the old posts.

• • (it gets very messy if you don't)

_______________________________________________________________________________________________

running the migration script:

3.1. use firefox or i.e to browse to http://www.yourwebsite.com/e107_files/import/phpbb2.php.

3.2 add your admin details and run the script. if the script times out (over 2-3 mins) your phpbb database is too large, delete the forums and users again from e107, reduce the size of the phpbb database then trying again.

3.3 if all goes to plan you should get a status report, generally reporting it all as a success (except for polls of course)

_______________________________________________________________________________________________

Post Migration Cleanup:

User cleanup.

If userid#1 was in use on your phpbb database, you will notice that their posts have now been registered to your e107 admin account. to fix this, simply give the admin account a different user id now and give userid#1 to the original poster.

if you used "Groups or Group permissions" in phpbb, you will now notice that all these group members have been assigned slight admin status. You may want to clean this up.

Go to admin panel in e107 click users go through the list, removing admin status from each user its assigned to (took me 5 mins on 200+ users so it isn't that bad)

Forum Clean up:

go into your admin panel on e107, choose "forum" under the plugin menu, choose tools check the following boxes

<img forum-cleanup>

Click execute now

The main work is done!

Now go to the Forum plugin page, select Tools from the right hand side and tell it to recalculate posts and such for all the forums, and sub-forums and posts. Double-check forum mods to make sure the proper userclasses are set up as mods for the proper forums Head on over to the UserClasses page and doublecheck that the proper users are in the proper classes (Forum Mods, etc...)

Modifying the Import Behaviour

It is possible to modify the import behaviour - for example by translating or filtering out certain bbcodes. Some information on this is included in a file 'import_readme.txt' in the conversion directory.