|
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).
|
|
|
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:320
|
|
32.
|
|
|
copy (select
'person_'||id as "External ID",person_name as
"Name",'False' as "Is a Company",'company_'||company_id
as "Related Company/External ID" from persons) TO
'/tmp/person.csv' with CSV
|
|
|
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:308
|
|
33.
|
|
|
Country: Belgium
|
|
|
module: base_import
openerp-web
|
|
|
|
(no translation yet)
|
|
|
|
Located in
code:addons/base_import/static/src/xml/import.xml:148
|
|
34.
|
|
|
base_import.tests.models.char.stillreadonly
|
|
|
module: base_import
|
|
|
|
(no translation yet)
|
|
|
|
Located in
model:ir.model,name:base_import.model_base_import_tests_models_char_stillreadonly
|
|
35.
|
|
|
External ID,Name,Is a
Company,Related Company/External 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:314
|
|
36.
|
|
|
Semicolon
|
|
|
module: base_import
openerp-web
|
|
|
|
(no translation yet)
|
|
|
|
Located in
code:addons/base_import/static/src/js/import.js:174
|
|
37.
|
|
|
If for example you have two product categories
with the child name "Sellable" (ie. "Misc.
Products/Sellable" & "Other Products/Sellable"),
your validation is halted but you may still import
your data. However, we recommend you do not import the
data because they will all be linked to the first
'Sellable' category found in the Product Category list
("Misc. Products/Sellable"). We recommend you modify
one of the duplicates' values or your product category
hierarchy.
|
|
|
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:179
|
|
38.
|
|
|
To create the CSV file for persons, linked to
companies, we will use the following SQL command in
PSQL:
|
|
|
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:306
|
|
39.
|
|
|
Microsoft Excel will allow
you to modify only the encoding when saving
(in 'Save As' dialog box > click 'Tools' dropdown
list > Encoding tab).
|
|
|
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:119
|
|
40.
|
|
|
Tab
|
|
|
module: base_import
openerp-web
|
|
|
|
(no translation yet)
|
|
|
|
Located in
code:addons/base_import/static/src/js/import.js:175
|