Odoo Help


How to Import Partner with one contacts using one .csv file only?

on 4/7/13, 2:18 AM 1,123 views

I want to import Partner with one address, one contact Using one .csv file. Can any one suggest me how to do it? or can any one post a template for it?




| 5 4 7
Baarn, Netherlands
On 4/8/13, 5:11 AM

If I understand your question correctly, you want to import a partner and that partner has 1 contact associated with it.

Example: Company X0, with contact X1 Company Y0, with contact Y1.

You need to know that both entries (company and contact) are in the same table cq object, and share most of the fields.

Solution (on openERP V7):

  1. Create a line for the company
  2. create a line for the contact, and fill a column 'related company' with the name of the company. This will combine the contact with the company.

If needed I can provide you an example CSV-file, with the structure defined.

Thanks a lot for your reply... If I understand correctly, In your mentioned case we are creating .csv Files 2 times, (Or we are importing 2 times) 1. Create a Company record, 2. Create a Contact Record with company name.... My question was is there any way that I can only create only .CSV file to Import 1 Company(Partner) -> 1 Address -> 1 Contact,by doing only one time import.

on 4/9/13, 1:37 AM

Jacksj, you misunderstood me. You need to create 1 CSV-file, with multiple lines in it. Line 1 is the heading (best would be the name of the column), line 2 is the company, line 3 is the contact of that company, line 4 is another company, line 5 is the contact of company in line 4, and so on.

on 4/9/13, 4:54 AM

Understand... Thanks for the detailed reply.

on 4/13/13, 1:26 AM

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

0 follower(s)


Asked: 4/7/13, 2:18 AM
Seen: 1123 times
Last updated: 3/16/15, 8:10 AM