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.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
1
Reply
12204
Views
Thank you.
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
Oh that's sad... so no way to create partners while importing orders? We need to do that in multiple imports.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up