Import Registration Session Instances

Import Registration Session Instances

Accessed via: (Event) > Manage > Registrations > Import > Type of data = "Registration Session Instances"

(Speaker and Session Management must be enabled for the event.)

Jump to: || Pre-requisites || Steps || Data File || Upload || Mapping || Import ||

This topic describes how you can assign, update and cancel sessions on existing registrations, via the Registrations > Import page.

(From the same page you can also import and update registrations and registration agenda: see Import/Update Registrations and Import Registration Agenda.)

This feature is available to Event Builders and Administrators, and to Registration Support users who have the Import Registration Data user access option selected on their user record.

Video: Importing Registration Session Instances

Prerequisites

You will need:

Registration Agenda Import Wizard

Steps to follow

1. Create an Excel or.csv file that includes the four columns described below. 2. Upload your file. (See below for a sample file.) 3. Map all the columns in the file to fields in the database. 4. Submit the import.

Notes for success

If the import of a row fails, only that row fails, not the rest of the import.

You will receive an email upon completion of the import, detailing any records that failed.

Create a File of Data to Import

First prepare the data file to import.

International characters and special characters

if your import includes international or special characters, best practice is to use a .CSV file.

File requirements

Example

This import would assign three session instances to the same registrant (the first three rows, with the same Registration Code but different Session Codes and Instance Codes), and cancel one session instance for a different registrant (the fourth row).

Registration CodeSession CodeInstance CodeRegistration Session Status
1234-55-122DemoDemo_7592Registered
1234-55-122WshopWshop_7597Registered
1234-55-122KnoteKnote_7608Registered
4321-55-111DemoDemo_7592Cancelled

Upload the File

Registration Agenda Import Wizard

1. Select the type of data you'd like to import – Select " Registration Session Instances ". 2. Read the on-screen instructions about preparing your data. 3. Click Browse to locate the data file you want to import. 4. Select the Excel or CSV file and click Open. The name of the file is displayed as confirmation. 5. Click Upload. This uploads the file to Certain, but doesn't yet import it. The upload process may take a few minutes, depending on file size.

Mapping the fields

Import Registration Session Instances

A pop-up Import Registration Session instances window opens.

In that window, map the four database fields to the corresponding columns in the .csv file.

Click Import.

The data import is scheduled. You will receive an email when it is finished.

What happens when the import runs?

Source:

Keywords: Import Registration Session Instances, Registrations > Import, CSV