Hi All,
I'm wondering if it's possible to change the External ID of an Attendee please? And if so, how, please?
I have the Attendee Administrator role, and I can Activate/Inactivate attendees, and I can change the following fields:
But I can't work out how to change the External ID. Ideally, I'd like to do this in bulk, if possible.
The reason I want to do this, is that someone, somehow, managed to create over a 1,000 attendees with duplicate External IDs. This is causing an issue when we try to maintain these via the Import/Extract Monitor tool.
We are getting tripped up by the second bullet point below becuase there are multiple matching records, and non are active.
If more than one matching record is found * If only one is active, that record will be updated. * If more than one is active or none are active, the record will fail to import and be logged as a warning in the error log.
Source: Section 5 - Attendee Import V2 Specification Last Revised: April 19, 2024
Thanks in advance!
Hi KevinD,
Thanks for the response!
The file we are importing through Import/Extract Monitor does not have any duplicates.
However, when we look at the Run Details, we see errors:
If we search for one of these IDs in Attendee Admin we can see the duplicate:
Since there are multiple attendees with the same ID, and zero are active, then it doesn't seem possible to use the Import/Extract Monitor to update the attendee, for example to Activate it again if an employee comes back after extended absence.
I also have a Cognos report that pulls ALL attendees, and with a quick bit of analysis in Excel, I can see that there are about 2,070 duplicated records (1,035 uniques that are doubled up).
Thanks,
Alex
