This provider generates a data report containing tracking data at the session level (= registration).

Available columns

Name Type Description
candidateCustomFieldGuid string(250) Data for one of the learner's possible custom fields (GUID of the custom field needs to be specified, please check the examples).
candidateEmail string The learner's e-mail address.
candidateEntityAncestors string The learner's entity ancestors.
candidateEntityName string The learner's entity name.
candidateFirstname string The learner's first name.
candidateGuid string(40) The learner's GUID.
candidateId int The database ID used to identify the learner.
candidateLogin string The learner's login.
candidateName string The learner's name (family name/surname).
candidateRefNumber string The learner's reference number.
candidateSmartgroups string The list of the learner's smartgroups names separated by semicolons.
catalogVisibility enum(Y, N) "Y" if the training course associated with the current context is visible in the public catalogue, "N" otherwise.
completionTime datetime The date at which the content referenced by the tracking row has been last accessed
constantValue string Return the constant value specified in this column's child elements.
firstCompletionDate datetime The date and time at which the content referenced by the training has been completed for the first time. If this field is not present in the import files, but the data imported is considered completed, the value of this field will be automatically set to today.
firstLaunchDate datetime The date and time at which the content referenced by the tracking row has been launched for the first time.
lastPlatformAccessDate datetime The last date at which the learner has accessed the platform.
nbLO int The total number of learning objects in the same session as the learning object referenced by the tracking row.
nbLOFinished int The total number of learning objects that the learner has finished in the same session as the learning object referenced by the tracking row.
nbLOStarted int The total number of learning objects that the learner has started in the same session as the learning object referenced by the tracking row.
progression float
  • For Tracking and Tracking logs: the progress of the learner on the current content referenced by the tracking row.
  • For Blendedx registrations: the raw progress of the learner in the current session, based on the total points for all activities (= doesn't take into account the threshold).
  • For registrations in legacy modalities: the raw progress of the learner in the current session, based on all the resources, both optional and mandatory.
progressionMandatory float
  • For Blendedx: the progress of the learner in the session (based on the session threshold if defined).
  • For legacy modalities: the total progress of the learner (only on the mandatory learning objects) in the session.
registrationDate datetime The date of the registration.
registrationGuid string(40) The GUID of the registration.
score float The score the learner has achieved on the content.
scoreNPS int Score of a NPS activity.
sessionEndDate date The end date of the session.
sessionGuid string(40) The GUID of the session.
sessionId int The database ID used to identify the session.
sessionStartDate date The start date of the session.
sessionTitle string The title of the session.
status enum
  • For the providers related to tracking: the progress status of the content referenced by the tracking row. The returned values can be overriden thanks to option 'statusFormat'.
    Type: enum(completed, incomplete, not attempted)
  • For the provider 'Platform Candidates Access': the status of the of connection attempt (0 = failed, 1 = successful).
    Type: enum(0, 1)
thresholdReachedDate datetime The date on which the learner has reached the success threshold of the training course.
timeGlobal timeGlobalFormat
  • If the current context is a Registration: the total time the learner spent on learning resources for the registration.
  • If the current context is a Tracking: the total time the learner spent on the learning resource.
  • If the current context is a Tracking Log: the time the learner spent on the learning resource on the day related to the current log.
If the options timeFrames and timeFramesScale are specified in the provider, then this value is filtered to only the time spent during the chosen period.
timeSpent timeGlobalFormat
  • If the current context is a Registration: the total time the learner spent on the registration.
    timeSpent = timeGlobal + timeSpentCBT + timeSpentDigital
    If the options timeFrames and timeFramesScale are specified in the provider, then this value is filtered to only the time spent during the chosen period.
  • If the current context is an Activity: the time the learner spent on the activity.
timeSpentCBT timeGlobalFormat The total time spent on classroom events.
If the options timeFrames and timeFramesScale are specified in the provider, this value is filtered to only the time spent during the chosen period.
timeSpentDigital timeGlobalFormat The total time spent on Blendedx activities, excluding learning resource activities.
If the options timeFrames and timeFramesScale are specified in the provider, then this value is filtered to only the time spent during the chosen period.
trainingChapters longtext The chapter hierarchy of the training course.
trainingDuration string The duration of the training course.
trainingGuid string(40) The GUID of the training course.
trainingId int The database ID used to identify the training course.
trainingModality enum(learning_channel, kc, distanciel, blended, campus, mentored_action_learning, portal, serious_game, public_course, vodeclic, learning_feed, content_test) The modality of the training course.
trainingPathCode string The reference number of the training course.
trainingPublisher string The publisher of the training course.
trainingStatus enum(C, P, A) The validation status of the training course. The values displayed in this column are C, P, A which respectively mean Under Construction, Published, Archive. These values can be configured via the `trainingStatusFormat` parameter.
trainingTitle string The title of the training course.

Filters and parameters

Name Type Description
activityType string Blendedx registrations are exported as soon as their related path contains at least one activity of this type. Other modalities' registrations are exported if the filter is 0 (content) and 4 (classroom) and contains CBT activities
ancestorsWithCurrent yesNoElement For each tracking data row, the learner's hierarchy can be exported with the other data. This parameter tells the provider whether to include the learner's group in the hierarchy or not. If set to `yes`, the learner's current group will be included. Otherwise, it will be removed from the exported hierarchy.
catalogVisibility yesNoElement Only export training courses that have the specified catalog visibility.
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`.
deltaMode yesNoElement Only export new data (with respect to the beginning of the previous export). In order for this parameter to work, the previous exports must have had a `guid` attribute (`<export guid='foo'>`).
This feature cannot be used alongside `timeFramesScale`.
When items are updated while the task is running, these updated items can be exported both during the current task and the next.
entityIds string 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.
learnersSmartGroups string A list of IDs of smartgroups separated by commas. Allows to filter the exported results on the specified smartgroups.
maxLength int If not empty, this option will crop each value to the specified max length (each cell, not each line).
modality enum('', learning_channel, kc, blended, campus, distanciel, mentored_action_learning, portal, serious_game, content_test, guided) Only export data related to a training course that belongs to the specified modality.
onlyFromImportedRegistrations yesNoElement Only export tracking data related to registrations that were imported.
onlyFromImportedSessions yesNoElement Only export tracking data related to sessions that were imported.
onlyFromImportedTraining yesNoElement Only export tracking data related to trainings that were imported.
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.
publishers string Only export tracking data on content issued by the given publishers GUID. Multiple publishers may be specified in a comma-separated list.
reportStatus reportStatus Export tracking data that have the specified report statuses (several values can be given).
sessionGuid string(40) Only export data related to a training session that has the specified GUID.
sessionTitle string Only export data related to a training session that has a title that exactly matches the given string (except for the trainingSessionMetadataProvider and the sessionAuditMetadataProvider where the session title only needs to contain the given string)
statusFormat statusFormat This parameter is used to convert LMS progress status to Scorm-compliant progress status.
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.
timeFrameScaleMode timeFrameScale This parameter is used in addition to `timeFrames` and `timeFramesScale` to determine how the total time spent is estimated. Possible values are `lastActivity`, `lastActivityCumulative` or `timeSpent`
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`.
timeGlobalFormat timeGlobalFormat Time format in which the `timeGlobal` column should be exported
trainingGuid string(40) Only export data related to a training course that has the specified GUID.
trainingModalityFormat string Only export data related to the training courses with the chosen modality, filtered by their database name (ex: blended, guided, learning_channel).
trainingPathCode string Only export data related to a training course that has the specified code.
trainingPublishers string Only export data related to the list of publishers (linked to training courses), filtered by title. Can contain several values separated by commas.
trainingStatus string Only export training courses that have the specified statuses. This parameter contains a comma-separated list of training statuses (see the available values in column `trainingStatus`).
trainingStatusFormat trainingStatusFormat Configure what value to display for each training status value.
withoutLaunchTime yesNoElement Whether or not to export tracking data that has no launch date (the learner has never launched the content). By default, the provider will only export tracking data where the learner has launched the content at least once.
Please note that this option should not be used together with the `timeFrames` options, as the `timeFrames` options are based on the learners activity, so using both options together will prevent from retrieving the data without activity.

Example

<providers>
    <consolidatedTrackingProvider>
        <columns>
            <candidateId/>
            <candidateName/>
            <candidateFirstname/>
            <candidateLogin/>
            <candidateEmail/>
            <candidateRefNumber/>
            <candidateGuid/>
            <candidateEntityAncestors/>
            <candidateEntityName/>
            <candidateCustomFieldGuid label="Department">8345C0A3-B8AB-7F65-0638-39B0E1244AA8</candidateCustomFieldGuid>
            <lastPlatformAccessDate/>
            <nbLO/>
            <nbLOStarted/>
            <nbLOFinished/>
            <registrationDate/>
            <registrationGuid/>
            <sessionId/>
            <sessionTitle/>
            <sessionGuid/>
            <sessionStartDate/>
            <sessionEndDate/>
            <trainingId/>
            <trainingTitle/>
            <trainingPathCode/>
            <trainingGuid/>
            <catalogVisibility/>
            <trainingStatus/>
            <trainingModality/>
            <trainingPublisher/>
            <trainingChapters/>
            <trainingDuration/>
            <completionTime/>
            <firstLaunchDate/>
            <progression/>
            <progressionMandatory/>
            <score/>
            <status/>
            <thresholdReachedDate/>
            <firstCompletionDate/>
            <timeGlobal/>
            <constantValue/>
            <scoreNPS/>
            <timeSpentCB/>
            <timeSpentDigital/>
            <timeSpent/>
        </columns>
        <parameters>
            <dateTimeFormat>YYYY-MM-DD hh:ii:ss</dateTimeFormat>
            <timeFrames>3</timeFrames>
            <timeFramesScale>less_than_n_days</timeFramesScale>
            <timeFrameScaleMode>lastActivity,timeSpent</timeFrameScaleMode>
        </parameters>
    </consolidatedTrackingProvider>
</providers>