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

Data Import Doubt: How can we import datas into existing records in database?

By
rosey
on 8/20/14, 1:38 AM 581 views

I have 10 customers in my database. First i import a csv file which contains only name & email id. Later i prepare another file which contains name(for the reference), address, phone no, job etc. While  i import the second time, it created as a new record. That is an issue, it duplicate the customer record.

So how can we import datas into the existing records?

Thanks.

0
David Verove
On 8/20/14, 4:00 AM

Hello,

I see 2 solutions : 

- You create a unique constraint in your postgre database to make the name unique

- You take the id generated while exporting and you put it in id column while import.

Regards,

0
Peter
On 2/6/15, 3:28 AM

Export the customers to a csv file with the columns/fields you need. Make your changes and import the file again. A test data base would be good to check if it works.

The first column contains the ids of the customers. You mustn't change the ids. And don't add new rows to the file. Then the existing customers should be updated only when you import the file again.

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: 8/20/14, 1:38 AM
Seen: 581 times
Last updated: 3/16/15, 8:10 AM