(Tạo trang mới với nội dung “For example, to reference the country of a contact, Kiu ERP proposes you 3 different fields to import: * Country: the name or code of the country * Countr…”)
According to your need, you should use one of these 3 ways to reference records in relations. Here is when you should use one or the other, according to your need:
According to your need, you should use one of these 3 ways to reference records in relations. Here is when you should use one or the other, according to your need:
−
* • Use Country: This is the easiest way when your data come from CSV files that have been created manually.
+
* Use Country: This is the easiest way when your data come from CSV files that have been created manually.
−
* • Use Country/Database ID: You should rarely use this notation. It's mostly used by developers as it's main advantage is to never have conflicts (you may have several records with the same name, but they always have a unique Database ID)
+
* Use Country/Database ID: You should rarely use this notation. It's mostly used by developers as it's main advantage is to never have conflicts (you may have several records with the same name, but they always have a unique Database ID)
−
* • Use Country/External ID: Use External ID when you import data from a third party application.
+
* Use Country/External ID: Use External ID when you import data from a third party application.
When you use External IDs, you can import CSV files with the "External ID" column to define the External ID of each record you import. Then, you will be able to make a reference to that record with columns like "Field/External ID". The following two CSV files give you an example for Products and their Categories.
When you use External IDs, you can import CSV files with the "External ID" column to define the External ID of each record you import. Then, you will be able to make a reference to that record with columns like "Field/External ID". The following two CSV files give you an example for Products and their Categories.
Bản hiện tại lúc 10:54, ngày 27 tháng 12 năm 2017
For example, to reference the country of a contact, Kiu ERP proposes you 3 different fields to import:
Country: the name or code of the country
Country/Database ID: the unique Kiu ERP ID for a record, defined by the ID postgresql column
Country/External ID: the ID of this record referenced in another application (or the .XML file that imported it)
Trong
For the country Belgium, you can use one of these 3 ways to import:
Country: Belgium
Country/Database ID: 21
Country/External ID: base.be
According to your need, you should use one of these 3 ways to reference records in relations. Here is when you should use one or the other, according to your need:
Use Country: This is the easiest way when your data come from CSV files that have been created manually.
Use Country/Database ID: You should rarely use this notation. It's mostly used by developers as it's main advantage is to never have conflicts (you may have several records with the same name, but they always have a unique Database ID)
Use Country/External ID: Use External ID when you import data from a third party application.
When you use External IDs, you can import CSV files with the "External ID" column to define the External ID of each record you import. Then, you will be able to make a reference to that record with columns like "Field/External ID". The following two CSV files give you an example for Products and their Categories.
