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.
candidateRefNumber The learner’s reference number.
candidateLogin The learner’s login.
candidateEmail The learner’s e-mail address.
candidateEntityName The learner’s entity name.
candidateCustomFieldGuid GUID for one of the learner’s possible custom fields.
gamificationPoints The number of points acquired for this action.
gamificationActionCode unique ID/code for an action.
gamificationAction Label localized of the action.
gamificationDateTime Date time when this action occured.
locale Local of the label.
constantValue Return the constant value specified in this column’s child elements.

Filters and parameters

Name Description
dateTimeFormat Format for dates in the exported data. The default datetime format is YYYY-MM-DD hh:ii:ss.
preferredLocales The comma-separated list of preferred locales.
threshold Whether or not to export tracking data that has no launch date (the learner has never launched the content). When points will be exported, use the threshold to convert them (points*threshold). Useful for incentive tool. Default value 1 . All values are allowed, so be careful (0, negatives, etc)
deltaMode Only export new tracking data (with respect to the last 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.
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.

Examples

<providers>
    <consolidatedGamificationEventsProvider>
        <columns>
            <candidateId/>
            <candidateGuid/>
            <candidateName/>
            <candidateFirstname/>
            <candidateRefNumber/>
            <candidateLogin/>
            <candidateEmail/>
            <candidateEntityName/>
            <candidateCustomFieldGuid/>
            <gamificationPoints/>
            <gamificationActionCode/>
            <gamificationAction/>
            <gamificationDateTime/>
            <locale/>
            <constantValue/>
        </columns>
        <parameters>
            <dateTimeFormat>YYYY-MM-DD hh:ii:ss</dateTimeFormat>
        </parameters>
    </consolidatedGamificationEventsProvider>
</providers>