Translations:Nhập tệp CSV vào Kiu ERP/19/en

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.