LMS365 | Cloud Import Tool

This article is intended for users who want to import data like SCORM/AICC content packages, quizzes and question pools, learning modules, courses, historical training records incl. certificates to the LMS365 Cloud.

Before starting to import, you will need the latest Import Tool, please request it from the Support Team.

The data you want to import needs to be defined in Excel Data Files for each data type to be imported, which this article will explain and get you started. For more detailed information please read each section below.

Please be advised that the LMS365 Import Tool is being verified on the latest version of the LMS Suite.

AICC/SCORM Import

To import SCORM or AICC content packages, you need to create a data file with the packages to import, a folder with the .zip files, and then fill in some values in the configuration file.

First, create a folder in the DataFiles folder, called, for example, Scorms. In this folder, you should put .zip content packages (SCORMs and/or AICCs).

After that, you should create a Scorms.xlsx file. Please see details about the columns that should be included in this file in the table below. Optional columns can be empty or absent. When SCORM/AICC is imported with an empty or absent optional column – such option is Off or empty in the Content Packages Storage for imported SCORM/AICC on the Cloud side.

Column Name

Data Type

Details

Is Required

Title

Text

Specify the title of the imported package

Yes

Description

Text

Specify the description for the imported package

Yes

Content Type

Text

Should be filled with AICC or SCORM values (insensitive to register)

Yes

Zip Path

Text

Shows path to SCORM/AICC packages (in folder) that are imported to the LMS365 Cloud

Yes

Max number of attempts

Integer value

Can be specified either for SCORM or AICC

No

Timeout between attempts

Integer value

Can be specified either for SCORM or AICC

No

Open in new window

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified either for SCORM or AICC

No

Allow resume incomplete attempt

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified for SCORM

No

Use control mode flow for all nodes

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified for SCORM

No

Show statistics for learner

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified for SCORM

No

Show navigation buttons

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified for SCORM

No

Show Next button

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified for SCORM

No

Show Back button

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified for SCORM

No

Show Suspend button

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified for SCORM

No

Show Exit button

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified for SCORM

No

Show table of content

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified for SCORM

No

Show node completion status

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified for SCORM

No

Finish by lesson status

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified for SCORM

No

Redirect to statistics page when completed

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified for SCORM

No

Go to next SCO automatically

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified for SCORM

No

Treat complete as passed

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified for SCORM

No

Show Submit button

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified for AICC

No

Show title bar
 

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified either for SCORM or AICC

No

Automatically close the player

Boolean value; can be filled with yes/no, 1/0. True/False

Can be specified for AICC

No

 

Here is an example of the .xlsx file for importing 2 AICC/SCORM packages:

 

Title

Description

Content Type

ZIP Path

OneDrive_HTML5_AICC_2004_V6

AICC package description

Aicc

DataFiles\Scorms\OneDrive_HTML5_AICC_2004_V6.zip

LMS365_HTML5_SCORM_1.2_V6

SCORM package description

Scorm

DataFiles\Scorms\LMS365_HTML5_SCORM_1.2_V6.zip

 

After you have created the Scorms.xlsx file, put it in the DataFiles folder.

Now you can fill in the configuration file (called Elearningforce.LMS365.Import.Program). Please see the example in the “How to fill in the configuration file” section.

For the further steps, please see “How to run the tool” section.

Quizzes/Question Pools Import

A prerequisite for importing quizzes and question pools is an excel data file generated using the Import Tool. For more detailed information please read this section.

After generation, in the GeneratedDataFiles folder you will see folders with the images and .txt files as well as .xlsx files.

Please be advised that only images (added from local PC, from SharePoint or address) and embed code (e.g. YouTube or Vimeo video) can be generated within a quiz or a question pool.

Quizzes.xlsx file will have the following columns:

Column Name

Data Type

Details

Is Required

Title

Text

Title of the quiz that will be displayed in the Quiz Storage

Yes

Description

Text

Description of the quiz

No

Published

