Available columns

Name Description
trainingId The database ID used to identify the training course.
trainingStatus The status (published, archived or under construction) of the training course. The values displayed in this column can be configured via the trainingStatusFormat parameter.
sessionId The database ID used to identify the session.
sessionGuid The GUID of the session.
modality The modality of the associated training course.
title The title of the training course. /! Other contexts maybe
description The description of the training course. /! Other contexts maybe
startDate The start date of the session.
endDate The end date of the session.
creationDate The date at which the object (learner, training course or training session) was created.
pathModificationDate The date at which the associated training course was last modified (learning object added, folders reorganized,…).
modificationDate The date at which the object (training course, training session) was last modified.
registeredLearners The number of learners that have enrolled to the training session.
maxNbLearners The maximum number of learners that can enroll to the training session.
constantValue Return the constant value specified in this column’s child elements.

Filters and parameters

Name Description
exportAllSessions Whether to include failed connections.
modality Only export data related to a training course that belongs to the specified modality.
trainingGuid Only export data related to a training course that has the specified GUID.
sessionGuid Only export data related to a training session that has the specified GUID.
trainingTitle Only export data related to a training course that has a title that contains the given string.
sessionTitle Only export data related to a training session that has a title that contains the given string.
trainingPathCode Only export data related to a training course that has the specified code.
trainingStatus Only export training courses that have the specified statuses. This parameter contains a comma-separated list of training statuses (see the default values in trainingStatus).
trainingStatusFormat Configure what value to display for each training status value.
catalogVisibility Only export training courses that have the specified catalog visibility.
dateFormat Format for dates in the exported data. The default date format is YYYY-MM-DD.
dateTimeFormat Format for dates in the exported data. The default datetime format is YYYY-MM-DD hh:ii:ss.
timeFrames Once a learner has completed a learning object, 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 Once a learner has completed a learning object, 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.

Examples

<providers>
    <trainingSessionMetadataProvider>
        <columns>
            <trainingId/>
            <trainingStatus/>
            <sessionId/>
            <sessionGuid/>
            <modality/>
            <title/>
            <description/>
            <startDate/>
            <endDate/>
            <creationDate/>
            <pathModificationDate/>
            <modificationDate/>
            <registeredLearners/>
            <maxNbLearners/>
            <constantValue/>
        </columns>
        <parameters>
            <exportAllSessions>Y</exportAllSessions>
            <dateFormat>MM-DD-YYYY</dateFormat>
        </parameters>
    </trainingSessionMetadataProvider>
</providers>