OPML Import and Export
Applicable Product:
- PeopleFluent Learning
Applicable Release:
- V23 and older
Summary:
Go to Manage Centre > Background Task Console and Add 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 title="EKP Exports">
<outline email="" title="Users CSV" type="usersCsv" user="ndadmin" xmlUrl="file:/C:/OPML/Export/users.csv"/>
</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
organizationsCsv
trainingHistoryCsv
externalTrainingCsv
jobProfilesCsv
certificationCsv
Created : Simon Mawer
Reviewed: Reviewer Name & date reviewed