Skip to Content
This question has been flagged
importdataxlsxodoo
2 Replies
6108 Views
Avatar
Othmane Ghandi

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

Avatar
Discard
Avatar
Othmane Ghandi
Author Best 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

Avatar
Discard
Avatar
Xavier Brochard
Best 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.

Avatar
Discard
Related Posts Replies Views Activity
Import product data from Amazon to Odoo
python import data excel odoo
Avatar
0
May 24
610
Export XLSX in Odoo 16
xlsx odoo
Avatar
0
May 23
66
Can we Import attachments from front end on odoo 11 Solved
import data
Avatar
Avatar
1
May 19
6184
Import csv file in csv Solved
import odoo
Avatar
Avatar
1
Nov 16
5073
Import data from terminal using openerp-server
import data
Avatar
Avatar
1
Nov 15
10724