This topic describes how to import and/or update registrations on the Registrations > Import page. You can also assign agenda items to existing registrations from the same page; see Import Registration Agenda. This feature is available to Administrators, Event Builders, Registration Support users who have the Allow user to import registrations access option enabled in their user account. Video: Importing Registrations (2 min.)
Overview
The Registration Import Wizard consists of major steps. The steps are:
- Prepare the external data file to be imported.
- Upload the data file to the server.
- Map the columns of the data file to fields in the registrations.
- Set Import Options.
- Confirm and Complete.
Preparing the Data File for Import
- The file can be in plain tab-delimited text: a title row, one row per registrant, with one column per field (First Name, Last Name, etc.).
- Many software applications have an option to save data in this format.
- For example, in Excel, select "Save as type:" – "Tab-delimited text (.txt)", or in ".xlsx format".
- The file must have a .txt or .xlsx extension, to import properly into Certain.
- You may want to convert text before importing it.
- Example: UPPERCASE will stay that way when imported. So you may need to use Excel or another program to ensure the data looks the way you want it to in Certain, such as "Jones" instead of "JONES".
- Registration Status: If your file includes a column for Registration Status, each value must exist in the event, either as one of the custom registration statuses set up on Plan > Configure > Custom Statuses, or one of the 11 default registration statuses (New, Requested Invitation, Waitlist Hold, Invited, Request Denied, Invitation Sent, Pre-Registered, Declined Invitation, Cancelled, No-show, Attended), unless the account has the Show Default Statuses option cleared on Account Settings > Implementation > Security (rare).
- Custom Registration Properties: Your import can include Custom Registration Properties, as configured for the event on Plan > Configure > Options > Custom Registration Properties.
- Note: Import a value of 1 or True to set the property, or of 0 or False to unset it. Other values (including spaces, but excluding blanks) would generate errors; a blank in an import that updates existing record will leave the current value on that record unchanged.
- On To Do List: You can set the On To Do List property for registrations you import.
- Note: Import a value of 1 or True to set the property, or of 0 or False to unset it. The same applies to this property.
- Data formats must match those expected in Certain. For example, Certain uses a single Postal Code field, not separate "Zip" and "+4" fields.
- If your event is in "Testing" status, the number of rows must be less than or equal to 1000.
- If you have the file open in Excel, be sure to close it before starting the import.
Updating Existing Registrations
- You can update existing registrations by importing records with new information.
- Include the Profile Unique ID or Profile Username in the import.
- You can instead include the External Profile ID if your organization uses it. This is usually a link to a Marketing Automation system such as Eloqua or Marketo.
- Any of those fields is a unique identifier for a profile.
- If someone with that Profile ID or Username is already registered, their details will be updated with the information in the import.
- Only fields in the import are changed; all other fields are unaffected.
- For example, you might be changing only Organization and Email.
- If nobody with that Profile ID or Username is already registered, then: If a profile with that ID does exist, the import creates a registration for them. If no profile with that ID exists, the import creates a new profile and a registration.
- Note: You cannot use a Registration ID to update a registration.
Import Registration Data
Uploading the File
- Select the type of data you'd like to import – Import/Update Registrations.
- Read the on-screen instructions about preparing your data, and click Next.
- Select the file to upload. Click Browse to locate the data file you want to import into Certain. Select the file and click Open.
- Select an action to take if the file being uploaded has the same name as an existing file: Don't upload; Overwrite existing file; Upload and re-name the file. Click Upload File.
- This uploads the file to Certain, but doesn't yet import it. The upload process may take a few minutes, depending on how large the file is. Click Next.
Map Data Fields
- Map the data fields to import:
1. In the drop-down list of uploaded files, select the file to import data from.
2. Click Preview 1st Row to see a preview of the data in the first row of the file, which should be field names.
3. The Fields to Import list shows a default initial set of fields. (The default list of Profile fields for mapping in all events in the account is set by an Administrator on Account Settings > Registration > Profile Data.)
4. Select any additional fields from the Fields Available for Event. (You can type in the filter field to find a field quickly.)
5. Click » to move them into Fields to Import. (You can click »» to move them all.)
6. Remove any unnecessary fields from Fields to Import, by clicking «. (You can click «« to move them all.)
7. Reorder the Fields to Import, using the Up and Down buttons, until they match the order of the columns in the Columns in Data File preview box.
8. Click Next.
Set Data Import Options
- 1. Select the Attendee Type and Status to assign to the imported records.
- Note: If your selected file includes a column for Registration Status, you must select "Do not change" for Status.
- 2. Specify the First row containing data. This is usually 2, because the first row is normally column headings. (You can also use this and the next field (Maximum Number of Rows to Import) to import a subset of data starting somewhere other than at the beginning of the data file.)
- You may restrict the size of the total import by entering a value in Maximum Number of Rows to Import.
- 3. Click Next.
Confirm Parameters and Complete Import
- 1. Review the information shown on the Confirm Upload Parameters page. If the information appears incorrect, click Back and rectify any errors. If the information appears correct, click Finish.
- 2. Click OK when ready to import the registrations.
- 3. The data import is scheduled. You will receive an email when it is finished.
- 4. Click the link to import more registrations if required.
- 5. Otherwise, click Finish to close the wizard.