In my Leads module I use it for basically a dumping ground for raw data/leads I purchase from lead vendors so I can utilize in other ways. The problem I am having is that Zoho makes it very difficult to prevent duplicate names coming in. They only allow for a limited screen if you will to match duplicate data. For example, you can screen out imports by email but the data I bring in does not contain any email addresses. I believe there is also a way to screen out by street and or City but the problem with that is if I have a spouse already in Zoho it will screen out the other household person such as spouse.
I have begged and pleaded with Zoho to add more fields that we can use to screen out duplicates upon import but for some reason this falls on deaf ears.
I've also tried the Deduplicate under the leads module to help with this issue but there again they have limited fields that we can select and not the ones I need. It is frustrating to me that Zoho would not make this more robust and useful in both of these areas.
So I am left now with a very large amount of duplicates that I need to do something with. It appears to me that I may have to export the data to MS Access or Excel or another 3rd party to try and clean this up. Just looking to see if anyone has any ideas about the easiest way of doing this and also any ideas of how I can prevent adding more duplicates when I import names from new mailing lists I obtain from mailing vendors.