I'm working with a non-profit to migrating data into the npsp and we're about to load contact data in. Each records includes a custom field which is a relational key to a separate relationship table exported from the old system, eTap.
I guess, how they have things setup, this will create a household for each contact. So I was thinking in order to get the households related properly in SF that after the import I'd export the contacts with the SF ID and then either generate some sort of custom import file to consolidate households, or write apex do it.
My question is... is will this work and is it the correct approach or is there a better way?