You are here: Integrations > Bulk Loader > Requirements for Bulk Loader Source Files > ILT Data Requirements

ILT Data Requirements

Use the information in the following tables to help you enter data in the downloaded Bulk Loader Source File templates.

CollapsedClick here to see an illustration of the Session Information page with each field labeled by its corresponding Microsoft® Excel column letter. Alternatively, you can click the column letter in the tables below to open this illustration for viewing.
CollapsedClick here to see an illustration of the Session Information page with each field labeled by its corresponding Microsoft® Excel Text Editor number. Alternatively, you can click the Text Editor Number in the tables below to open this illustration for viewing.

Each field is detailed in the following tables. Click the Text Editor number or Column letter hyperlinks to where each field is on the Session Information page.

Bulk Loader data files do not support characters with the grave accent.

ILT Event Name

Text Editor Column Required Notes
1 A Yes ILT Event Name
Accepted Values Any Value up to 1000 characters in length.

ILT Event Status

Text Editor Column Required Notes
2 B Yes ILT Event Status
Accepted Values
  • Active = Sets the ILT Event to Active
  • Inactive = Sets the ILT Event to Inactive
  • Example: Active
  • Example: Inactive

ILT Event Description

Text Editor Column Required Notes
3 C No ILT Event Description
Accepted Values Any Value up to 1000 characters in length.

ILT Track

Use the following to help you enter ILT Track data.

ILT Track Name

Text Editor Column Required Notes
4 D Yes ILT Track Name
Accepted Values

Any Value up to 2000 characters in length.

ILT Track Status

Text Editor Column Required Notes
5 E Yes ILT Track Status
Accepted Values
  • Active = Sets the ILT Event to Active
  • Inactive = Sets the ILT Event to Inactive
  • Example: Active
  • Example: Inactive

ILT Track Description

Text Editor Column Required Notes
6 F No ILT Track Description
Accepted Values

Any Value up to 1000 characters in length.

ILT Session: Creating ILT Session that are Mapped to ILT Events and Tracks

Use the following to help you enter ILT Session data. When creating ILT Sessions that are mapped to ILT Events and Tracks, each row of the data file should contain the ILT Event and ILT Track information that the session to which it is mapped.

ILT Session Name

Text Editor Column Required Notes
7 G Yes ILT Session Name
Accepted Values

Any Value up to 500 characters in length.

ILT Session Status

Text Editor Column Required Notes
8 H Yes ILT Session Status
Accepted Values
  • Active = Sets the ILT Event to Active
  • Inactive = Sets the ILT Event to Inactive
  • Example: Active
  • Example: Inactive

ILT Session Description

Text Editor Column Required Notes
9 I No ILT Session Description
Accepted Values

Any Value up to 3000 characters in length

ILT Session: Creating ILT Quick Session

When creating ILT Quick Sessions, the ILT Events and ILT Tracks fields should be left blank. LearnCenter identifies these blanks as ILT Quick sessions. Your data file should have the ILT Event and ILT Track information BLANK in each row.

ILT Session Name

Text Editor Column Required Notes
7 G Yes ILT Session Name
Accepted Values

Any Value up to 500 characters in length

ILT Session Status

Text Editor Column Required Notes
8 H Yes ILT Session Status
Accepted Values

Active = Sets the ILT Event to Active

Inactive = Sets the ILT Event to Inactive
  • Example: Active
  • Example: Inactive

ILT Session Description

Text Editor Column Required Notes
9 I No ILT Session Description
Accepted Values Any Value up to 3000 characters in length

ILT Session Information

The following applies to ILT Sessions that are mapped to ILT Events and ILT Tracks, as well as ILT Quick Sessions.

Include in LearnCenter Search

Text Editor Column Required Notes
10 J No Set the ILT session to be included in the Learn Advanced Search.
Accepted Values
  • Yes = Sets the ILT Session to be included in LearnCenter Search
  • No = Sets the ILT Session to NOT be included in LearnCenter Search
  • Blank Column = Sets the ILT Session to NOT be included in LearnCenter Search
  • Example: Yes
  • Example: No

