Skip to Content
This question has been flagged
exportimportcsvopenerp7
2 Respostes
9131 Vistes
Avatar
Cameron

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

Avatar
Descartar
Avatar
Cameron
Autor Best 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

Avatar
Descartar
Avatar
Neil Mitchell-Goodson
Best 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

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Create button to import csv file and show the content in a table
import csv openerp7
Avatar
Avatar
2
de jul. 15
11278
Price Update
export import
Avatar
Avatar
2
de nov. 24
2343
Export/Import Issue: "Root articles must have internal permission" Solved
export import
Avatar
1
de nov. 24
3219
Import exported CSV on module load
export import
Avatar
Avatar
1
d’oct. 23
3959
how to retrieve export template (location and re-use ) ? Solved
export import v7 csv v6
Avatar
Avatar
2
de maig 24
11298