How do I set the Organization from the Employer Relationship as a contact's Current Employer for multiple contacts at once?

Question

I have over 1,000 contacts which I imported along with an employer relationship, but these employers aren't showing up as "Current Employer" on the contact summary page because the relationship wasn't marked as current when it was created. I know how to fix this on an individual level, but not how to fix them all at once. Is there a way for me to make it so that all of these relationships are updated to "current employer" in a batch or mass update process, or do I have to do each one individually? Is there a way to indicate that this is the current employer when running an import?

CiviCRM 5.49.5

Answer 1

Welcome to SE!

There are a few options. Is this an import to a new system, so can we assume that all employer relationships should be active? If so, you could do:

• Go to Support > Developer > Api Explorer v4
• Select entity: 'Relationship', action: 'update'
• Where: select 'relationship_type_id:name', '=', 'Employee of'
• Values: 'is_active', 'yes'
• Execute