|
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.
|
|
|
module: base_import
openerp-web
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
code:addons/base_import/static/src/xml/import.xml:163
|
|
6.
|
|
|
Country/Database ID: the unique OpenERP ID for a
record, defined by the ID postgresql column
|
|
|
module: base_import
openerp-web
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
code:addons/base_import/static/src/xml/import.xml:142
|
|
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)
|
|
|
module: base_import
openerp-web
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
code:addons/base_import/static/src/xml/import.xml:155
|
|
8.
|
|
|
For the country
Belgium, you can use one of these 3 ways to import:
|
|
|
module: base_import
openerp-web
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
code:addons/base_import/static/src/xml/import.xml:146
|
|
9.
|
|
|
company_1,Bigees,True
|
|
|
module: base_import
openerp-web
|
|
|
|
(no translation yet)
|
|
|
|
Located in
code:addons/base_import/static/src/xml/import.xml:303
|
|
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;
|
|
|
module: base_import
openerp-web
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
code:addons/base_import/static/src/xml/import.xml:297
|
|
13.
|
|
|
Use
Country/External ID: Use External ID when you import
data from a third party application.
|
|
|
module: base_import
openerp-web
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
code:addons/base_import/static/src/xml/import.xml:160
|
|
14.
|
|
|
person_1,Fabien,False,company_1
|
|
|
module: base_import
openerp-web
|
|
|
|
(no translation yet)
|
|
|
|
Located in
code:addons/base_import/static/src/xml/import.xml:316
|
|
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.
|
|
|
module: base_import
openerp-web
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
code:addons/base_import/static/src/xml/import.xml:100
|
|
23.
|
|
|
Map your data to OpenERP
|
|
|
module: base_import
openerp-web
|
|
|
|
(no translation yet)
|
|
|
|
Located in
code:addons/base_import/static/src/xml/import.xml:55
|