批量导入: Difference between revisions

Jump to navigation Jump to search

批量导入 (view source)

Revision as of 02:55, 27 July 2018

473 bytes removed ,  8 years ago
no edit summary
VisualWikitext
(Created page with "Category:Admin Category:ImportsEn {{TemplateDocDevEn}} Following a new installation of Dolibarr, the database is empty. It is a common requirement to import existing dat...")
 
No edit summary
Line 1: Line 1:
[[Category:Admin]]
[[Category:Admin]]
[[Category:ImportsEn]]
[[Category:ImportsEn]]
{{TemplateDocDevEn}}
{{Template开发手册}}


Following a new installation of Dolibarr, the database is empty. It is a common requirement to import existing data (suppliers, customers, products etc.) instead of entering the data manually.
在Dolibarr的新安装之后，数据库是空的。导入现有数据（供应商、客户、产品等）而不是手工输入数据是一种常见的要求。
There are several possible methods of importing data. The following chapters provide information about this.
Information about exporting data is described on the page [[Module Exports En|Module Exports]].


= [[File:Art.png]] Using the Dolibarr Import Module=
有几种可能的导入数据的方法。以下章节提供有关这方面的信息。
The recommended method for importing data is to use the Dolibarr [[Module Imports En|Module Imports]]. You will find a wizard that will guide you step by step in importing your data. You'll find more information on the page [[Module Imports En|Module Imports]].


For import scenarios not covered by the built-in module, the following alternatives are also possible.
有关导出数据的信息在页面[[Module Exports En|Module Exports]]中描述。


= [[File:OpenOffice.png]] Using OpenOffice =
= [[File:Art.png]] 使用 Dolibarr 导入模块=
You can use OpenOffice, which is able to insert the contents of a table into a database such as Mysql Dolibarr. Here is a tutorial on this method: [[Import data with OpenOffice]]
导入数据的推荐方法是使用Dolibarr[[Module Imports En|Module Imports]]。你会发现向导会引导你一步一步地导入你的数据。您将在页面上找到更多信息[[Module Imports En|Module Imports]]。


= [[File:Outils.png]] Developing your own import script =
对于内置模块不包含的导入场景，下列选项也是可能的。


== Import third parties and contacts ==
= [[File:OpenOffice.png]] 使用OpenOffice =
We must differentiate a third party from a physical contact (person).
可以使用OpenOffice，它能够将表的内容插入到Mysql Dolibarr等数据库中。这是一个关于这个方法的教程：[[Import data with OpenOffice]]
The third party information contains all the details pertaining to billing (whether companies, private individuals or associations).
Third party details are compulsory whereas physical contact details are optional.
Contacts are just a directory of physical persons/addresses related to the third party.
In the case of a third party that is a company, there may be several additional physical contacts.
In the case of an individual, there will be only one physical contact which would be identical to the third party.


The import of the third parties inserts rows in the table [[Table llx_societe]]. Ensure that the mandatory fields contain data.
= [[File:Outils.png]] 开发自己的导入脚本 =


* Name: Must contain the name of the company
== 进口第三方及联系人 ==
* Client: Must contain 1 if third party is a client, 2 if prospect, 0 otherwise.
我们必须区分第三方与实际联系人（人）。
* Supplier: Must contain 1 if its a supplier, 0 otherwise
第三方信息包含与计费有关的所有细节（无论是公司、个人或协会）。
第三方细节是强制性的，而实际联系人是可选的。
联系人只是与第三方有关的物理人/地址的目录。
在第三方是公司的情况下，可能有几个额外的物理联系人。
在第三方是个人的情况下，将只有一个物理联系人，将与第三方相同。


The import of physical contacts inserts rows in the table [[Table llx_socpeople]]. Ensure that the mandatory fields contain data.
第三方的导入在表中插入行[[Table llx_societe]]。确保强制字段包含数据。


* Name: Must contain the surname of the contact
* Name: 必须包含公司名
* Firstname: Must contain the first name of the contact
* Client: 必须包含 1为客户，2为准客户，0为其他
* fk_soc: Must contain the id of the third party from table [[Table llx_societe]].
* Supplier: 必须包含 1为供应商，0为其他
 
物理联系人的导入在表中插入行[[Table llx_socpeople]]。确保强制字段包含数据。
 
* Name: 必须包含联系人的姓氏
* Firstname: 必须包含联系人的名
* fk_soc: 必须从表中包含第三方的ID： [[Table llx_societe]].


== Import invoices ==
== Import invoices ==
To complete...
{{ToComplete}}


== Import products ==
== Import products ==
To complete...
{{ToComplete}}


== Put into practice ==
== Put into practice ==
Page [[Script development]] explains how to create your own Dolibarr script.
[[Script development]] 说明如何创建自己的Dolibarr脚本。


== Some tutorials / examples submitted by the community ==
== 社区提交的一些教程/范例 ==
Some scripts examples are available into Dolibarr snapshot distribution in directory '''/dev/examples'''.
一些脚本示例可在目录'''/dev/examples'''中提供到Dolibarr快照分发中。


Other examples are provided by contributors:
其他示例由贡献者提供：
* [[Importing customers automatically]]
* [[Importing customers automatically]]
* ...
* ...
R.ivnun
513

edits

Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/38991"

Navigation menu