WebERP to KwaMoja conversion


As has been said in a previous post, KwaMoja grew out of the webERP project. Over the years we have always attempted to bring any changes made in webERP over to KwaMoja. However there are a lot of improvements we have made in KwaMoja which were never taken by those in charge of the webERP project.

People have asked me about the procedure for moving from webERP to KwaMoja, so I have decided to create a script that performs this transition automatically. The project is hosted on GitHub and can be found here:
https://github.com/timschofield/webERP2KwaMoja

The script is written using the PHP command line interface – Yes I know, but it was just more convenient as I already had a lot of the code written and could just pull it from the KwaMoja repository.

This script is designed to convert a webERP database into a KwaMoja database. It performs other housework on your new KwaMoja instance to enable it to run with your webERP data. To run this script you will need to have both the webERP and the KwaMoja code installed on the same machine that you are running this script.

This script assumes that the database user and password in the config.php file in your webERP instance has permissions to CREATE and DROP databases. If this is not so, you should temporarily make it so. Please see the mysql documentation if you are unsure how to do this.

This script takes 3 parameters. The first is the name of the webERP to be converted. This database will not be altered, and the new database will have this name but will have a suffix of _1 attached to it. eg If your webERP database is called weberp then the converted database will be called weberp_1. WARNING – If a database already exists with this name then it will be deleted. The second parameter is the path to the webERP code. This can be an absolute path, or a path relative to the directory that the script is being run from. The third parameter is the path to the KwaMoja code. This can be an absolute path, or a path relative to the directory that the script is being run from. So running the script in the web root, with a webERP database named weberp the command would look something like:

ConvertwebERP-4.15.1ToKwaMoja.php weberp webERP/ KwaMoja/

WARNING – Please note. Every effort has been made to ensure this script runs safely. However the KwaMoja team accepts no responsibility for any data loss that might occur. It is your responsibility to ensure you have backed up all your data correctly.

The command takes about 20 minutes to run on my very old laptop, so should be quicker than that on most machines. Once it has run, just point your browser at the KwaMoja code, and you should see your webERP company listed in the company selection drop down box. Choose this, and login using your webERP login.

You should thoroughly check that everything is now working as you expect. Pay special attention to the System configuration settings as KwaMoja adds many settings that weren’t available in webERP. Also the modules users can see may have been changed, so you should just check that.

Published by KwaMoja

My name is Tim Schofield, I have worked as an accountant in the UK since the early 1980's. I have been interested in writing software since acquiring my first Sinclair Spectrum. A large amount of my professional career has been spent implementing ERP companies at a number of sites.

4 thoughts on “WebERP to KwaMoja conversion

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create your website at WordPress.com
Get started
%d bloggers like this: