A

CourseID

Y

Yes. The value can be up to 22 characters and may contain any of the following characters: Letters A-Z; Numbers 0-9; Underscore ( _ ) ; Hyphen ( - ) , Ampersand ( & ).

Import will fail.

B

CourseName

Y

Retrieved from the content package, if supplied.

If not, the import will fail.

C

CategoryName

N

We will get from the Course Type Defaults, if supplied.

If not, it will be left blank.

D

CourseSubcategoryName

N

We will get from the Course Type Defaults, if supplied.

If not, it will be left blank.

E

SubSubCategoryName

N

It will be left blank.

F

CourseTypeCode

Y

Yes. Use the following numeric values:

5 for AICC

7 for SCORM

3 for General

0 for Resource

Import will fail.

G

DeliveryName

Y

We will get from the Course Type Defaults, if supplied.

If not, the import will fail.

H

SubDeliveryName

Y

We will get from the Course Type Defaults, if supplied.

If not, the import will fail.

I

Duration

Y

Enter the duration as a numeric value using General cell formatting (i.e. 1, 1.5, 3.25)

We will get from the Course Type Defaults, if supplied.

If not, it the import will fail.

J

DurationUnit

Y

Use the DurationUnit column to specify the unit:

H for Hours; M for Minutes

We will get from the Course Type Defaults, if supplied.

If not, the import will fail.

K

VendorName

N

We will get from the Course Type Defaults, if supplied.

If not, it will be left blank.

L

Description

N

We will get from the content package, if supplied.

If not, it will be left blank.

M

**Keywords

N

We will get from the content package, if supplied.

If not, it will be left blank.

N

ZipFile

One of these must be provided

Enter the exact name of the ZIP file. Each ZIP file name must be unique.

For example:

Excel 2016 Fundamentals.zip

*see below

Import will fail.

O

LaunchURL

The full URL. For example:

https://www.intellek.io

Import will fail.

P

RecordStatus

Y

Yes. Specify one of the following:

A for Active or

I for Inactive

Import will fail.

Q

IsTrackedInCEManager

N

Enter Yes or leave the field blank.

Used to indicate course is tracked in CE Manager. Leave blank if course in not tracked.