Good Morning and Happy Friday Tessi Community!!!
I'm posting to see if anyone has customized the Identify Duplicates procedure to look at email addresses. We'd like to add that as a parameter/field to look at and I'm having a bit of any issue getting it to work, so I thought I'd see if anyone out in Tessi Land has done this already. If anyone has already tackled this and don't mind sharing their code, I would be very grateful!!
Teresa
We have never thought about this but would be interested to hear if anyone has changed the procedure.
Thanks
Mark
I've done this on a one off (and I thought I saved my code, but didn't). A couple of things we found which I would just make sure to consider:
1. There were a LOT of people in our dbs that shared an email with a corporate/school/group account. This is a tangle we're hoping to solve in version 11 and beyond, but something to keep in mind that you might want to run for individuals only first, clean them up, and then add the rest of the accounts.
2. It was a lot harder to verify dups. We had times where there were two accounts with two different names and two different addresses, yet the same email. Ugh...
3. If you've never done it before, I'd do it separate from your normal de-dup run. I think you'll find a lot!
And just on a duplicate side note.. We recently started looking at Name2 for duplicates. And that brought in more worlds of fun!
Thanks Heather for the tips....definitely things to think about.
Levi - I'll take a look at Ken's code and see what I might be able to come up with
Have a great weekend!!!