714
edits
Changes
Add Chinese
Line 1:
Line 1:
−
+Solutions to make mass imports are described in the page [[Mass imports]].+The Exports module allows yous to make personalize exports of data using an assistant. You should be able to export data with no technical knowledges.+So the only thing to know is which table contains data you want to export.+
+
+
+
[[Category:Admin]]
+<!-- BEGIN origin interlang links -->
+<!-- You can edit this section but do NOT remove these comments
+ Links below will be automatically replicated on translated pages by PolyglotBot -->
+[[fr:Module_Exports]]
+[[es:Módulo_Exportaciones]]
+[[zh:导出模块]]
+<!-- END interlang links -->
+[[Category:Admin_en]]
[[Category:ExportsEn]]
[[Category:ExportsEn]]
{{TemplateDocUser}}
{{TemplateDocUser}}
+{{TemplateModEN}}
+{{BasculeDevUserEn|
+name=Exports|
+num=240|
+devdoc=This page|
+userdoc=This page}}
= Introduction =
= Introduction =
−To export Dolibarr data, there is several solutions described here. This page describe solution of export module.
+To export Dolibarr data, use the Export module.
−Bulk imports are described in the page [[Mass imports]].
= Installation =
= Installation =
Line 13:
Line 27:
{{ActivationModuleEn}}
{{ActivationModuleEn}}
−= Utilisation =
+= Usage =
−# Go to Menu-> Tools -> New Export and choose a predefined dataset.
−# Go on menu Tools - Export and choose a predefined dataset.
+# Choose a predefined (by you) export profile or manually choose the fields you want to include in the export file.
−# Then choose fields you wan in your output files, and in which order.
+# Add any filters you may wish to place on the values of those fields.
−# Once data are selected, you can choose the format of the output file build by clicking on the "Build" button.
+# Change the position/column of the fields in the export file. You may save the selections you have made as an export profile/template for future use.
−# After few seconds, a file is available for download.
+# Choose a format for the export file from the dropdown list. Possible formats are CSV / TSV (Text files) or XLS 2007 / 95 (native Excel files). Click on Generate.
−Possible formats are CSV and TSV (Text files) or XLS (Native Excel files)
+After few seconds, a link to the file is shown for download.
= [[File:Outils.png]] Develop your own export script =
= [[File:Outils.png]] Develop your own export script =
+If there is no predefined dataset that matches your needes and you have program knowledge, you can also develop your own script.
Any language can be used if this language can read a database.
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.
+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.
−The only thing to know is which table contains data you want to export.
−To help you, page [[List of tables]] presents you the list of all Dolibarr tables.
+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.
+=Related videos=
+Export:
+(vocal in french but subtitles are available and review in this language)
+<youtube width="200" height="120">dc8wfS6VoZ0</youtube>