Create a Batch Upload for ILT Classes

Use Microsoft Excel to create a data file for uploading class session data to the system. The file must be laid out exactly as defined below for the data to be read by the LMS on upload.

The data file you upload must be saved as a tab-delimited file.

Column Data Description

A

Course

The title or resource ID of the learning resource that this class will be associated with. When provided with a title, the system will try to match the title with one on file, and may fail if this field does not exactly match. When provided the resource ID, the system will use this value as the unique identifier for the course.

B

Class Date

Start date of the class, MM/DD/YYYY format.

C

End Date

End date of the class, MM/DD/YYYY format.

Optional. If blank, the system will assume the start date and end date are the same.

D

Class Start Time

Starting time of the class. Time format can be entered as 9:00 AM or 9:00

E

Class End Time

Ending time of the class. Time format can be entered as 4:00 PM or 16:00

F

Time Zone

Optional. Time Zone in which the class session is held. Use the time zone abbreviation (such as EST, CT) as defined in the time zone drop down menu in Maintain Facilitated Sessions.

G

Venue

Venue in which the class session is held - Optional. The text should match the text of the existing venues in your system.

H

City

City in which the class session is held - Optional.

This field should only be used in systems that DO NOT use venues. If your system uses venues, all relevant information should be entered there.

I

State

State in which the class session is held - Optional.

This field should only be used in systems that DO NOT use venues. If your system uses venues, all relevant information should be entered there.

J

Instructor

The employee number of the instructor who will lead the class. If left blank, no instructor will be imported.

K

Training Coordinator

The employee number of the training coordinator for the class. If left blank, no training coordinator will be imported.

L

Facility Coordinator

The employee number of the Facility Coordinator for the class. If left blank, no facility coordinator will be imported.

M

Participant

Participant’s employee number.

N

Credit

Y/N to grant credit. If an "N" is provided, the participant will be enrolled in the class session, but not credit granted for the class.

O

Time

The amount of time, in minutes, that will be granted for participation. If left zero, the system will default to the amount of time that’s specified for the learning resource on the Overview panel of Maintain Learning Resources.

NOTE: If a particular data field is not used, just leave that column blank. The LMS is looking for specific data in specific rows.

Related

Overview

Load a Batch Upload ILT Class File