Update registrations by import without creating duplicates

An import adds new records unless it can match each row to one that already exists. Here's how to update records without creating duplicates.

Update existing records

1. Export the records you want to change from the event. Include the Profile Unique Id column, which Certain uses to match each row to an existing profile. 2. Edit only the columns you need to change. Don't change or remove the Profile Unique Id. 3. Import the file back into the same event. Go to Manage > Registrations > Import and choose Import/Update Registrations. See Registrations FAQ - Import Registration Data. 4. Check the results. See Checking Imported Registration Data.

Changing statuses for many people

To mark many registrants as Attended or another status, use a mass action on the registration list instead of an import.

If an import created duplicates

Mark the extra registrations as Test so they drop out of counts and reports.

You can mass-delete registrations, but profiles must be deleted one at a time.

File rules that trip people up

If your import failed or didn't change anything

Common file problems

Dropdown answers won't import

The value must match an answer option exactly, such as "Yes", with no extra spaces at the end.

Yes and No fields won't import

Yes/No fields need 1 for yes and 0 for no.

Names and emails ended up in the wrong columns

Fields to Import must be in the same order as the columns in your file.

The import adds blank rows or fails

Merged header rows and leftover formatting can create hundreds of blank rows. Copy only your data into a new sheet, paste as values, and import that file.

Emails won't import

Check for stray characters before or after the email address.

Sessions won't import

Each location in the file must exist first under Manage > Speakers and Sessions > Locations.

Next step: Export first, then edit and re-import.

Source: https://platform-support.certain.com/hc/en-us/articles/44505327344535-Update-registrations-by-import-without-creating-duplicates

Published:

Keywords: registrations import, Profile Unique Id, Import/Update Registrations, duplicate registrations, Certain