We are doing some clean-up for on our database for constituents duplicates.
Has anyone written an automated procedure to do a mass merge of constutents?
I am thinking of building a local table based on an agreed upon set of rules and call the internal Tessitura procedure with the from and to constituent id's
Bob
Bob,
The folks at the Sydney Opera House consortium (AKA the UCSS) have a great routine for this. I believe there are two elements - the SP to identify duplicate records based on rules agreed by the consortium members (I used to work for one of them) and then the merge routine which they run weekly. It didn't completely eliminate the need for some human work to be done on merging but sure made life a LOT easier!
Martin