Events > Working with Events > Scheduling Events > Bulk Import for Classroom Events & Webinars

Adding multiple events to the LMS calendar through a bulk import is straightforward when you follow a few basic guidelines and use the correctly formatted Blank Import Events Spreadsheet Template.

Sample Completed Import Events Spreadsheet

Sample Completed Import Events Spreadsheet

The Import Events feature is available to administrators and those with permission to create calendar events. The LMS supports events that occur within a single day and can include one or more locations and/or a single webinar. The import events feature can also generate a Teams meeting link if the feature has been enabled for the environment. (see Teams Teams Integration Technical Requirements)

Use the guide below to complete the Import Events Spreadsheet Template and successfully import your events into the LMS.

How to Bulk Import Events

1.Download the Blank Import Events Spreadsheet Template.

2.Complete the template with your event details, using the sample spreadsheet and guidelines below as a reference.

3.Navigate to Calendar > 3-dot menu > Import Events.

4.Click Select and choose the completed spreadsheet from your device.

5.Click Upload to import the events into the LMS calendar.

Import Events File Format and Guidelines

Field	DataType	MaxLength	Required?	Notes
1. EventNumber	Number		N	Used for importing an Event group; multi-location events or events with Webinar AND Location(s). The actual number supplied is not important, what is important is that the same number is used for all event locations/webinar in that event group. The Event number must be unique for each group represented in a single spreadsheet, but can be reused for other imports.
2. CourseIdentifier	String	22	Y	Must match the CourseID of an Active Scheduled Course that exists in the LMS.
3. EventName	String	200	N	If not supplied we will use the Course Name
4. EventDescription	String	Unlimited	N	If not supplied we will use the Course Description
5. StartDateTime	Date		Y	This should be defined for the time zone defined in the Location. Multi-location events will use the time zone of the first specified Location in the group of events. If the first specified Location is Webinar we will use the time zone of the FirmWide Location. Use mm/dd/yyyy hh:mm format.
5. EndDateTime	Date		N	If not supplied, we will use the default Duration defined in the Course. If supplied, this should be defined for the time zone defined in the Location. Multi-location events will use the time zone of the first specified Location in the group of events. Use mm/dd/yyyy hh:mm format.
6. LocationName	String	64	Y	Must match the Location name of an Active Location that exists in the LMS or if 'Webinar' is entered this will be equivalent to checking the 'Webinar' check-box when manually adding an event in the LMS Calendar.
7. VenueName	String	64	N	Must match the Venue name of an Active Venue that is assigned to the Location specified
8. Capacity	Number		N	If not supplied, we will use the default defined in the Course for the Event size
9. EnrolmentOpenDays	Number		N	If not supplied, we will use the default defined in the Course
10. EnrolmentClosesMinutes	Number		N	If not supplied, we will use the default defined in the Course. This must match what CFMs see in the drop-down in the LMS. Valid values are any of the following: 0, 5, 10, 15, 30, 60, 120, 240, 480, 1440, 2880, 4320, 5760, 7200, 8640, 10080, 20160, 30240, 40320
11. EventContactClientUserIdentifiers	String		N	This can be a comma delimited list of Client User Identifiers of your Active Contacts that exist in the LMS
12. WebinarURL	String	500	N
12. WebinarMeetingNumber	String	50	N
12. WebinarPassword	String	50	N
12. WebinarPresenterMeetingNumber	String	50	N
12. WebinarPresenterPassword	String	50	N
12. WebinarAudioInformation	String	500	N
13. IsTeamsMeeting	String	3	N	Used to generate Teams meeting link for Event. Enter "Yes" if it is a Teams meeting. Leave blank if no Teams meeting link is required.

Notes:

•Certificates for imported events will be assigned based on the associated course certificate.

•Surveys for imported events will be assigned based on the associated course survey.

•Venue conflict checks are performed.

•Contact conflict checks are performed.

•Critical Errors - If any critical errors occur during the process, the import will be aborted and no events will be imported.

•Warnings - The LMS will attempt to import all records that have no warnings. Warnings will display in a banner on the import page after an attempted import. Those records that have warnings will not be imported. Where an event is part of an Event Group (indicated by specifying EventNumber) all elements within that Event Group must pass validation. If a single element fails validation the Event Group will not be imported.