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 a little bit of customization of the Identify Duplicates local procedure. Ken McSwain has been kind enough to post the Sydney Consortium's version of their local version of it. He has quite a bit of custom process in there and I stole bits here and there as I needed them. You can find the files in the "Merging" folder on his profile.
http://www.tessituranetwork.com/community/members/kenmcswain5454/default.aspx
Probably not exactly what you need, but lots of good examples in there.
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!!!
Brian,
Thank you so much for this!!
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Wilbur Grundstrom Sent: Monday, March 28, 2011 10:53 AM To: Teresa Dean Subject: Re: [Tessitura Technical Forum] Identify Duplicates Procedure
Attached is our version of LP_IDENTIFY_DUPLICATES which I have modified for email. If you look at the code, we exclude our eaddress_type of 11 which is alternate shipping.
Brian Grundstrom Washington National Opera
From: Teresa Dean <bounce-teresadean9276@tessituranetwork.com> Sent: 3/25/2011 3:09:21 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Thanks, Brian; I’ve borrowed your e-mail code, tested it, and implemented it.
Lucie
I have been using a query that pulls all accounts with duplicate e-mails, and checking them every so often. We have many accounts (in the low hundreds) where the same e-mail is used in, say, a corporate and individual account—or a teacher’s personal account and the school where he/she works.
Having these pull into the duplicate checking process (vs. running an extra report) will be a big time-saver.