Migrate Database from a MySQL Database PHP website to Dolibarr

Maintaining my Dolibarr
1

Hi All

ive got an order to migrate a whole local Database (MySql) php website (hosting service) to dolibarr.
they want to migrate from old program to dulibarr but they need all data as customer tables , services , prices and membership.
and i know nothing about dolibarr and never used the platform.

pleas guide me how its work and from where should i start?
is there anybody had a same experience and do you know very related article ?

Thank you!

2

Hi @Ahmadqz
There is no standard way, you can use whatever tool you are comfortable working with.
My understanding is that you are not familiar with the db to migrate either.
Anyway i would start with a test instance and manually create entries and then identify and check table records to match with original db.

3

I would do the transfer, get it to work, delete it all and transfer it again now that you know how to do it better.

Dolibarr has an API you could use for inserting data, but you could also import some CSV files.

1 Like
4

Thank you.
I willl see the topics.

5

The most effective method for migrating your data from other software or databases to Dolibarr typically involves the following steps:

  1. Export data from the original database into multiple CSV (Comma-Separated Values) files. These should include separate files for customers, suppliers, products/services, and other relevant categories.

  2. Manually add one sample item of each data type (e.g., one customer, one supplier, one product) to your new Dolibarr instance.

  3. Export CSV files for each data type (third parties, products, etc.) from Dolibarr. Note that you must first enable the Tools module in your Dolibarr settings.

  4. Manually transfer the data from the CSV files exported in step 1 (containing your existing customer, supplier, product, etc. data from your original system) to the corresponding CSV files exported in step 3. This is really the most heavy task of the migration process: you must put the correct information in the correct column!

  5. Finally, use the import function (available in the Tools module) to import these updated CSV files into Dolibarr.

Note: In Dolibarr, customers and suppliers are grouped together under the category of “third parties.”

1 Like
6

Grate
Many Thanks
Ill make it like that