Import/Update Registrations

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:

Video: Importing Registrations (2 min.)

Overview

Using the Registration Import Wizard consists of the following major steps:

1. Prepare the external data file to be imported. 2. Upload the data file to the server. 3. Map the columns of the data file to fields in the registrations. 4. Set Import Options 5. Confirm and Complete

Preparing the Data File for Import

The critical first step is to prepare your data file:

Updating Existing Registrations

You can update existing registrations by importing records with new information.

> Note: You cannot use a Registration ID to update a registration. Why not?

Import Registration Data

Uploading the File

1. Select the type of data you'd like to import – Select “Import/Update Registrations”.

2. Read the on-screen instructions about preparing your data, and click Next.

3. Select the file to upload. – Click Browse to locate the data file you want to import into Certain.

4. Select the file and click Open.

5. Select an action to take if the file being uploaded has the same name as an existing file:

6. 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.

7. 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.) Click » to move them into Fields to Import. (You can click »» to move them all.) 5. Remove any unnecessary fields from Fields to Import, by clicking «. (You can click «« to move them all.) 6. 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. 7. 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 a subset of data starting somewhere other than at the beginning of the data file.) 3. You may restrict the size of the total import by entering a value in Maximum Number of Rows to Import. 4. Click Next.

Confirm Parameters and Complete Import

1. Review the information shown on the Confirm Upload Parameters page.

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..

Source:

Keywords: Registration Import Wizard, Registrations > Import, import, update registrations