Populating the Import Courses sheet

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

Populating the Import Courses sheet

You will need to populate the Import_Courses.xlsx template with the Course information, following the instructions below.

TPArrowPay particular attention to the Mandatory column.

Column

Column Heading

Mandatory

Is there specific data required?

What if I leave this blank?

A

CourseID

Y

Can be up to 22 characters and can contain any of the following: A to Z (upper or lower) 0 to 9 _ - &

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. Please use the number:

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

 

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

If not, it the import will fail.

J

DurationUnit

Y

Specify H for Hours or 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

The exact name of the zip file. Each zip file 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:

A for Active or

I for Inactive

Import will fail.

*  If you have sub-folders beneath Courses you must specify the entire folder structure after /Courses/ in the ZipFile column, as in the highlighted example below.

** Keywords can also be imported directly from the file's metadata for General and Resource courses only.

 

Import/ABCFirm/Courses/Office2016/Word2016/01_Top 10 Things to Know about NetDocuments 17.2 Knowledge Check.zip

Populating Import Courses Sheet - Clip 1 2020-09-23_16-48-58