Skip to Content
Dette spørgsmål er blevet anmeldt
crmimportcustomersduplicate
4 Besvarelser
9981 Visninger
Avatar
Ronald Luna

Is there a way to delete all duplicates entries form the CRM customer table?

I imported a csv file into customers but at the end of the process it throw me an error so I tried again. When I looked into my customer directy they were all there but duplicate. is there a way to delete the duplicate or empty the table and start do a new import?

Avatar
Kassér
Avatar
Denis Baranov
Bedste svar

It seem that this module - https://apps.odoo.com/apps/modules/9.0/crm_duplicates/ - would be of use

Avatar
Kassér
Avatar
Abhishek
Bedste svar

Hi, I think it will better open pgadmin and look your duplicate customer

SELECT name FROM res_partner GROUP By name HAVING ( COUNT(*) > 1 )

then you will find all the customer which is more then one in entry in customer table, and after this go in relevant python file of customer and put _sql_constraint for name or name or code combination so next time when you upload or create the same entry it will give a pop-up and will be not allowed to enter duplicate customer name.

Avatar
Kassér
Avatar
Ronald Luna
Forfatter Bedste svar

Understood. Thanks!

Avatar
Kassér
Avatar
Simplify it!
Bedste svar

You have to do it manually or if you have access to postgresql you can make a SQL sentence to delete all the table

Avatar
Kassér
Related Posts Besvarelser Visninger Aktivitet
How to add a contact to an existing contact which is also a contact of another contact
crm customers
Avatar
0
aug. 24
196
Odoo 11 - Import Sales/Customer or Contacts Won't Map Company Name
import customers
Avatar
Avatar
2
apr. 18
6236
What is the structure of the CVS to import as customer in to openERP?
crm import
Avatar
Avatar
1
mar. 15
3303
Prevent duplicate importing bank statement
import duplicate bankstatement
Avatar
Avatar
1
nov. 23
2012
Excel update records audit trail
crm import Excel
Avatar
0
dec. 21
2340