[Import Data] "Show fields of relation fields (advanced)" when importing

Question

Hello Guys
How to check "Show fields of relation fields (advanced)" on the import page?
I want to choose the "fields/external_id" for Many2one fields
Thanks in advance

Othmane Ghandi · Answer

Hi All I got the answer : In order to "Show fields of relation fields (advanced)" be checked to choose
the "fields/external_id" for Many2one fields. You should, in your file of importation csv or xlsx, make the header of the column like this : * * *store_id / id * * * instead of *store_id.* By using* store_id / id => * "Show fields of relation fields (advanced)" will be checked automatically and than you can choose external_id or whatever you want
Kind Regards

Xavier Brochard · Answer

Put a slash "/" in a header (you way want to add fields name but it works without). No need to add datas in the column.

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Import product data from Amazon to Odoo python import data excel odoo	0 toukok. 24	995
Export XLSX in Odoo 16 xlsx odoo	0 toukok. 23	66
Can we Import attachments from front end on odoo 11 Ratkaistu import data	1 toukok. 19	6776
Import csv file in csv Ratkaistu import odoo	1 marrask. 16	5407
Import data from terminal using openerp-server import data	1 marrask. 15	11298

Tämä kysymys on merkitty

Hi All

I got the answer : In order to "Show fields of relation fields (advanced)" be checked to choose
the "fields/external_id" for Many2one fields. You should, in your file of importation csv or xlsx, make the header of the column like this : store_id / id instead of store_id.

By using store_id / id => "Show fields of relation fields (advanced)" will be checked automatically and than you can choose external_id or whatever you want

Kind Regards

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

Tämä kysymys on merkitty

Hi All

I got the answer : In order to "Show fields of relation fields (advanced)" be checked to choose the "fields/external_id" for Many2one fields. You should, in your file of importation csv or xlsx, make the header of the column like this : store_id / id instead of store_id.

By using store_id / id => "Show fields of relation fields (advanced)" will be checked automatically and than you can choose external_id or whatever you wantKind Regards

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

I got the answer : In order to "Show fields of relation fields (advanced)" be checked to choose
the "fields/external_id" for Many2one fields. You should, in your file of importation csv or xlsx, make the header of the column like this : store_id / id instead of store_id.

By using store_id / id => "Show fields of relation fields (advanced)" will be checked automatically and than you can choose external_id or whatever you want

Kind Regards