Allow Duplicate External IDs for later merge?

Question

I have a large number of contacts across different contact sub-types, imported via CiviMigrate.

The particulars:

I am pulling multiple contact types from the same, flat master table. This means that for example:

Pass 1 : Grabs all students Pass 2: Grabs all teachers Pass 3: Grabs all volunteers

There are naturally some students which became teachers, and were volunteers at some point, so there can be any combination of contact sub-types.

In the "worst" case, I'd end up with 3 contacts, one of each sub-type, that would need to be flattened into a single contact.

I have been matching on first and last name with some success, but there are multiple cases in which this causes the need for manual merge work (people with the same name).

Is there any way to temporarily allow dupe external ID's for the purpose of a later merge?

Now, this all stems from the fact that I can't find any documentation on how to pass multiple contact sub-types at once via CiviMigrate, perhaps there's an angle there?

Thanks! -d

Answer 1

I do not think there is a (good) way to use duplictae external IDs in CiviCRM - if you want to use the external ID field to do so. You could however create a custom field, import your external ID in that one and then adapt your matching rules to find duplicates (/civicrm/contact/deduperules?reset=1).

Answer 2

If you really do want to do it via the External ID, then subtly adjust your ID on each import eg 567-s for the student import, 567-t for teacher import, 567-v for volunteer import