Can I import CSV and match database ID

Question

Trying to move data from one db to another vis CSV import
My csv has...
id 1 (name)  "A company"
id 2 (name) "Fred"  (parent_id) "id 1
Can I get openerp to associate  (parent_id) "id 1 with "id1" during an import

Regards

Cameron

Cameron · Accepted Answer

Yes ish!
I solved this by exporting the data to a csv, replacing id references with actual values

eg
sales_order.parter_id = 322,  - export this to csv you get the id 322 from res_partner, which openerp cannot import/match to partner
Using this SQL
copy
(SELECT so.id, rp.name FROM sale_order so
INNER JOIN res_partner rp ON so.partner_id = rp.id)
TO '/tmp/salesorder.csv' delimiter ',' csv header;
322 is replaced with the name from res_partner, which is easy to import

Neil Mitchell-Goodson · Answer

To import the external id of a related company, use:
*parent_id/id*
To import the database id of a related company, use:
*parent_id/.id*

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Create button to import csv file and show the content in a table import csv openerp7	2 heinäk. 15	10605
Price Update export import	2 marrask. 24	1706
Export/Import Issue: "Root articles must have internal permission" Ratkaistu export import	1 marrask. 24	2244
Import exported CSV on module load export import	1 lokak. 23	2932
how to retrieve export template (location and re-use ) ? Ratkaistu export import v7 csv v6	2 toukok. 24	10324

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!