ILT Session Minimum Seats

Text Editor Column Required Notes
11 K Yes Set the ILT Session Minimum Seats
Accepted Values
  • Accepted Values Any whole number numeric value between 1 and 9999.
  • The default is 0.

Example: 5

ILT Session Maximum Seats

Text Editor Column Required Notes
12 L Yes Set the ILT session Maximum Seats
Accepted Values
  • Any whole number numeric value between 1 and 9999.
  • The default is 30.
Example: 45

ILT Session Prework

Text Editor Column Required Notes
13 M No Set the ILT Session Prework
Accepted Values Any value up to 5000 characters.
Example: This is the session pre work.

ILT Session Outline

Text Editor Column Required Notes
14 N No Enter the ILT Session Outline
Accepted Values

Any value up to 5000 characters.
Example: This is the Session Outline.

ILT Session Start Date

Text Editor Column Required Notes
15 O Yes Set the ILT Session Start Date
Accepted Values
  • A date format must be posted in the mm/dd/yyyy format
  • mm = Two digit month dd = Two digit Day yyyy = Four digit Year
  • The date will appear based on the system setting

IMPORTANT: This date format must be used even if it is not the standard date format in the country where a User is located. Even if you live in a country where DD/MM/YYYY is the standard format, you must use MM/DD/YYYY in the .TXT file in order to avoid errors and result in a successful import. The uploaded dates in the ILT Sessions will display to end Users based on the LearnCenter or User preferences for the date format.
Example: 03/01/2015
See Requirements for Bulk Loader Source Files for information on formatting dates.
Custom Excel Field Type Format: mm/dd/yyyy

ILT Session Start Time

Text Editor Column Required Notes
16 P Yes ILT Session Start Time
Accepted Values
  • A Time format must be posted in the hh:mm AM/PM in 15 minute intervals.
  • hh = Two digit hour mm = Two digit minute AM or PM
  • The time will appear based on the system setting
Example: 08:15 AM
See Requirements for Bulk Loader Source Files for information on formatting dates.
Custom Excel Field Type Format: hh:mm AM/PM

ILT Session End Date

Text Editor Column Required Notes
17 Q Yes ILT Session End Date
Accepted Values
  • A date format must be posted in the mm/dd/yyyy format
  • mm = Two digit month dd = Two digit Day yyyy = Four digit Year
  • The user date will appear based on the system setting

IMPORTANT: This date format must be used even if it is not the standard date format in the country where a User is located. Even if you live in a country where DD/MM/YYYY is the standard format, you must use MM/DD/YYYY in the .TXT file in order to avoid errors and result in a successful import. The uploaded dates in the ILT Sessions will display to end Users based on the LearnCenter or User preferences for the date format.
Example: 03/01/2015
See Requirements for Bulk Loader Source Files for information on formatting dates.

ILT Session End Time

Text Editor Column Required Notes
18 R Yes Set the ILT Session Start Time
Accepted Values
  • A Time format must be posted in the hh:mm AM/PM in 15 minute intervals.
  • hh = Two digit hour mm = Two digit minute AM or PM
  • The time will appear based on the system setting
Example: 04:30 PM
See Requirements for Bulk Loader Source Files for information on formatting dates.

ILT Session Time Zone

Text Editor Column Required Notes
19 S No Set to use the ILT Session Time Zone
Accepted Values
  • A time zone posted in the LearnCenter format.
  • If no time zone is entered in the data file the session will be set to the system default.
  • The time zone will appear based on the system setting
Example: Eastern Standard Time
See Bulk Loader and Time Zone Requirements for specific time zone data requirements.

ILT Session Observes Daylight Saving

Text Editor Column Required Notes
20 T No Set the checkbox in the ILT Session for Observes Daylight Saving
Accepted Values
  • Yes = Sets the ILT Session to Observes Daylight Saving
  • No = Sets the ILT Session to NOT Observes Daylight Saving
  • Blank Column = Sets the ILT Session to NOT Observes Daylight Saving
  • Example: Yes
  • Example: No

ILT Session Always show time zone

