31,003
edits
Imports de masse - Migrer mes données dans Dolibarr: Difference between revisions
Jump to navigation
Jump to search
m
Imports de masse - Migrer mes données dans Dolibarr (view source)
Revision as of 11:15, 18 June 2009
, 17 years agono edit summary
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
[[Category:Imports]] | [[Category:Imports]] | ||
{{TemplateDocDev}} | {{TemplateDocDev}} | ||
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 | == 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: | * Client: Must contains 1 if third party is a client, 2 if prospect, 0 otherwise. | ||
* Fournisseur: | * Fournisseur: Must contains 1 if its a supplier, 0 otherwise | ||
L'import des contacts physiques consiste à insérer des lignes dans la table [[Table llx_socpeople]]. | L'import des contacts physiques consiste à insérer des lignes dans la table [[Table llx_socpeople]]. | ||