Export all gamification events (gamification points received by learners).

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.
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.
constantValue string Return the constant value specified in this column's child elements.
gamificationAction string Label localized of the action.
gamificationActionCode string unique ID/code for an action.
gamificationDateTime datetime Date time when this action occured.
gamificationPoints int The number of points acquired for this action.
locale string Label of the locale.

Filters and parameters

Name Type Description
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 last export). In order for this parameter to work, the previous exports must have had a `guid` attribute (``). This feature cannot be used alongside `timeFramesScale`.
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).
preferredLocales string The comma-separated list of preferred locales.
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.
threshold float 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)

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>