Odoo Help

Welcome!

This community 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.

0

How to import of data into many2one fields ?

By
Francisco Tobar
on 11/23/15, 9:38 AM 635 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.
0
Suhas
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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

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