Boolean value; can be filled with yes/no, 1/0. True/False

Specifies whether the quiz will be published or not (unpublished quizzes are not displayed on MLWP)

No

Publishing start date

Numbers

Specifies quiz publishing start date (unpublished quizzes are not displayed on MLWP)

No

Publishing end date

Numbers

Specifies quiz publishing end date (unpublished quizzes are not displayed on MLWP)

No

Allow review

Boolean value; can be filled with yes/no, 1/0. True/False

Enables Learners to review their attempts

No

Randomize

Boolean value; can be filled with yes/no, 1/0. True/False

Randomizes questions during passing the quiz

No

Show timer

Boolean value; can be filled with yes/no, 1/0. True/False

Shows timer in the Quiz Player

No

Show correct answers

Boolean value; can be filled with yes/no, 1/0. True/False

Enables Learners to view correct answers in the Review mode

No

Show score

Boolean value; can be filled with yes/no, 1/0. True/False

Displays score in the Quiz Player

No

Max attempts

Numbers

Maximum number of attempts for the quiz

No

Passing percentage

Numbers

Passing score for the quiz

No

Time limit

Numbers

Sets time for passing the quiz

No

Questions

Path to the .txt file

.txt file contains Quiz questions converted to JSON

Yes

 

QuestionPools.xlsx file will have the following columns:

Column Name

Data Type

Details

Is Required

Title

Text

Title of the question pool that will be displayed in the Question Pool Storage

Yes

Description

Text

Description of the question pool

No

Categories

Text

Specifies categories of the question pool (separated by semicolon if needed)

Yes

Questions

Path to the .txt file

.txt file contains Question Pool questions converted to JSON

Yes

 

After you have a generated data file, put it in the DataFiles folder (along with the folder containing images if there are any and .txt files).

Now you can fill in the configuration file (called Elearningforce.LMS365.Import.Program). Please see the example in the “How to fill in the configuration file” section.

 

For the further steps, please see “How to run the tool” section.

Learning Modules Import

A prerequisite for importing learning modules is a set of excel data files generated using the Import Tool. For more detailed information please read this section.

After generation, in the GeneratedDataFiles folder you will see folders with the .txt, .xlsx, and other files. Along with the Learning Modules data file, Courses, Scorms, Quizzes, and Question Pools data files are generated.

The following items can be generated within a learning module: Content Packages (SCORM/AICC), Chapter, Content items, Documents (with link to documents), Files added from your local computer, and Quizzes.

LearningModules.xlsx file will have the following columns:

Column Name

Data Type

Details

Is Required

Title

Text

Title of the learning module

Yes

Description

Text

Description of the learning module

No

Published

Boolean value; can be filled with yes/no, 1/0. True/False

Specifies whether learning module is published or not (unpublished learning modules are not displayed on MLWP)

No

Start Date

Numbers

Should be specified according to the date format set in the configuration file

No

End Date

Numbers

Should be specified according to the date format set in the configuration file

No

Configuration

Path to the .txt file

.txt file contains learning module items converted to JSON

Yes

 

After you have a generated data file, put it in the DataFiles folder (along with the folder containing files and .txt files).

Now you can fill in the configuration file (called Elearningforce.LMS365.Import.Program). Please see the example in the “How to fill in the configuration file” section.

Please be advised that to import a learning module on the Cloud you need to import it with an associated course as it is a course-based item. If Content Packages or Quizzes (Question Pools if there are any questions in a quiz included from them) are included in the Learning Modules, they need to be imported along with the Learning Modules data files.

Courses Import

A prerequisite for importing courses is a SharePoint site with the created Course Catalog. If you have one, then you need to create a data file with the courses to import and fill in some values in the configuration file.

Please see details about the columns that should be included in the Courses.xlsx file in the table below. Optional columns can be empty or absent. When course is imported with an empty or absent optional column - such option is Off or empty on the Cloud side.

 

Column Name

Data Type

Details

Is Required

Title

Text

Title of the course that will be displayed in the Course List and on the Course Catalog

