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
- Web addresses, such as LinkedIn URLs, must start with https://
- Avoid double spaces and special characters in file names.
- Save the file as Tab-Delimited Text or Excel/CSV, and close it in Excel before you upload it.
- If the event status is Testing, import 1,000 rows or fewer at a time.
If your import failed or didn't change anything
- Records didn't update. The file needs a column that identifies each existing record, such as Profile Unique ID. An email address alone won't match an existing record.
- Nothing matched, even with an ID column. Extra spaces after the IDs stop them from matching. This often happens when values are copied and pasted. In Excel, use =TRIM() on the column, paste the results back as values, and save.
- "Bad Value Passed to EnumeratedValuesTranslator". A value in a choice field doesn't exactly match one of the allowed answers. Check spelling and capitals, remove spaces before and after, and fill any blank cells.
- "CSV is empty". Every column needs a header. Delete any blank column with no header.
- Names are swapped or emails are missing. The columns were mapped to the wrong fields. Check the mapping on the preview step before you finish the import.
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.