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.
Load a Batch Upload ILT Class File