Skip to Content
This question has been flagged
1 Reply
13696 Views
Avatar
Francisco Tobar

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.
Avatar
Discard
Avatar
Sagar Pise
Best Answer

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.

Avatar
Discard
Francisco Tobar
Author

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

Mathieu Laflamme

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