Difference between revisions of "导出模块"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
m (Adding interlang links (links to translated versions of this page in other languages) triggered by origin English page "Module_Exports_En" update.)
Line 17: Line 17:
 
userdoc=本页}}
 
userdoc=本页}}
  
= 简介 =
+
=简介=
To export Dolibarr data, use the Export module.
+
本模块用于导出 Dolibarr 数据。从 Dolibarr 导出数据还有其它方法,如下所述。
Bulk imports are described in the page [[Mass imports]].
 
  
= 安装 =
+
批量导入请参见页面 [[批量导入]] 。
 +
 
 +
=安装=
 
{{NoInstallModuleZh}}
 
{{NoInstallModuleZh}}
  
= 配置 =
+
=配置=
 
{{ActivationModuleZh}}
 
{{ActivationModuleZh}}
  
= 使用方法 =
+
=使用方法=
# 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.
+
#从下拉列表中选择导出文件的格式。可能的格式有 CSV/TSV(文本文件)或 XLS 2007/95(原生Excel文件)。单击“生成”。
 +
 
 +
几秒钟后,将显示一个指向该文件的链接以供下载。
  
= [[File:Outils.png]] Develop your own export script =
+
=[[File:Outils.png]] 开发自己的导出脚本=
 
If there is no predefined dataset that matches your needes and you have program knowledge, you can also develop your own 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.

Revision as of 03:04, 11 September 2023

导出
模块ID 240
用户手册 本页
开发文档 本页

简介

本模块用于导出 Dolibarr 数据。从 Dolibarr 导出数据还有其它方法,如下所述。

批量导入请参见页面 批量导入

安装

该模块包含在 Dolibarr 发行版中,因此无需安装。

配置

要使用此模块,必须首先使用管理员帐户通过菜单选项 "主页 - 设置 - 模块"启用它:

选择列出模块的选项卡。然后点击 "激活"。。

模块现在已激活。

如果在该模块的行尾出现一个齿轮图标Cog.png,则单击它以访问特定于模块的设置页面。

使用方法

  1. 前往菜单 “ 工具 -> 导出助手 -> 新建导出 ”,然后选择一个预定义的数据集。
  2. 选择由您预定义的导出配置文件或手动选择要包含在导出文件中的字段。
  3. 添加一个您希望放置在这些字段值上的任何过滤值。
  4. 更改导出文件中字段/列的位置顺序。您可以将所做的选择保存为导出配置文件/模板以备将来使用。
  5. 从下拉列表中选择导出文件的格式。可能的格式有 CSV/TSV(文本文件)或 XLS 2007/95(原生Excel文件)。单击“生成”。

几秒钟后,将显示一个指向该文件的链接以供下载。

Outils.png 开发自己的导出脚本

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.

相关视频

导出: (法语配音,但字幕可用,并用法语审查)