Browsing Norwegian Bokmal translation

3.

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.

6.

Country/Database ID: the unique OpenERP ID for a
record, defined by the ID postgresql column

7.

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)

8.

For the country
Belgium, you can use one of these 3 ways to import:

11.

copy
(select 'company_'||id as "External ID",company_name
as "Name",'True' as "Is a Company" from companies) TO
'/tmp/company.csv' with CSV HEADER;

13.

Use
Country/External ID: Use External ID when you import
data from a third party application.

18.

Note that if your CSV file
has a tabulation as separator, OpenERP will not
detect the separations. You will need to change the
file format options in your spreadsheet application.
See the following question.

24.

Use Country: This is
the easiest way when your data come from CSV files
that have been created manually.

26.

For example, to
reference the country of a contact, OpenERP proposes
you 3 different fields to import:

31.

As you can see in this file, Fabien and Laurence
are working for the Bigees company (company_1) and
Eric is working for the Organi company. The relation
between persons and companies is done using the
External ID of the companies. We had to prefix the
"External ID" by the name of the table to avoid a
conflict of ID between persons and companies (person_1
and company_1 who shared the same ID 1 in the orignial
database).