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

Powiązane posty	Odpowiedzi	Widoki
Import product data from Amazon to Odoo python import data excel odoo	0 maj 24	2596
Export XLSX in Odoo 16 xlsx odoo	0 maj 23	66
Can we Import attachments from front end on odoo 11 Rozwiązane import data	1 maj 19	8871
Import csv file in csv Rozwiązane import odoo	1 lis 16	6871
Import data from terminal using openerp-server import data	1 lis 15	13510

To pytanie dostało ostrzeżenie

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

Podoba Ci się ta dyskusja? Dołącz do niej!

To pytanie dostało ostrzeżenie

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

Podoba Ci się ta dyskusja? Dołącz do niej!

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