This provider generates a data report containing learning object level tracking data. The following columns for each tracking row can be included in this report.

Available columns

Name Description
candidateId The database ID used to identify the learner.
candidateGuid The learner’s GUID.
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.
candidateRefNumber The learner’s reference number.
candidateCustomFieldGuid GUID for one of the learner’s possible custom fields.
candidateTimeZone The candidate’s timezone.
candidateGroupAncestors This column is deprecated in the CKLS 14.1 version, please use candidateEntityAncestors instead.
candidateEntityAncestors The learner’s entity ancestors.
candidateGroupName The learner’s group name.
candidateEntityName The learner’s entity name.
trainingId The database ID used to identify the training course.
trainingGuid The GUID of the training course.
trainingTitle The title of the training course.
trainingPathCode  
sessionId The database ID used to identify the session.
sessionGuid The GUID of the session.
sessionTitle The title of the session.
sessionStartDate The start date of the session.
sessionEndDate The end date of the session.
registrationGuid The GUID of the registration.
learningObjectGuid The GUID of the learning object.
contentGuid The GUID of the learning object version.
contentTitle The title of the learning object version.
contentRefNumber The reference number of the learning object version.
contentLocale The locale of the learning object version.
learningObjectPublisher The publisher of the learning object.
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.

Filters and parameters

Name Description
dateFormat Date format to be used in the exported data.
dateTimeFormat Date time format to be used in the exported data.
groupIds This parameter is deprecated in the CKLS 14.1 version, please use entityIds instead.
entityIds Only export data for the specified entities
modality Only export tracking data for a specific training modality
onlyFromImportedRegistrations Only export data related to registrations that were imported.
onlyFromImportedSessions Only export data related to sessions that were imported.
preferredLocales Only export data where contentLocale matches locales specified in a comma-separated list
publishers Only export tracking data for a specific content publisher
reportStatus Only export tracking data for a specific completion status
statusFormat Allows to specify custom values for completion status
timeFrames Only export tracking data for a specific time span (e.g. last 7 days). Use timeFramesScale to specify days, months or years.
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.
timeFrameScaleMode This parameter is used in addition to timeFrames and timeFramesScale to determine how the total time spent is estimated. Possible values are lastActivity or timeSpent
timeGlobalFormat Time format in which the timeGlobal column should be exported
trainingGuid Only export tracking data for a specific training path
trainingPathCode Only export tracking data for a specific trainingPathCode
sessionGuid Only export tracking data for a specific session
withoutLaunchTime Whether or not to export tracking data that has no launch date
deltamode Only export tracking data that was not included in the previous export

Example

<providers>
    <trackingProvider>
		<columns>
			<candidateId/>
			<candidateName/>
			<candidateFirstname/>
			<candidateLogin/>
			<candidateEmail/>
			<candidateRefNumber/>
			<candidateGuid/>
			<candidateEntityName/>
			<candidateCustomFieldGuid label="Department">8345C0A3-B8AB-7F65-0638-39B0E1244AA8</candidateCustomFieldGuid>
			<trainingId/>
			<trainingTitle/>
			<trainingPathCode/>
			<trainingGuid/>
			<sessionId/>
			<sessionTitle/>
			<sessionGuid/>
			<sessionStartDate/>
			<sessionEndDate/>
			<contentGuid/>
			<contentRefNumber/>
			<contentTitle/>
			<contentLocale/>
			<firstLaunchDate/>
			<completionTime/>
			<score/>
			<timeGlobal/>
			<progression/>
			<status/>
		</columns>
        <parameters>
            <dateFormat>MM-DD-YYYY</dateFormat>
        </parameters>
    </trackingProvider>
</providers>