31,029
edits
Mass imports - Migrate my Data To Dolibarr: Difference between revisions
Jump to navigation
Jump to search
m
Mass imports - Migrate my Data To Dolibarr (view source)
Revision as of 11:20, 18 June 2009
, 17 years agono edit summary
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
[[Category:ImportsEn]] | [[Category:ImportsEn]] | ||
{{TemplateDocDevEn}} | {{TemplateDocDevEn}} | ||
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 | |||
* Name: | * fk_soc: Must contains id of third party in table [[Table llx_societe]]. | ||
* Firstname: | |||
* fk_soc: | |||
== Import | == Import invoices == | ||
To complete... | |||
== Import | == 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. | |||
== | == Some tutorials / examples submitted by the community == | ||
[[ | [[Importing customers automatically]] | ||