Yes

Short Description

Text

Short description of the course

Yes

Teachers

Text

Specify login(s) of Course Administrators or AD groups title(s) separated by semicolon if needed

Yes

Type

Text

Can be as follows: ELearning, ClassRoom, Webinar. Material courses from the On-Premises are generated as ELearning courses with a learning module.

Yes

Category

Text

Specify the category for the course (will be created on the Cloud side)

Yes

Culture

Text

Specify locale of Regional Settings, e.g. fr-FR

Yes

UI Culture

Text

Specify locale of Language Settings, e.g. es-ES

Yes

URL

Text

Specify relative URL for the imported course

Yes

Long Description

Text

Long description of the course

No

Enrollment Flow

Text

Can be as follows: Automatic Approval; Line Manager Approval; LMS Administrator Approval

No

Image Path

Text

Specify path to the course's image on your machine

 

Certificate Template

Text

Specify Template that physically exists on the Cloud side

No

Training Points

Numbers

Set training points for the course

No

Course Duration

Numbers

Set course duration, e.g. 45m

No

Course ID

Numbers

Specify course ID, e.g. 747354

No

Start Date

Numbers

Should be specified according to the date format set in the configuration file

No

End Date

Numbers

Should be specified according to the date format set in the configuration file

No

Due Date Enabled

Boolean value; can be filled with yes/no, 1/0. True/False

For e-Learning course type

No

Due Date Days

Numbers

For e-Learning course type; specify relative date counted from days after enrollment

No

Due Date Fixed

Numbers

For e-Learning course type; should be specified according to the date format set in the configuration file

No

Certificate Expiration Enabled

Boolean value; can be filled with yes/no, 1/0. True/False

Enable certificate expiration

No

Certificate Expiration Fixed

Numbers

Should be specified according to the date format set in the configuration file

No

Certificate Expiration Days

Numbers

Specify relative date counted from days after completion

No

Published

Boolean value; can be filled with yes/no, 1/0. True/False

Specify whether the course will be published or not

No

Show in Catalog

Boolean value; can be filled with yes/no, 1/0. True/False

Specify whether to show the course on the Course Catalog or not

No

Scorms

Text

Specify content packages’ titles set in the Scorms.xlsx separated by semicolon if needed (they need to be imported as well)

No

Complete by Scorms

Text

Set completion by content packages, specify title(s) separated by semicolon

No

Quizzes

Text

Specify quizzes’ titles set in the Quizzes.xlsx separated by semicolon if needed (they need to be imported as well)

No

Learning Modules

Text

Specify learning modules’ titles separated by semicolon if needed (they need to be imported along with the courses)

No

Complete by Learning Modules

Text

Set completion by learning modules; specify title(s) separated by semicolon. This column is filled automatically for generated from the On-Premises Material courses.

No

 

Here is an example of the .xlsx file for creating 1 course named New Course:

 

Title

Short Description

Teachers

Type

Category

Culture

UI Culture

URL

New Course

This is an imported course

aa@elearningforce.com

Webinar

Import

en-US

en-US

newcourse

 

Material courses generated from the On-Premises are present in the Courses.xlsx file as e-Learning courses with the specified associated Learning Modules. All Course Materials will be present in the Learning Module configuration file (.txt) along with the Confirmation item (simple checkbox or authorization). For the correct display of such courses, you need to import Courses.xlsx file together with the LearningModules.xlsx file.

After you have created the Courses.xlsx file, put it in the DataFiles folder.

Now you can fill in the configuration file (called Elearningforce.LMS365.Import.Program). Please see the example in the “How to fill in the configuration file” section.

For the further steps, please see “How to run the tool” section.

Certificates Import

A prerequisite for importing courses is a SharePoint site with the created Course Catalog. If you have one, then you need to create a data file with the certificates to import, a folder with the certificates images (if not using Cloud Certificate Templates), and fill in some values in the configuration file.

