Moving from another CMS

From e107 Wiki
Jump to: navigation, search

e107 Wiki: English | Русский | Deutsch | Français | Magyar | Português | Български | Česky | Nederlands | Ελληνικά | Italiano | Norske | Polska | Slovenščina | Español | Svenska | Translate: Wiki | Page


Current Release 1.0.4 | | Download | Changelog | Forum | Plugins | Themes | RSS Feed of Latest Changes | Atom Feed of Latest Changes

How to import data from another CMS
Main page > I : First Aid > II : Development > III : Administration > IV : How To's > V : Plugin Writing > VI : Theming & Shortcodes

English | Magyar This page is a stub. You can help e107 by expanding it.

Migration from another CMS

It is possible to import existing data from another CMS (providing it uses MySQL) into a fresh install of e107.

Some scripts are available; the level of imported data varying from system to system. You are advised to try them on a test system first.

In general, the scripts will empty your existing database.

It is also sometimes possible to transfer user information into E107 with MySQL queries - this should be possible with any source database which provides a login name and md5-encoded password.

Summary of import capabilities

Mambo/Joomla yesYesYesNoNoNoNo 
PHPNuke YesYesYesNoYesYesyes**

** - See notes below.

To run an Import Script

The "standard" scripts are in the subdirectory e107_files/import

To run a script, log into your e107 site, then go to the script page:


Where 'yoursite' is the full URL of your site, and scriptname is the name of the script you wish to run; for example:


Notes on specific CMS


There is a script available which can import most of the information. The latest version also imports bbcodes, including changing the format of certain codes to be e107 compatible.

By editing tables it is possible to selectively translate one bbcode into another, force lower case on BBCodes and other operations. BBCodes which have no direct equivalent within e107 can be deleted, or mapped to another code. Alternatively additional bbcodes can be created to provide support for these codes (note that bbcode handling changed between 0.7.5 and 0.7.6, and if not automatically installed, the plugin scanner can pick them up).

The script included with E107 version 0.7.6 or later should be used - earlier versions were incomplete.

Detailed Instructions Here


Status of included script unknown


Joomla is a derivative of Mambo, and appears to have the same database format. Thus the same import script should work for both.

The current script imports users only. Not confirmed as to whether the script works with latest editions of Mambo/Joomla

Migration ReadMe

PHPBB2 to E107 Conversion Routine

Issue dated: 13.06.2006

Any updates, bugfixes or comments please send pm to steved at

Conversion routines from other BBS

phpbb2.php - modified from earlier script, with ability to process and re-map bbcodes, plus more options.

Note: Only the underlying read/translate routine has been modified, plus some detail changes in the configuration table. The key routines which read and write the databases should be the same as those originally shipped.

Credits: Based on the script originally shipped with E107 (jalist) Modified to mostly work by aidee Enhanced by steved Reflects mods made by McFly in the "official" script between V1.4 and V1.5 Thanks to Rashan for a lot of testing and feedback.

                  • This is still to some extent a work in progress - please report any problems to steved by PM ***********


1. Create a fresh install of E107. (Not essential, but it will overwrite rather a lot!) 2. Copy the files into the e107_files/convert subdirectory.

To Run

  1. If there's anything in the e107 user table, you must delete ALL entries, EXCEPT user ID:1 - This is the admin login. (or whatever you named the #1 when you installed e107)
  2. Make sure the forum plugin is installed (don't define any categories etc)
  3. login to the e107 as admin (or whatever #1 is)
  4. browse to e107_files/import/new_phpbb2.php
  5. fill in the required info for login/password, etc.

db to import FROM is your phpbb2 database, with whatever prefix is set - often _phpbb_

  1. once the script runs sucessfully, return to the e107 admin, head on over to the Administrators page and set the proper people up with their admin access, delete unnessesary admins
  2. 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.
  3. double-check forum mods to make sure the proper userclasses are setup as mods for the proper forums
  4. Head on over to the UserClasses page and doublecheck that the proper users are in the proper classes (Forum Mods, etc...)

Known Issues

  1. Forum polls may not be transferred. At the current time there are various issues with this in the E107 core, and this may be the reason. So this has been put on hold until the core is definitely fixed.


BBCode conversion may not always appear to work completely, especially if they were originally not been entered correctly. And there may be bbcodes which are not supported in E107. In some cases it is possible to do a direct translation within the conversion routine (see later). Otherwise download the add_bbcodes plugin from, and create bbcodes to match the originals (its often possible to use an existing bbcode as a template).


File import routine (import_mapper.php)

The import is based on a processing routine whose behaviour is defined in an array. The rest of these notes deal with that routine. Using the tables in the accompanying file as an example, it should be possible to modify the behavior of the conversion, and adapt to other CMS.

Using the conversion routine

Read one line from your database; pass to:

function createQuery($convertArray, $dataArray, $table, $maptable default null)

where: $convertArray is an array defining the translations and lookups to be done $dataArray is an array of input data, keyed by source field name. $table is the table name $maptable if specified is used to translate bbcodes.

The function returns a line of text which is a mySQL 'INSERT' query.

$convertArray format

This is a 2-dimensional array which relates fields in the source and destination databases. Each row has a number of definition fields which relate to a single data item. The first three are mandatory. The keys must be as specified:

Field 1	"srcdata"	Source field name

Field 2	"e107"		Destination field name

Field 3	"type"		Type of destination field:
				INT	- Integer
				STRING	- Text/string of any sort
				STRTOTIME - time/date as text string (not yet supported)
Field 4	"value"		(Not always present - should only be if source field is null)
				Sets a value (sometimes from a function parameter). Overrides all other options.
Field 5 "default"	Sets default if the source field is undefined

Field 6	"sproc"		Various processing options (see below)

Processing Options

Comma separated string of processing options; options are invoked if present.

The following are applied to string fields:

usebb	Allows bbcode, and enables other bbcode processing options.
			If the $maptable parameter is non-null, translates bbcodes as well
phpbb	Causes numerics after colons within bbcodes to be stripped
bblower All bbcodes are converted to lower case. (Applied before other processing)
stripbb	Strips all bbcode in a string (i.e. anything between [])

The following are applied to integer fields: zeronull If the integer value is zero, writes a null string.

BBCode Mapping Table

A mapping table may be passed to the conversion routine, which translates bbcode between the two systems. The table is an array of key/data pairs, for example:

$mapdata = array("b" => "bold","u" => "ul");

The above translates the 'b' bbcode to 'bold', and the 'u' bbcode to 'ul'. It is also possible to delete a specific bbcode (while retaining the text between the start and end of the code) by setting the translated value to an empty string. The above method can also be used to translate bbcodes from upper to lower case. Parameters after the bbcode (identified as following an '=') are retained;

Base routines read one record at a time from the source database, and pass it to createQuery, which uses the above tables to generate an 'insert' line with the appropriate data.

See Also