Last Friday AM a scheduled merge was done on two customer records. Two adult males in the same household with the same address and name were merged, but it turns out to be two different individuals.
I searched the community already and what I found was quite old, so I wouldn't trust any script or code from back then.
I also asked Support if they have anything to perform an unmerge, and they are basically saying do it yourself or pay for consulting.
So, if anyone out there has done this already, and is willing to share code, I would appreciate it. You can reach me directly at gerald.boutot@strazcenter.org
I'm going to use the TA_AUDIT_TRAIL table to identify those records that are present as a result of the merge to fix those records, then go through the AP_MERGE_CUSTOMER and AP_MERGE_CUSTOMER2 processes and document every table that get touched, then using data from our TEST system (which is recent and has the unmerged customers) I'll do the analysis on the data and create a script to update customer ID's on the records that were affected by the merge.
But since the Merge Utility is a standard utility, and it's destructive by nature, is it too much to ask that Tessitura create a way to undo an accidental merge? I'm surprised such a utility isn't provided.
Thanks in advance if anyone has something that could jump start this process.
There used to be an unmerge shared report from Washington National Opera. Doesn't look like it exists on the shared reports page any longer. I don't think we ever installed this and ended up going down the manual route using our test environment as a reference.