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 Partner with one contacts using one .csv file only?

By
joyal
on 4/7/13, 2:18 AM 747 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?

0

patrick

--patrick--
1958
| 5 4 7
Baarn, Netherlands
--patrick--
patrick
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.

joyal
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.

patrick
on 4/9/13, 4:54 AM

Understand... Thanks for the detailed reply.

joyal
on 4/13/13, 1:26 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

0 follower(s)

Stats

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