Skip to Content
Dette spørgsmål er blevet anmeldt
exportimportcsvopenerp7
2 Besvarelser
10057 Visninger
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
Kassér
Avatar
Cameron
Forfatter Bedste svar

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
Kassér
Avatar
Neil Mitchell-Goodson
Bedste svar

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
Kassér
Relaterede indlæg Besvarelser Visninger Aktivitet
Create button to import csv file and show the content in a table
import csv openerp7
Avatar
Avatar
2
jul. 15
12204
Price Update
export import
Avatar
Avatar
2
nov. 24
3885
Export/Import Issue: "Root articles must have internal permission" Løst
export import
Avatar
1
nov. 24
4866
Import exported CSV on module load
export import
Avatar
Avatar
1
okt. 23
5872
how to retrieve export template (location and re-use ) ? Løst
export import v7 csv v6
Avatar
Avatar
2
maj 24
12975