|
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
|
|
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
|
|
32.
|
|
|
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
|
|
33.
|
|
|
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
|
|
36.
|
|
|
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
|
|
38.
|
|
|
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
|
|
39.
|
|
|
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
|
|
40.
|
|
|
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
|
|
42.
|
|
|
will also be used to update the original
import if you need to re-import modified data
later, it's thus good practice to specify it
whenever possible
|
|
|
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:82
|
|
43.
|
|
|
file to import. If you need a sample importable file, you
can use the export tool to generate one.
|
|
|
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:26
|