First, create a folder in the DataFiles folder, called, for example, Certificates. In this folder, you should put certificates images you want to import (we support the following image formats: .png, .jpg, .jpeg, .tiff, .gif, .pdf).

After that, you will need to create an .xlsx file. Please see details about the columns that should be included in the Certificates.xlsx file in the table below:

Column Name

Data Type

Details

Is Required

User Name

Text

Login of the user (certificate’s owner)

Yes

Course Title

Text

The title of the existing or non-existing course for which the certificate will be imported

Yes

Image Path

Text

Path to the images (certificates) in the Certificates folder

Yes

Issue Date

Numbers

Date of the course completion and certificate issued date (recommended format is used in the example below)

Yes

Expiration Date

Numbers

Date of the certificate expiration (use the same format as for the issued date)

No

Course Type

Text

Can be as follows: ELearning, ClassRoom, Webinar

Can be specified for the non-existing courses (if nothing is specified in this column for a non-existing course, it will be created as the e-Learning one). For already existing courses this field will not take affect

No

 

Here is an example of the .xlsx file importing 1 certificate for 2 different users:

User Name

Course Title

Image Path

Issue Date

Expiration date 

aa@elearningforce.com

Hardware & Systems Requirements Course

Certificates\1Certificate20112017.jpg

9/12/2017 9:00:00 PM

9/12/2018 9:00:00 PM

ab@elearningforce.com

Software Development Training

Certificates\2Certificate20112017.jpg

12/14/2017 12:50:19 PM

 

 

 

NOTE:

Instead of the Image Path, you can specify Certificate Template column (enter the title of the certificate template that physically exists on the Cloud side), e.g.:

User Name

Course Title

Certificate Template

Issue Date

Expiration date 

aa@elearningforce.com

Hardware & Systems Requirements Course

Default

9/12/2017 9:00:00 PM

9/12/2018 9:00:00 PM

 

 

There is also a possibility to import Certificates along with the achieved competencies. This can be done only by Certificates generation from the On-Premises. Additional ‘Competencies’ column will be specified in the Certificates.xlsx file, and Scale Sets and Competencies data files that need to be imported simultaneously will be generated. Please remember that only competencies granted by the external certificates can be generated and imported to the Cloud side and there is no possibility to import Scale Sets or competencies independently.

After you have created the Certificates.xlsx file, put it in the DataFiles folder.

Now you can fill in the configuration file (called Elearningforce.LMS365.Import.Program). Please see the example in the “How to fill in the configuration file” section.

For the further steps, please see “How to run the tool” section.

How to fill in the configuration file

The following values are required both for the courses and certificates import:

  • • DataFilePath – is a path to the excel file with a list of imported courses and their options or imported certificates depending on what you want to import.

  • • dateTimeFormat – key specifies Date format for uploading (we strongly recommend to use the following format: MM/dd/yyyy HH:mm:ss). If in the .xlsx file you use one data format and in the configuration file another one, the Import Tool will use format from the .xlsx file (if it is the default one: MM/dd/yyyy HH:mm:ss), otherwise, the format from the configuration file will be used for date recognizing;

  • • errorLogPath – key should be filled with the default value "ErrorLogs".

