導出模塊

返回
用戶手冊

返回
標準模塊列表

導出
模塊ID	240
用戶手冊	本頁
開發文檔	本頁

簡介

To export Dolibarr data, use the Export module. Bulk imports are described in the page Mass imports.

安裝

該模塊包含在 Dolibarr 發行版中，因此無需安裝。

配置

要使用此模塊，必須首先使用管理員帳戶通過菜單選項 "主頁 - 設置 - 模塊"啟用它：

選擇列出模塊的選項卡。然後點擊 "激活"。。

模塊現在已激活。

如果在該模塊的行尾出現一個齒輪圖標，則單擊它以訪問特定於模塊的設置頁面。

使用方法

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.

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.

相關視頻

導出： （法語配音，但字幕可用，並用法語審查）