Odoo Help


How to import of data into many2one fields ?

Francisco Tobar
on 11/23/15, 9:38 AM 1,976 views

Hello , I need to import data  from a csv file. But Odoo model towards which I import the data contains Many2one fields. What is the right way to import data into such fields?

Thank you.
On 11/24/15, 2:26 AM

If you are importing values into a 'many2one' field, that values must already be present in corresponding model.

Suppose, in our import, 'partner_id' is a many2one field. The value imported is say 'suhas' , it means suhas must be present in partner list . Otherwise import terminate with an error message.

You have to prepare separate csv files for 'partner' and import them before importing current csv.

Similar is the situation if the the field type is many2many'

default many2one field require name field ( or _name_rec) for csv import.

Thanks for your answer! You do not know if there are ways to save the import format of a model ? For example , presetting the fields you want to import. Like the export function. Thanks again

Francisco Tobar
on 11/24/15, 7:38 AM

Oh that's sad... so no way to create partners while importing orders? We need to do that in multiple imports.

Mathieu Laflamme
on 7/20/17, 3:53 PM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 11/23/15, 9:38 AM
Seen: 1976 times
Last updated: 11/24/15, 2:26 AM