Text Editor Column Required Notes
21 U No Set the check box in the ILT Session to always show time zone
Accepted Values
  • Yes = Sets the ILT Session to show time zone
  • No = Sets the ILT Session to NOT show time zone
  • Blank Column = Sets the ILT Session to NOT show time zone
  • Example: Yes
  • Example: No

Author Series Name

Text Editor Column Required Notes
22 V No Set the ILT Session Author
Accepted Values

Any value up to 50 characters
Example: Don Bircher

Series Number

Text Editor Column Required Notes
23 W No Set the ILT Session Series Number
Accepted Values

Any value up to 50 characters

Example: Series 101

Course Level

Text Editor Column Required Notes
25 Y No Set the ILT Session Series Number
Accepted Values

Any value up to 50 characters
Example: Series 101

Credits

Text Editor Column Required Notes
26 Z No Set the ILT Session Credits
Accepted Values

Numeric value from 0 to 9999999
Example: 10

Duration

Text Editor Column Required Notes
27 AA No Set the ILT Session Duration
Accepted Values

Numeric value from 0 to 99999999
Example: 10

Publisher

Text Editor Column Required Notes
28 AB No Set the ILT Session Publisher
Accepted Values

Any value up to 50 characters
Example: Published by ABC Company

Cost Per User

Text Editor Column Required Notes
28 AC No Set the ILT Session Cost Per User
Accepted Values

Numeric value from 0 to 999999
Example: 100

Course Number

Text Editor Column Required Notes
30 AD No Set the ILT Session Course Number
Accepted Values

Any value up to 50 characters
  • Example: The Course number is 101
  • Example: 101

ILT Session Custom Fields

Text Editor Column Required Notes
31 AE No Set the ILT session Custom Fields
Accepted Values
  • The Application can load data into as many custom fields as exist in the LearnCenter for ILT Sessions
  • For format if the data in the column: <custom field name>=<custom field data>
  • Each custom field mapping is separated by a semicolon ;
  • The custom fields must exist in the LearnCenter
  • The custom Fields for the ILT Session must be unique.
  • If multiple custom fields (For the ILT Session) with the exact same name exist, the application cannot determine which field to map the data to and will skip the field.
  • Example: ILT Session Custom Field 01=Custom Data Set 0
  • Example: ILT Session Custom Field 01=Custom Data Set 01;ILT Session Custom Field 02=Custom Data Set 02;ILT Session Custom Field 03=Custom Data Set 03
Custom fields must exist and have unique names. If more than one ILT Session custom field is found with the same name, this will be an error condition and outputted to the results file.

Show Event Information

Text Editor Column Required Notes
32 AF No Set the checkbox in the ILT Session for Show Event Information.
Accepted Values

Yes = Sets the ILT Session to Show Event Information

No = Sets the ILT Session to NOT Show Event Information

Blank Column = Sets the ILT Session to NOT Show Event Information

Example: Yes

Example: No

Show Track Information

Text Editor Column Required Notes
33 AG No Set the checkbox in the ILT Session for Show Track Information.
Accepted Values
  • • Yes = Sets the ILT Session to Show Track Information
  • • No = Sets the ILT Session to NOT Show Track Information
  • Blank Column = Sets the ILT Session to NOT Show Track Information
  • Example: Yes
  • Example: No

Show Instructors

Text Editor Column Required Notes
34 AH No Set the checkbox in the ILT Session for Show Instructors
Accepted Values
  • Yes = Sets the ILT Session to Show Instructors
  • No = Sets the ILT Session to NOT Show Instructors
  • Blank Column = Sets the ILT Session to NOT Show Instructors
  • Example: Yes
  • Example: No

Show Location Information

Text Editor Column Required Notes
35 AI No Set the checkbox in the ILT Session for Show Location Information
Accepted Values
  • Yes = Sets the ILT Session to Show Location Information
  • No = Sets the ILT Session to NOT Show Location Information
  • Blank Column = Sets the ILT Session to NOT Show Location Information
  • Example: Yes
  • Example: No

Prerequisites

