[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.

Gerelateerde posts	Antwoorden	Weergaven
Import product data from Amazon to Odoo python import data excel odoo	0 mei 24	2590
Export XLSX in Odoo 16 xlsx odoo	0 mei 23	66
Can we Import attachments from front end on odoo 11 Opgelost import data	1 mei 19	8871
Import csv file in csv Opgelost import odoo	1 nov. 16	6858
Import data from terminal using openerp-server import data	1 nov. 15	13507

Deze vraag is gerapporteerd

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

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Deze vraag is gerapporteerd

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

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

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