Available columns

Name Description
candidateId The database ID used to identify the learner.
candidateGuid The learner’s GUID.
candidateRefNumber The learner’s reference number.
candidateName The learner’s name (family name/surname).
candidateFirstname The learner’s first name.
candidateLogin The learner’s login.
candidateEmail The learner’s e-mail address.
candidateGroupAncestors This column is deprecated in the CKLS 14.1 version, please use candidateEntityAncestors instead.
candidateGroupName The learner’s group name.
candidateCustomFieldGuid GUID for one of the learner’s possible custom fields.
candidatePresentation The candidate’s presentation text.
candidateTimeZone The candidate’s timezone.
contentGuid The GUID of the learning object version.
learningObjectGuid The GUID of the learning object.
contentRefNumber The reference number of the learning object version.
contentTitle The title of the learning object version.
contentLocale The locale of the learning object version.
learningObjectPublisher The publisher of the learning object.
registrationGuid The GUID of the registration.
sessionId The database ID used to identify the session.
sessionTitle The title of the session.
sessionGuid The GUID of the session.
sessionStartDate The start date of the session.
sessionEndDate The end date of the session.
trainingId The database ID used to identify the training course.
trainingGuid The GUID of the training course.
trainingPathCode The reference number of the training course.
trainingTitle The title of the training course.
trainingContentFolder The name of the folder in which the learning object is placed (inside the training course).
trainingContentMandatory The flag (Y or N) indicating if the learning object is mandatory in the context of the training course.
firstLaunchDate The date at which the content referenced by the tracking row has been launched for the first time.
completionTime The date at which the content referenced by the tracking row has been completed [JULIEN] WRONG => the last access date
firstCompletionDate The date at which the content referenced by the training has been completed for the first time.
progression The progress of the learner on the current content referenced by the tracking row (ie. 80%).
score The score the learner has achieved on the content.
status The progress status (completed, incomplete or not started) of the content referenced by the tracking row.
timeGlobal The total time the learner spent on the content.
constantValue Return the constant value specified in this column’s child elements.
logDate The date at which the tracking log was created.
trainingModality The modality of the training course.
trainingPublisher The publisher of the training course.

Filters and parameters

Name Description
groupIds This parameter is deprecated in the CKLS 14.1 version, please use entityIds instead. A comma-separated list of the group ids to filter on. If multiple group ids are provided, then the export will return data about learners who belong to at least one of those groups.
entityIds A comma-separated list of the entity ids to filter on. If multiple entity IDs are provided, then the export will return data about learners who belong to at least one of those entities.
publishers Only export tracking data on content issued by the given publishers GUID. Multiple publishers may be specified in a comma-separated list.
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>
    <trackingLogProvider>
        <columns>
            <candidateId/>
            <candidateGuid/>
            <candidateRefNumber/>
            <candidateName/>
            <candidateFirstname/>
            <candidateLogin/>
            <candidateEmail/>
            <candidateGroupAncestors/>
            <candidateGroupName/>
            <candidateCustomFieldGuid/>
            <candidatePresentation/>
            <candidateTimeZone/>
            <contentGuid/>
            <learningObjectGuid/>
            <contentRefNumber/>
            <contentTitle/>
            <contentLocale/>
            <learningObjectPublisher/>
            <registrationGuid/>
            <sessionId/>
            <sessionTitle/>
            <sessionGuid/>
            <sessionStartDate/>
            <sessionEndDate/>
            <trainingId/>
            <trainingGuid/>
            <trainingPathCode/>
            <trainingTitle/>
            <trainingContentFolder/>
            <trainingContentMandatory/>
            <firstLaunchDate/>
            <completionTime/>
            <firstCompletionDate/>
            <progression/>
            <score/>
            <status/>
            <timeGlobal/>
            <constantValue/>
            <logDate/>
            <trainingModality/>
            <trainingPublisher/>
        </columns>
        <parameters>
            <dateTimeFormat>YYYY-MM-DD hh:ii:ss</dateTimeFormat>
        </parameters>
    </trackingLogProvider>
</providers>