Mass imports - Migrate my Data To Dolibarr
Following a new installation of Dolibarr, the bases are empty. Sometimes you want to start with data imported from another system. There are several possible methods. The following chapters present some information for this. Information on the export are described on the page Module Exports.
Using the Import module Dolibarr
The Module Imports is available with Dolibarr 2.7 and more.
For all situations not covered by this generic module, following solutions also works completely.
Using OpenOffice
You can use OpenOffice which is able to inject the contents of a table in the database such as Mysql Dolibarr. Here is a tutorial on this method: Import data with OpenOffice (available in French Importer des données avec OpenOffice)
Developing its own import script
Import third parties and contacts
We must distinguish the third party from the physical contact. In the third party we will have all entities subject to billing (both companies, as private people or association). Third parties are required. The physical contacts are optional. Contacts are just a directory of physical persons related to a third party. In the case of a third party that is a company, there may be several physical contacts. In the case of an individual, physical contact will be unique and identical to the third party (or even physical contact will not be filled).
The import of the third is to insert rows in the table Table llx_societe. Ensure that the mandatory fields are filled.
- Name: Must contains the name of the company
- Client: Must contains 1 if third party is a client, 2 if prospect, 0 otherwise.
- Fournisseur: Must contains 1 if its a supplier, 0 otherwise
Import of physical contact is to insert rows in the table Table llx_socpeople. Ensure that the mandatory fields are filled.
- Name: Must contains the name of the people
- Firstname: Must contains the first name of the people
- fk_soc: Must contains id of third party in table Table llx_societe.
Import invoices
To complete...
Import products
To complete...
Put into practice
Page Script development explains how to create your own Dolibarr script.