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

Question

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.

So how can we import datas into the existing records?

Thanks.

Peter · Answer

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.

David Verove · Answer

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,

Bài viết liên quan	Trả lời	Lượt xem
Domain in read_group method Đã xử lý openerp7 openerp	1 thg 5 19	10188
Openerp 7 simple data import import openerp7	1 thg 8 15	3827
How do I override dispatch_rpc function in netsvc.py with a module in openerp 7? openerp7 openerp	1 thg 8 15	5238
Why is my one2many field not showing in form view? openerp7 openerp	1 thg 3 15	6270
Sort order_line in Physical Inventory basis on product default openerp7 openerp odoo	1 thg 4 20	3509

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!