OPML Import and Export

This article explains how to configure OPML import and export tasks in PeopleFluent Learning V23 and older via the Manage Centre’s Background Task Console, detailing task setup, file directory structure, XML configuration, import/export types, and best practices for organizing different data types into separate folders to avoid processing errors.

Applicable Product:

PeopleFluent Learning

Applicable Release:

V23 and older

Go to Manage Center > Background Task Console and add a task:

Using user import as example

Task should be ‘Importer’

Frequency should be set as required.

Title can be anything.

Type must be usersCSV for user import (see below of other options).

XML URL needs to point to the directory where the csv import file will be stored

E-mail is the address of the user to be notified the process has run.

On saving this, a file will be created in C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\nts???\WEB-INF\confcalled imports-daily.opml

This should contain xml something like this:

<?xml version="1.0" encoding="UTF-8"?><opml version="1.0">

    <head>

        <title>EKP Imports</title>

    </head>

    <body>

        <outline title="EKP Imports">

            <outline email="" title="User Import 1520" type="usersCSV" user="ndadmin" xmlUrl="file:/C:/CSVUpload/OPML/Users/"/>

        </outline>

    </body>

</opml>

Create a user csv data load and save it to the directory set in the XML URL - C:/CSVUpload/OPML/Users/

When the task runs any csv files in the folder will be imported and the filename appended with .imported. This is so the file is not run again next time the OPML task runs.

Note: If there are other csv files (e.g. course csv upload) in the same folder NTS will also try to import them and fail because they are not the correct format. The file will still be appended with .imported.

For this reason different import types should be added to their own folders.

e.g.

C:/CSVUpload/OPML/Users/

C:/CSVUpload/OPML/Courses/

C:/CSVUpload/OPML/TrainingHistory/

And different upload types require their own task:

e.g. course import

Examples of other import ‘Types’ include:

organizationsCsv

trainingHistoryCsv

externalTrainingCsv

jobProfilesCsv

certificationCsv

OPML Export

Go to Manage Centre > Background Task Console and Add Task:

Using user export as example

Task should be ‘Exporter’

Frequency should be set as required.

Title can be anything.

Type must be usersCSV for user export (see below of other options).

XML URL needs to point to the directory where the csv import file will be stored.

NOTE: For exports you need to specify the filename – this can be anything.

E-mail is the address of the user to be notified the process has run.

On saving this, a file will be created in C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\nts???\WEB-INF\confcalled exports-daily.opml

This should contain xml something like this:

<?xml version="1.0" encoding="UTF-8"?><opml version="1.0">

<head>

<title>EKP Exports</title>

</head>

<body>

</outline>

</body>

</opml>

When the task runs the file is created:

Examples of other export ‘Types’ include:

trainingHistoryXml (Note that trainingHistoryCSV is not an export type)

usersXML

completedTrainingRecordsXml

Keywords:

OPML

Import

Export

Task