Difference between revisions of "Module Exports En"
| Line 30: | Line 30: | ||
You just have to read the table of the entity you want to export and build a file, with format of your choice, from any fields available in table. | You just have to read the table of the entity you want to export and build a file, with format of your choice, from any fields available in table. | ||
So the only thing to know is which table contains data you want to export. | So the only thing to know is which table contains data you want to export. | ||
| − | To help you, page [[:Category:Table SQL]] presents you the list of all Dolibarr tables. | + | To help you, page [[:Category:Table SQL|Table SQL]] presents you the list of all Dolibarr tables. |
Note that versions after 2.6 allow "admin" users to see the SQL code used to build export requests when using the module. | Note that versions after 2.6 allow "admin" users to see the SQL code used to build export requests when using the module. | ||
Revision as of 13:32, 6 September 2010
| Exports | |
|---|---|
| Numero/ID of module | 240 |
| User doc. of module | This page |
| Developer doc. of module | This page |
Introduction
To export Dolibarr data, there is several solutions described here. This page describe solution using the export module. Solutions to make mass imports are described in the page Mass imports.
Installation
This module is included with the Dolibarr distribution, so there is no need to install it.
Configuration
To use this module, you must first enable it using an administrator account, via the menu option "Home - Setup - Modules".
Choose the tab where the module is listed. Then click on "Activate".
The module is now activated.
If a cog icon appears 
on module thumb or at end of the line of the module, click on it to access the setup page specific to the module.
Usage
- Go on menu Tools - Export and choose a predefined dataset.
- Then choose fields you wan in your output files, and in which order.
- Once data are selected, you can choose the format of the output file build by clicking on the "Build" button.
- After few seconds, a file is available for download.
Possible formats are CSV and TSV (Text files) or XLS (Native Excel files)
Develop your own export script
If there is no predefined dataset that match your need and have program knowledge, you can also develop your own script. Any language can be used if this language can read a database. You just have to read the table of the entity you want to export and build a file, with format of your choice, from any fields available in table. So the only thing to know is which table contains data you want to export. To help you, page Table SQL presents you the list of all Dolibarr tables.
Note that versions after 2.6 allow "admin" users to see the SQL code used to build export requests when using the module.