Hi,
Has anyone had any problems with 'ghost' associations in output sets? I have an output set that includes the following fields:
Association Id#
Association Type
Association Name
Association Inactive
I've found a constituent (say Mr X) that has their own Customer No returned as an Association Id twice (e.g. associated with themselves twice), for two different association types, with two different names (In this example, Mrs X and Mr X). The Association Inactive field returns 'N' for both (so technically both should be active).
When I look at the constituent's record, no associations appear. Has anyone else had this issue?
Thanks,
Sam
Hi Sam,
We definitely have that here. I don't know the details behind it but I do know that this happened during the conversion of our contribution data from Raiser's Edge to Tessitura.
Luckily for us all of these associations have the same Association Type and it is a type we do not use for any other reason. So we can easily identify them all by creating a list or using SQL.
Our summer project for the development team is to go through these associations. If any are valid and need to be kept they will make sure it is added to the constituent record using an appropriate type. Once that is complete I intend to simply wipe out the bad conversion ones so they no longer exist.
As to why they don't show up in the constituent record - I can't say. The weird thing here is that some of them show up and others don't.
You aren't alone!
Beth