[Vtigercrm-developers] Duplicates at Leads

[Conrado Maggi]

If you have an unique id  you could use to match duplicated records then
you could use a direct database query

Google "delete duplicate rows" or similar

After that you should delete the entries in crmentity and custom tables
that do not match with any existing record

Cheers,
Conrado

El lunes, 27 de junio de 2016, Ranieri <rslemer at gmail.com> escribió:

> I have registered in leads over 2.5 million records
>
> On import many were repeated several times
>
> The size of the base using the find duplicates is not viable
>
> Does anyone have an idea that I can use to clean the base and leave only
> one of each?
>
> I have an ID field that could use, but I can not think of a solution to
> this.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20160627/a5d3e46c/attachment.html>