You are here: Integrations > Bulk Loader > Requirements for Bulk Loader Source Files > Course Creator Requirements

Course Creator Requirements

The Course Creator loader enables you to bulk-create new LearnCenter Courses or bulk-update existing Courses. You can also create Courses based on template Courses you have already created. This loader expects the following items to be preexisting to create LearnCenter (WYSIWYG) Courses:

Course Custom Fields
Electronic Signatures
Categories
Template Courses

Name

Text Editor	Column	Required	Notes
1	A	Yes	LearnCenter Course Name The name is the used to find existing courses
Accepted Values	Any Value up to 1000 characters in length.

Description

Text Editor	Column	Required	Notes
2	B	No	LearnCenter Course Description
Accepted Values	Any Value up to 4000 characters in length.

Include in LearnCenter Search

Text Editor	Column	Required	Notes
3	C	No	LearnCenter Course Description
Accepted Values	Yes = Sets the LearnCenter Course to be included in LearnCenter Search No = Sets the LearnCenter Course to NOT be included in LearnCenter Search Blank Column = Sets the LearnCenter Course to NOT be included in LearnCenter Search
Example: Yes Example: No

Display Electronic Signature Start of Course

Text Editor Column	Excel Column	Required	Notes
4	D	No	Electronic Signature Name
Accepted Values	Any Electronic Signature name
Example: Default - Will use the Default Electronic Signature Example: Demo Electronic Signature
	This field set the Electronic Signature for the beginning of the course only.

Display Electronic Signature End of Course

Text Editor Column	Excel Column	Required	Notes
5	E	No	Electronic Signature Name
Accepted Values	Any Electronic Signature name
Example: Default - Will use the Default Electronic Signature Example: Demo Electronic Signature
	This field set the Electronic Signature for the end of the course only

Display to Public

Text Editor Column	Excel Column	Required	Notes
6	F	No	Set the LearnCenter course to be displayed in the Public Catalog
Accepted Values	Yes = Sets the LearnCenter Course to be displayed in the Public Catalog No = Sets the LearnCenter Course to NOT be displayed in the Public Catalog Blank Column = Sets the LearnCenter Course to NOT be displayed in the Public Catalog
Example: Yes Example: No

Display Feedback Form

Text Editor Column	Excel Column	Required	Notes
7	G	No	Set the Feedback Form to be displayed to the user after the course
Accepted Values	Yes = Sets the Feedback Form to be displayed to user after the course No = Sets the Feedback Form to NOT be displayed to user after the course Blank Column = Sets the Feedback Form to NOT be displayed to user after the course
Example: Yes Example: No

Always Show Next Button

Text Editor Column	Excel Column	Required	Notes
8	H	No	Set to always show next button
Accepted Values	Yes = Set the course player to always show next button No = Set the course player to NOT show next button Blank Column = Set the course player to NOT show next button
Example: Yes Example: No

Center Navigation Buttons Only

Text Editor Column	Excel Column	Required	Notes
9	I	No	Set navigation button to center
Accepted Values	Yes = Set the course player to center navigation buttons No = Set the course player to not center navigation buttons Blank Column = Set the course player to not center navigation buttons
Example: Yes Example: No

Show Information Bar

Text Editor Column	Excel Column	Required	Notes
10	J	No	Set course player to show information bar
Accepted Values	Yes = Set the course player to show information bar No = Set the course player to not show information bar Blank Column = Set the course player to not show information bar
Example: Yes Example: No

Scoring Behavior

Text Editor Column	Excel Column	Required	Notes
11	K	No	Set course Scoring Behavior
Accepted Values	Always Update = Set to Always Update Retain Highest = Set to Retain Highest Retain First = Set to Retain First Blank or <null> = Inherited
Example: Always Update Example: Retain Highest Exmple: Retain First

Keep Session Alive

Text Editor Column	Excel Column	Required	Notes
12	L	No	Sets the Keep Session alive to active on Inactive
Accepted Values	Yes = Set Keep session alive to active No = Set Keep session alive to inactive Blank Column = Set Keep session alive to inactive
Example: Yes Example: No

Show Header

Text Editor Column	Excel Column	Required	Notes
13	M	No	Sets the Show Header in the Course Player
Accepted Values	Yes = Set Show Header to active No = Set Show Header to inactive Blank Column = Set Show Header to inactive
Example: Yes Example: No

