SkillPort
 Print

Previous Topic

Next Topic

Courses Template

Use the Courses Template to upload course records quickly and easily. The table below shows the correct data format for each field in the template.

Field Name

Format

Course Title

Field is required. Field must be less than or equal to 255 characters.

Course ID

Field is required. Field must contain only alphanumeric characters or the '_' character and begin with ilt_.

Field must be less than or equal to 40 characters, and spaces are not allowed.

Status

Field is required. Field must be one of 0 or 1.

0 - deactivated

1 - activated

Language

Field is required. Field must be a valid language code (for example, en-us).

Duration

Field is optional. Field must be positive integer in the range 0-99999.

Mastery Level

Field is required. Field must be in the range 0-100.

Cost

Field is optional. Field must be a valid amount format according to currency specified and server locale.

Currency

Field is required. Field must be a valid currency code.

Manager Approval Required

Field is required. Field must be one of 0 or 1.

  • 0 - no
  • 1 - yes

Session Approval Required

Field is required. Field must be one of 0 or 1.

  • 0 - no
  • 1 - yes

Course Description

Field is optional. Field must be less than or equal to 3500 characters.

Course Administrator 1 User Name

Field is optional. Field must match an existing course administrator.

Course Administrator 2 User Name

Field is optional. Field must match an existing course administrator.

Course Administrator 3 User Name

Field is optional. Field must match an existing course administrator.

Session Approver User Name

Field is required if Session Approval Required has value 1. Field must match an existing session approver.

Contact Name

Field is optional. Field must match an existing contact or one in the contact upload file.

Instructor Can Manage Roster

Field is required. Field must be one of 0 or 1.

  • 0 - no
  • 1 - yes

Facility ID

Field is optional. Field must match an existing facility or one in the facility upload file.

Classroom ID

Field is optional. Field must match an existing classroom or one in the classroom upload file.

Close Session (days before/after session start)

Field is optional. Field must be in range {-90 -60 -45 (-30.0 to 30.0) 45 60 90}.

Prohibit Self-Withdrawal (days before session start)

Field is optional and can be one of the following:

  • leave blank (renders a value of Never)
  • always
  • a number from 1 to 31

Late Withdrawal (days before session start)

Field is optional and can be one of the following:

  • leave blank (renders a value of Never)
  • a number from 1 to 31

Minimum Enrollment

Field is optional. Field must be in range 0-99999.

Low Enrollment Alert (days before session start)

Field is optional. Field must be (never) or from 0 to 31.

san1

Field is required. Field must match an existing item in the extended attribute list.

san2

Field is required. Field must be less than or equal to 250 characters.

san3

Field is required. Field must match an existing item in the extended attribute list.

2

Field is optional. Field must match an existing item in the extended attribute list.