I have some confusion understanding the correct way to complete the TRU_ASSOCIATE_MAPPING and the V11_pre_upgrade_check.
I have reread the documentation and re-watch the webinar Anne gave.
I’m still getting errors for example that TRU_ASSOCIATION_MAPPING, Association pair friend/ friend not completely mapped. Which is in the ‘O’ other category and we have mapped new assoc type to friend and new other assoc type to friend.
My concern is why do I have to assign a New affil type; which means I have to create a new type to stop getting these errors in the V11_pre-upgrade_check.
Hi Joseph,
You need the affiliation to cover the scenario of a v10 individual record with name 2 being converted to a household during migration being associated to an individual record with no name 2 (I'm assuming the later will remain an individual in v11).
Because associations are between like for like records (individual to individual, group to group etc) , the association will be converted to an affiliation because the relationship is now between a group and an individual.
Basically, the columns 'New Assoc Type', 'New Other Assoc Type' and 'New Affil Type' in TRU_ASSOCIATION_MAPPING need to have values for all hard associations or you will get an error message.
Hope that makes sense.
Patrick.