Pay attention to these required fields:

  • • courseCatalogUrl – the URL of site collection with the installed Course Catalog add-in and existing courses (it is also required for the Quiz/Question Pool import). Please do not use a slash (/) at the end of your relative Course Catalog URL.

  • • apiKey – API key initializes Tenant where courses are imported.

  • • containerSAS  temporary storage for upload.

  • • apiBaseAddress  API URL (see region based URL at http://api.365.systems/docs).

 

To get API key and containerSAS values, you need to send a request to the LMS365 Support (support@elearningforce.com).

NOTE:

For importing SCORM/AICC packages, you do not need to specify the Course Catalog URL as Content Packages are Tenant-based. You can as well not specify Time Format value.

 

Please see an example of the configuration file for importing courses and certificates below:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
   <startup>
      <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2" />
   </startup>
   <appSettings>
      <add key="remUrl" value="" />
      <add key="userMappingFilePath" value="" />
      <add key="coursesDataFilePath" value="DataFiles/Courses.xlsx" />
      <add key="scormsDataFilePath" value="" />
      <add key="questionPoolsDataFilePath" value="" />
      <add key="quizzesDataFilePath" value="" />
      <add key="certificateTemplatesDataFilePath" value="" />
      <add key="certificatesDataFilePath" value="DataFiles/Certificates.xlsx" />
<add key="learningModulesDataFilePath" value="" />
<add key="scaleSetsDataFilePath" value=" " />
<add key="competenciesDataFilePath" value="" />
      
<add key="errorLogPath" value="ErrorLogs" /> 
      <add key="generatedDataFilesPath" value="" />
      <add key="apiKey" value="Required value" />
      <add key="timeout" value="30" />
      <add key="dateTimeFormat" value="MM/dd/yyyy HH:mm:ss" />
      <add key="tenantDomain" value="lms365.elearningforce.com" />
      <add key="apiBaseAddress" value="Required value" />
      <add key="courseCatalogUrl" value="https://lms365.elearningforce.com/coursecatalog" />
      <add key="containerSAS" value="Required value" />
   </appSettings>
   <runtime>
       <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
           <probing privatePath="Libraries" />
       </assemblyBinding>
    </runtime>
</configuration>

 

You can run certificates, courses, content packages, quizzes/question pools, and learning modules import simultaneously by referring to all needed data files in the configuration file.

 

How to run the Tool

Any user can run Import Tool from any local PC. After you have filled in all necessary folders and values in the configuration file, run the Elearningforce.LMS365.Import.Program.exe. After that, you will be required to select how to import data to the LMS365 Cloud:

Рисунок 1

Select point 1 “Using data files”, and then enter “y” to confirm you are ready to start the importing process:

Рисунок 3

After the importing process has been finished, press any key to return to the menu of the Import Tool.
If something went wrong whilst importing, you can always see the log files in the Logs (errors of the tool) or ErrorLogs (if errors in the data files were found) folders.

How to migrate from LMS365 On-Premises

NOTE:

LMS365 Import Tool supports v. 4.8.3 of the LMS Suite (both SharePoint 2013 and SharePoint 2016).

 

To migrate your data from the LMS365 On-Premises to the LMS365 Cloud, you need to generate all the needed data files first. There are some prerequisites for exporting data from the On-Premises side:

  1. 1. Create a “GeneratedDataFiles” folder where all the needed data will be exported;

  2. 2. Fill in some required values in the configuration file:

    1. a. remUrl – specify the URL of the REM site from where the data will be exported;

    2. b. errorLogPathkey should be filled with the default value "ErrorLogs";

    3. c. generatedDataFilePath – key should be filled with the “GeneratedDataFiles” value.

  3. 3. For courses, certificates and export of all items, a prerequisite is a generated User Mapping data file (run the tool and select point 3 “Generate user mapping file”). After it is generated, you need to specify the path to it in the configuration file (userMappingFilePath key). User Mapping file is needed for associating the On-Premises accounts with the Cloud ones and specifying them in the Teachers column of the Courses.xlsx file and User Name column of the Certificates.xlsx file.

When generating the User Mapping file, you can face with some problems in resolving the accounts. Here is a list of possible reasons:

    1. a. a user is no longer in the AD – these records need to be removed from the file;

    2. b. a user got his/her login name changed – Cloud user login needs to be put in the file manually for such users;

    3. c. it is not possible to resolve User Principal Name for a user – Cloud user login needs to be put in the file manually for such users.

After everything is ready for exporting the data, you need to run the tool on the SharePoint server, and select point 2 “Generate data files”:

Рисунок 2

After that, please select the data type to be exported:

Рисунок 4

A folder with the exported data will be created in the GeneratedDataFiles folder. Now you can import data to the LMS365 Cloud using the instruction from the above sections.

Was this article helpful?
5 out of 5 found this helpful
Have more questions? Submit a request

Comments

Article is closed for comments.