Imports de masse - Migrer mes données dans 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 ExportsEn.
Using the Import module Dolibarr
This module is not yet available. It is being developed.
In the meantime, you must develop your own scripts to import as described in the following chapter
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: Importing data with 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 practive
Page Developpement script explains how to create your own Dolibarr script. An example of insertion of a product is provided.