Difference between revisions of "Module Exports En"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
m
(Add Chinese)
Tag: 2017 source edit
 
(32 intermediate revisions by 6 users not shown)
Line 1: Line 1:
−
[[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}}
−
{{ToTranslate}}
+
{{TemplateModEN}}
 +
{{BasculeDevUserEn|
 +
name=Exports|
 +
num=240|
 +
devdoc=This page|
 +
userdoc=This page}}
 +
 
 +
= Introduction =
 +
To export Dolibarr data, use the Export module.
 +
Bulk imports are described in the page [[Mass imports]].
 +
 
 +
= Installation =
 +
{{NoInstallModuleEn}}
 +
 
 +
= Configuration =
 +
{{ActivationModuleEn}}
 +
 
 +
= Usage =
 +
# Go to Menu-> Tools -> New 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.
 +
# Add any filters you may wish to place on the values of those fields.
 +
# 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.
 +
# 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.
 +
After few seconds, a link to the file is shown for download.
  
−
Pour exporter les données de Dolibarr, il existe plusieurs méthode décrites ci-dessous.
+
= [[File:Outils.png]] Develop your own export script =
−
Les méthodes d'imports dont décrites sur la page [[Mass imports]]
+
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.
 +
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, the page [[:Category:Table SQL|Table SQL]] lists all the tables used in Dolibarr.
  
−
= Utiliser le module Export de 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.
−
La fonction Exports permet de réaliser des exports personnalisés des données via un assistant qui évite d'avoir des connaissances techniques de Dolibarr.
 
−
# La première étape est de choisir un des lots de données prédéfinis
 
−
# Ensuite de choisir les champs que vous voulez dans votre fichier résultat, et dans quel ordre.
 
−
# Une fois les données sélectionnées, il est possible de choisir le format du fichier export généré puis de cliquer sur le bouton Générer.
 
−
# Après quelques instants, un fichier est alors disponible pour téléchargement.
 
−
Les formats existants sont csv (Fichier texte) ou xls (Format Excel natif)
 
  
 +
=Related videos=
 +
Export:
 +
(vocal in french but subtitles are available and review in this language)
  
−
= Développer son propre script d'export =
+
<youtube width="200" height="120">dc8wfS6VoZ0</youtube>
−
N'importe quel langage peut faire l'affaire du moment que vous pouvez lire la base de donnée.
 
−
Il vous suffit de lire la table de l'entité qui vous intéresse et de fabriquer un fichier export au format qu'il vous plaira
 
−
à partir des données de cette table.
 
−
Le seul prérequis est donc de connaitre la table qui contient les données qui vous intéressent.
 
−
Pour vous y aider, la page [[Liste des tables]] vous présente la liste des tables de Dolibarr
 

Latest revision as of 02:47, 11 September 2023

Return to user
documentation index
File Doc user.png

Return to
list of modules index
Art.png

Exports
Numero/ID of module 240
User doc. of module This page
Developer doc. of module This page

Introduction

To export Dolibarr data, use the Export module. Bulk 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 Cog circle.svg 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

  1. Go to Menu-> Tools -> New Export and choose a predefined dataset.
  2. Choose a predefined (by you) export profile or manually choose the fields you want to include in the export file.
  3. Add any filters you may wish to place on the values of those fields.
  4. 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.
  5. 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.

After few seconds, a link to the file is shown for download.

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. 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, the page 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)

Retrieved from "https://wiki.dolibarr.org/index.php?title=Module_Exports_En&oldid=57778"