Records are skipped when I import registrations. How do I fix this?

  • 1
  • 2
  • 3
  • 4
  • 5

Did this article resolve your issue?

Yes
No

What can we do to make this article better?

What can we do to make this article better?

Did this article resolve your issue?


Excellent! Thank you for your feedback

Did this article resolve your issue?


We are sorry to hear that!  For more assistance, open a case and a Product Consultant will contact you directly.

  • 1
  • 2
  • 3
  • 4
  • 5
Once you've finished importing registrations, you can check the Import Summary report by going to Admin > Reporting > View > Recent Imports/Exports. If someone was skipped, try the solutions below.
 
NOTE: You cannot update registrants using the registration import, therefore all existing accepted registrants will be skipped. You'll need to follow these steps instead.

Assign contact types to a registration path
If you're using multiple registration paths, every registrant's contact type in your import file must be associated to the registration path that you've chosen to import into. If your import file contains other contact types that are associated to different registration paths, you will see the error, "Contact type not associated to registration path" on the Import Summary report.
 
1 Begin by selecting the event.
2 Hover over Website & Registration and, under Registration, click Registration Settings.
3 Click the name of a registration path.
4 Click Edit.
5 Scroll down to the Associated Registration Types section and click Add Registration Types....
6 Check the boxes beside the appropriate registration types.
7 Click OK
8 Click Save.
Repeat for all registration paths.  
10 Import your registrations again
User-added image

Make each header unique
The header in the first row of each column must be different than any other header.
 
1 Open your Excel file of registrations.
2 Ensure every header in the first row is unique. (If you find two sessions with the same name, skip to the solution below).

3 Save the file and import your registrations again
User-added image

Change shared session names temporarily 
If two sessions share a name, you'll get the error: "Enter a unique name for each column in the file." You can temporarily give one a different name until you've successfully imported your registrations. 
 
1 Hover over Event Details and, under Agenda Items, click Sessions.
Click the topmost checkbox to select all sessions at once. 
3 Hover over Actions and click Edit.  
4 Give the duplicate session a unique name.

5 Click Save
6 Import your registrations again
7 Change the session's name back to the original.
User-added image
Add required columns
In order to import a registrant, the required columns must be filled out.
 
1 Begin by selecting the event.
2 Hover over Invitee Management and, under Import, click Registrations.
3 Review the list of required fields. These are the columns that are necessary for a record to be imported.
4 In your Excel file, ensure all of these columns are completely filled out with the correct information.
5 Save the file and import your registrations again
User-added image
 
Remove excess data
Data in a column without a header will prevent the record from being imported.
 
1 Open the import file in Excel.
2 Select everything (Ctrl + Shift + Space).
3 Copy the data (Ctrl + C).
4 Open a new Excel spreadsheet, and paste the data (Ctrl + V).
5 Save the file and import your registrations again
 
 
 

Did this article resolve your issue?

Yes
No

What can we do to make this article better?

What can we do to make this article better?

Did this article resolve your issue?


Excellent! Thank you for your feedback

Did this article resolve your issue?


We are sorry to hear that!  For more assistance, open a case and a Product Consultant will contact you directly.

  • 1
  • 2
  • 3
  • 4
  • 5

Did this article resolve your issue?

Yes
No

Did this article resolve your issue?

What can we do to make this article better?

Did this article resolve your issue?

What can we do to make this article better?

Did this article resolve your issue?


Excellent! Thank you for your feedback

Did this article resolve your issue?


We are sorry to hear that!  For more assistance, open a case and a Product Consultant will contact you directly.

  • 1
  • 2
  • 3
  • 4
  • 5

Did this article resolve your issue?

Yes
No

Did this article resolve your issue?

What can we do to make this article better?

Did this article resolve your issue?

What can we do to make this article better?

Did this article resolve your issue?


Excellent! Thank you for your feedback

Did this article resolve your issue?


We are sorry to hear that!  For more assistance, open a case and a Product Consultant will contact you directly.

  • 1
  • 2
  • 3
  • 4
  • 5

Did this article resolve your issue?

Yes
No

Did this article resolve your issue?

What can we do to make this article better?

Did this article resolve your issue?

What can we do to make this article better?

Did this article resolve your issue?


Excellent! Thank you for your feedback

Did this article resolve your issue?


We are sorry to hear that!  For more assistance, open a case and a Product Consultant will contact you directly.

  • 1
  • 2
  • 3
  • 4
  • 5

Did this article resolve your issue?

Yes
No

Did this article resolve your issue?

What can we do to make this article better?

Did this article resolve your issue?

What can we do to make this article better?

Did this article resolve your issue?


Excellent! Thank you for your feedback

Did this article resolve your issue?


We are sorry to hear that!  For more assistance, open a case and a Product Consultant will contact you directly.

  • 1
  • 2
  • 3
  • 4
  • 5

Did this article resolve your issue?

Yes
No

Did this article resolve your issue?

What can we do to make this article better?

Did this article resolve your issue?

What can we do to make this article better?

Did this article resolve your issue?


Excellent! Thank you for your feedback

Did this article resolve your issue?


We are sorry to hear that!  For more assistance, open a case and a Product Consultant will contact you directly.