Display Completion Certificate

Text Editor Column	Excel Column	Required	Notes
14	N	No	Sets the Display Course Completion Certificate for the course
Accepted Values	Yes = Set to display the Completion Certificate for the course No = Set to not display the Completion Certificate for the course Blank Column = Set to not display the Completion Certificate for the course
Example: Yes Example: No
	Mapping of a specific Completion Certificate is completed in the Control Panel – Advanced Learning - Certificates

Author

Text Editor Column	Excel Column	Required	Notes
15	O	No	Set the Course Author Standard Field
Accepted Values	Any value up to 50 characters
Example: Don Bircher

Series Name

Text Editor Column	Excel Column	Required	Notes
16	P	No	Set the Course Series Name Field
Accepted Values	Any value up to 50 characters
Example: Accounting Series

Series Number

Text Editor Column	Excel Column	Required	Notes
17	Q	No	Set the Course Series Number Standard Field
Accepted Values	Any value up to 50 characters
Example: Series 101

Course Level

Text Editor Column	Excel Column	Required	Notes
18	R	No	Set the Course Level field.
Accepted Values	Any value up to 50 characters
Example: Level 4

Credits

Text Editor Column	Excel Column	Required	Notes
19	S	No	Set the Course Credits Standard Field
Accepted Values	Numeric value from 0 to 9999999
Example: 10

Duration

Text Editor Column	Excel Column	Required	Notes
20	T	No	Set the Course Duration Standard Field
Accepted Values	Numeric value from 0 to 9999999
Example: 10

Publisher

Text Editor Column	Excel Column	Required	Notes
21	U	No	Set the Course Publisher Standard Field
Accepted Values	Any value up to 50 characters
Example: Published by ABC Company

Cost Per User

Text Editor Column	Excel Column	Required	Notes
22	V	No	Set the Course Cost Per User Standard Field
Accepted Values	Numeric value from 0 to 999999.
Example: 100

Course Number

Text Editor Column	Excel Column	Required	Notes
23	W	No	Set the Course Number Standards Field
Accepted Values	Any value up to 50 characters.
Example: The Course number is 101 Example: 101

Insert Existing Course

Text Editor Column	Excel Column	Required	Notes
24	X	No	Places the Course in the Warehouse or Showroom (Inserted into the LearnCenter)
Accepted Values	Yes = Puts (Inserts) the Couse into the Showroom No = Puts the Couse into the Warehouse Blank Column = Puts the Couse into the Warehouse
Example: Yes Example: No
	Using the update existing records, the course can be moved between the Warehouse and Showroom. Course must be in the Showroom (inserted into the LearnCenter) to report on progress for the course

Populate custom field default values

Text Editor Column	Excel Column	Required	Notes
25	Y	No	Populates custom fields with Default Values
Accepted Values	Yes = Populates custom fields with default values No = Does not populates custom fields with default values Blank Column = Does not populates custom fields with default values
Example: Yes Example: No
	If value is no then the loader will look to the Course Custom Fields column of the data file for Custom Field values

Course Custom Fields

Text Editor Column	Excel Column	Required	Notes
26	Z	No	Set the Course Custom Fields
Accepted Values	The Application can load data into as many custom fields as exist in the LearnCenter for LearnCenter Courses 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 field must exist in the LearnCenter The custom Fields for the Courses must be unique. If multiple custom fields (For the Course) with the exact same name exist, the application cannot determine which field to map the data to and will skip the field.
Example: Course Custom Field 01=Custom Data Set 01 Example: Course Custom Field 01=Custom Data Set 01;Course Custom Field 02=Custom Data Set 02;Course Custom Field 03=Custom Data Set 03
	Custom Field must exist and have unique names If more than one Course custom field is found with the same name this will be an error condition and outputted to the results file.

Template Course

28	AB	No	Creates the new course from an existing template LearnCenter Course
Accepted Values	Any Value up to 1000 characters in length
Example: Template Placeholder Course
	The Loader will create the new course from an existing LearnCenter course including the copying the HTML from the course Chapters and pages

27	AA	No	Set the Course 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 Course must be unique. If multiple Categories (For the Course) 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 be an error condition and outputted to the results file.