CiviCRM Community Forums (archive)

Hi,

We have a database where the vast majority of the Organizational records in the database are actually Household records. For example, we would have an organizational record for "Mr. & Mrs. John Doe" and this organizational record also has a membership as well as relationships. We need to now be able to convert out these records from the incorrect organizational record into a household record and make sure we can retain the appropriate relationships and memberships. Would an update import support this? What is the best way to handle this in the most efficient way possible? I'm thinking the cleanest way to do this would be to export all the records, remove them from the database, then reimport them as household records and then rebuild relationships and memeberships via update imports, etc with their new internal contact ids.

Any thoughts/advice on this would be greatly appreciated!

Thanks!

--S

Honestly, that was my first thought, but then it occurred to me that there are specific relationships that are set between org to indiv that would be broken once we change the contact type. We would have to re-build those relationships in some way....Not to mention the membership.

Sounds like a pain in the ass, but figured I'd sound-board the community first. Thanks!