Checklist for Integrating Open content network(OCN) courses with SuccessFactors Learning (LMS) Part 1

This blog is to ensure that before and after integrating any open content network with LMS,the end-user and client gets the best experience possible

1) Course getting completed on launch

If In LMS OPEN CONTENT NETWORK settings, the default value for defaultValues.markCompleteOnLaunch[default] is true, then when you import OCN courses without changing the default value, the result will be end-user launching the course and it will get completed without them finishing it on the OCN course page. This will cause multiple learning history entries for the user for the item.
to remedy this you need to go to

Learning Adminstraiton > Configuration > System Configuration > OPEN CONTENT NETWORK
search defaultValues.markCompleteOnLaunch[default] and change the value to false before importing the courses from OCN.

Open%20Content%20Network%20Configration

Open Content Network Configration

2) Courses imported with complete on launch as default

This is the scenario where you or previous consultant working on the LMS system didn’t know the above setting and already imported multiple courses through Open Content Network,then you have 2 options

a)manually change complete Content on Launch settings for each item
Online%20content%20setting

Online content setting

b) use Item data connector and item module data connector

to do this you need the following columns for preparing the file

item data connector

CPNT_ID|CPNT_TYP_ID|REV_DTE|DMN_ID|NOTACTIVE|CPNT_TITLE|CMPL_STAT_ID|PARENT_MODULE_NAME!##!

Item module data connector

CPNT_ID|CPNT_TYP_ID|REV_DTE|APP_ID|COMPLETE_ON_LAUNCH!##!

Here is the explanation for each column and how you can get the necessary data for the same

First, you need to change your LMS time and date setting to UTC and follow a specific time and date pattern.

First go to Learning Administration > References > Calendars & Time > Date Format Patterns
and add this date and time format
Date : mmm-dd-yyyy (add new)
Time : HH:mm:ss (System type time pattern)

then add these patterns to English Locale
Learning Administration > References > Manage Labels > Locale > English > Date Pattern/Time Pattern

Select the newly created date and time format

while you are in this setting you can add multiple locales as per your OCN courses

Locales-Date

Locales-Date

Now go to Learning Administration > Preferences

Change timezone to Coordinated Universal Time (UTC) then Apply Changes
Date Pattern ID: mmm-dd-yyyy
Time Pattern ID: HH:mm:ss (HH24:MM:SS)

Preferances

Preferences

Now half work is done
go to Learning Administration > Report > item Data
download the report (report may fail so drill down the report with the revision date as the date you have imported the courses)

 

Using this report you can populate the item data and module data connector

CPNT_ID: Item ID (item id column can be copied here and you can use this for vlookup)

CPNT_TYP_ID: Item Type (as per OCN eg.CRSE in Linkedin)

REV_DTE: MMM-DD-YYYY HH:MM:SS (only this format and ensure to remove UTC from the file eg JAN-02-2022 14:10:17)

DMN_ID: Domain PUBLIC (until and unless other domain specified)

NOTACTIVE : N (applicable for Active courses)

CPNT_TITLE : Item Title

CMPL_STAT_ID:Completion status as per OCN (eg, CRSE-COMP in Linkedin)

PARENT_MODULE_NAME: Item Title(use item title here)

Make the item data connector file with

CPNT_ID|CPNT_TYP_ID|REV_DTE|DMN_ID|NOTACTIVE|CPNT_TITLE|CMPL_STAT_ID|PARENT_MODULE_NAME!##!

File name: item_data_customer.txt

Item module data connector

Use CPNT_ID,CPNT_TYP_ID, REV_DTE from above file

APP_ID: Content object id (you can make this using item id_1 eg LINKEDINLEARNING_10005_1)

COMPLETE_ON_LAUNCH:N(to stop the content getting completed when launched)
Make the item data module connector file with

CPNT_ID|CPNT_TYP_ID|REV_DTE|APP_ID|COMPLETE_ON_LAUNCH!##!

File name: item_module_data _customer.txt

Points to remember: for each locale(language)course you need to run this file separately
you can change the locale in Preferences and download the item data or item list report and build the connector file using that.

In the next blog, I will cover courses without item title, Automatically launch content when starting or resuming course, adding OCN courses to the library connector.
Part 2 can be access Here.

References
2432565 – Item Connector Not Updating Complete on Launch Field-LMS
2419830 – LMS OCN Open Content Network Knowledge Support and Tips