This provider generates a data report containing Learning Object metadata. The following columns for each Learning Object can be included in this report.
All the metadata fields specific to a version of a resource (ex: title, code, tags, authors) will return the value of the field for the best version according to the context (version must be active, and can depend on the preferred locales from the export's parameters).

Available columns

Name Type Description
learningObjectAssignements int The number of tracking rows associated with this learning object.
learningObjectAuthorFirstName string The first name of the author of the learning object.
learningObjectAuthorId int The ID used by the database to identify the author of the learning object.
learningObjectAuthorLastName string The last name of the author of the learning object.
learningObjectAuthorsFullNames string The full name (first name + last name) of the author(s) of the learning object. Values separated by commas.
learningObjectAuthorsIds string The internal GUID used to identify the author(s) of the learning object. Values separated by commas.
learningObjectAverageCompletionTime int The average time spent by learners of the learning object.
learningObjectAverageScore float The average rating of the learning object.
learningObjectCode string The reference number of the learning object.
learningObjectCompletions int The number of tracking rows associated with the learning object which are completed.
learningObjectCreationDate datetime The creation date of the learning object.
learningObjectDisplayedType string(50) The type (interactive content, audio, image, ...) of the learning object.
learningObjectDuration int The duration of the learning object (in minutes).
learningObjectFirstLaunchDate datetime The date at which the learning object has been launched for the first time.
learningObjectGuid string(40) The GUID of the learning object.
learningObjectId int The ID used by the database to identify the learning object.
learningObjectIncludedInLO longtext Metadata field 'Included in this learning product' of learning object.
learningObjectLastLaunchDate datetime The date at which the learning object has been launched for the last time.
learningObjectLearningPoints longtext Metadata field 'What you will learn' of learning object.
learningObjectLevel enum(0, 1, 2, 3) The level of the learning object.
learningObjectLocales string The locales in which the learning object is available.
learningObjectModificationDate datetime The last modification date of the learning object.
learningObjectNbOfComments int The number of comments for the learning object.
learningObjectNbTimesFavorited int The number of times the learning object has been added to a favorite list by a learner.
learningObjectPublisher datetime The publisher of the learning object.
learningObjectRatingByLearners float The rating given by the learners on the learning object.
learningObjectRatingDisplayed float The rating that is displayed on the learning object.
learningObjectRatingNbByLearners int The number of rating votes by learners on the learning object.
learningObjectRatingNbDisplayed int The displayed number of rating votes by learners on the learning object.
learningObjectSummary longtext The summary (description) of the learning object.
learningObjectTags longtext The tags associated to the learning object.
learningObjectTargetAudience longtext The target audience of the learning object.
learningObjectThemes longtext The themes of the learning object.
learningObjectThumbnailLarge url The URL to the large-sized thumbnail of the learning object.
learningObjectThumbnailMedium url The URL to the medium-sized thumbnail of the learning object.
learningObjectThumbnailSmall url The URL to the small-sized thumbnail of the learning object.
learningObjectTitle string The title of the learning object.
learningObjectTotalTimeSpent int The total time spent on the learning object by all learners of the platform (in minutes).
learningObjectType string(50) The runtime (SCORM, MP4, AICC, ...) of the learning object.
learningObjectViewsByLearners int The number of views of the learning object.
learningObjectViewsDisplayed int The displayed number of views of the learning object (real view by learners + fake views added in the back-office).

Filters and parameters

Name Type Description
dateFormat string Format for dates in the exported data. When not specified, the default date format is `YYYY-MM-DD`.
dateTimeFormat string Format for dates in the exported data. When not specified, the default value is `YYYY-MM-DD hh:ii:ss`.
maxLength int If not empty, this option will crop each value to the specified max length (each cell, not each line).
onlyHrisSelectedItems string Only export results defined in the BO of the CKLS for the HRIS connector.
@see on Techwiki
preferredLocales string The comma-separated list of preferred locales.
stripHTML string If not empty, this option will remove any HTML tag from the exported data.
templates templates The definition of a dynamic template, to allow to customize the returned value for a column. It also allows to combine the values of several columns into one.
timeFrames timeFrameScale Once a learner has completed a learning object or activity, a completion date will be saved in the associated tracking row. This parameter is used to the provider to only export tracking data where the completion date is in a certain time span. Must be used with `timeFramesScale.`
timeFramesScale timeFrameScale Once a learner has completed a learning object or activity, a completion date will be saved in the associated tracking row. This parameter is used to the provider to only export tracking data where the completion date is in a certain time span. Must be used with `timeFrames`.

Example

    <providers>
        <learningObjectMetadataProvider>
            <columns>
                <learningObjectAuthorId/>
                <learningObjectAuthorFirstName/>
                <learningObjectAuthorLastName/>
                <learningObjectId/>
                <learningObjectCode/>
                <learningObjectDuration/>
                <learningObjectGuid/>
                <learningObjectIncludedInLO/>
                <learningObjectLearningPoints/>
                <learningObjectLevel/>
                <learningObjectLocales/>
                <learningObjectPublisher/>
                <learningObjectSummary/>
                <learningObjectTags/>
                <learningObjectTargetAudience/>
                <learningObjectTitle/>
                <learningObjectThemes/>
                <learningObjectThumbnailSmall/>
                <learningObjectThumbnailMedium/>
                <learningObjectThumbnailLarge/>
                <learningObjectType/>
                <learningObjectDisplayedType/>
                <learningObjectAssignements/>
                <learningObjectAverageScore/>
                <learningObjectAverageCompletionTime/>
                <learningObjectCompletions/>
                <learningObjectNbOfComments/>
                <learningObjectNbTimesFavorited/>
                <learningObjectRatingByLearners/>
                <learningObjectRatingDisplayed/>
                <learningObjectRatingNbByLearners/>
                <learningObjectRatingNbDisplayed/>
                <learningObjectTotalTimeSpent/>
                <learningObjectViewsByLearners/>
                <learningObjectViewsDisplayed/>
                <learningObjectCreationDate/>
                <learningObjectModificationDate/>
                <learningObjectFirstLaunchDate/>
                <learningObjectLastLaunchDate/>
                <constantValue/>
            </columns>
            <parameters>
                <dateFormat>YYYY-MM-DD</dateFormat>
            </parameters>
        </learningObjectMetadataProvider>
    </providers>