Changes

[[Category:Admin]]

 

[[Category:Admin_en]]

[[Category:ExportsEn]]

[[Category:ExportsEn]]

{{TemplateDocUser}}

{{TemplateDocUser}}

= [[File:Outils.png]] Develop your own export script =

= [[File:Outils.png]] 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.

If there is no predefined dataset that matches your needes and you have program knowledge, you can also develop your own script.

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.

Any language can be used if this language can read a database.

So the only thing to know is which table contains data you want to export.

You just have to read the table of the entity you want to export and build a file, using the format of your choice, from any fields available in table.

To help you, the page [[:Category:Table SQL|Table SQL]] presents you the list of all Dolibarr tables.

The only thing to know is which table contains data you want to export.

To help you, the page [[:Category:Table SQL|Table SQL]] lists all the tables used in Dolibarr.

 

Note that versions above 2.6 allow "admin" users to see the SQL code that was used to build the export file content when using the Export module. This is shown at the moment of file generation.

 

Note that versions after 2.6 allow "admin" users to see the SQL code used to build export requests when using the module.

<youtube width="200" height="120">dc8wfS6VoZ0</youtube>