Text Editor Column Required Notes
36 AJ No Set the ILT Session Prerequisites
Accepted Values
  • The Application can load data into as many Prerequisites as required
  • There can be multiple Prerequisites for a Session
  • There are operators between them for and / or Conditions
  • Prerequisites can be optional or mandatory
  • For format if the data in the column: <item type>=<item name>;<mandatory / optional>;operator
  • Each Prerequisites mapping is separated by a semicolon ;
  • The Training Items for the Prerequisites must exist in the LearnCenter
  • Item Type supported for Prerequisites mapping:
  • Assignment
  • Class
  • Course
  • Enrollment
  • ILT Session
 
  • Example: Course=Active Listening;Mandatory
  • Example: Course=Active Listening;Mandatory;and;Assignment=Create ILT Loader PPT;Optional
  • Example: Course=Active Listening; Optional;or;Assignment=Code of Conduct;Mandatory;and;Assignment=Create ILT Loader PPT;Optional
  • Example: Course=15A COURSE 1;Optional;OR;Class=Becoming a Manager;Mandatory;AND;Course=15A COURSE 5;Mandatory
The content for the Prerequisites must exist for them to be mapped to the ILT Session.

ILT Session Categories

Text Editor Column Required Notes
37 AK No Set the ILT Session Categories
Accepted Values
  • The Application can load data into as many Categories root and sub-categories as exist in the LearnCenter for ILT Sessions
  • For format if the data in the column: < category name>;< category name>
  • Each Categories mapping is separated by a semicolon ;
  • The Categories must exist in the LearnCenter
  • The Categories names for the ILT Session must be unique.
  • If multiple Categories (For the ILT Session) with the exact same name exist, the application cannot determine which field to map the data to and will skip the field.
  • Example: Root Categories 01
  • Example: Root Categories 01;Root Categories 02;Root Categories 03
  • Example: Root Categories 01;Root Categories 02; Sub Categories 03;Sub Categories 04
Categories must exist and have unique names. If more than one Category is found with the same name, this will result in an error condition and that will be outputted to the Results File.

ILT Session Instructors

Text Editor Column Required Notes
38 AL No Set the ILT Session Instructors
Accepted Values
  • The Application can load data into as many Instructors required ILT Sessions
  • For format if the data in the column: <instructors username>;< instructors username >
  • Each Instructors mapping is separated by a semicolon ;
  • The uses must be made Instructors in the LearnCenter
  • The Instructors are found by the application by their username
  • Example: DBIRCHER
  • Example: DBIRCHER;MGOLDBERG
Users must be made Instructors in the LearnCenter to be mapped to the Session as Instructors.

ILT Session Location

Text Editor Column Required Notes
39 AM No Set the ILT Session Location
Accepted Values
  • The Location are found by the application by their location name.
  • If multiple Locations with the exact same name exist, the application cannot determine which field to map the data to and will skip the field.
  • Example: Location 01
  • Example: Columbus Ohio Office
The Location must exist in the LearnCenter to be mapped to the ILT Session.

ILT Session Room

Text Editor Column Required Notes
40 AN No Set the ILT Session Room
Accepted Values
  • LearnCenter finds Rooms by their room name.
  • If multiple Rooms with the exact same name exist, LearnCenter will not be able to determine which field to map the data to, and it will skip the field.
  • Example: Room 01
  • Example: Room 2087
The Location must exist in the LearnCenter to be mapped to the ILT Session.

ILT Session Assets Materials

Text Editor Column Required Notes
41 AO No Set the ILT Session Categories
Accepted Values
  • The Application can load data into as many Assets/Materials as required
  • For format if the data in the column: < asset/ material name>;< asset/material name>
  • Each Assets/Materials mapping is separated by a semicolon ;
  • The Assets/Materials must exist in the LearnCenter
  • The Assets/Materials names must be unique.
  • If multiple Assets/Materials with the exact same name exist, LearnCenter will not be able to determine which field to map the data to, and it will skip the field.
  • Example: Assets 01
  • Example: Projector;White Board
Assets/Materials must exist and have unique names

Related Topics IconRelated Topics

 

Copyright © 2010-2018, Oracle and/or its affiliates. All rights reserved.