WFM gamification import requirements
This page describes the requirements when importing gamification data from an external system.
File format
All data must be provided in a CSV file.
Fields can be separated either by comma or semicolon. If a comma is used to separate fields, only use the "." character to represent decimal values. If a semi-colon is used to separate fields, only use the "," character to represent decimal values.
The import file must include these fields in this order.
{Date},{PersonID},{PersonFirstName},{PersonLastName},{MeasureName},{MeasureId},{MeasureType},{Score}
| Field | Description |
|---|---|
| Date | Date in format yyyymmdd. |
| PersonID |
A string with a maximum of 130 characters. To connect the score to an agent, the PersonID in the import file must match the agent's employment number, external logon, or application login. Note that the matching is case sensitive. EXAMPLE If the external logon is "0019 (ACD)", only 0019 is matched. |
| PersonFirstName | The agent's first name. |
| PersonLastName | The agent's last name. |
| MeasureName | The name of the measure. A string with a maximum of 50 characters. |
| MeasureId |
An integer value that can uniquely identify the measure. |
| MeasureType |
Describes the type of performance score for this measure. Currently two different types are supported; Percent and Numeric. |
| Score |
A decimal value that represents the agent's score on this day for this measure. |
20200820,1234,Kalle,Pettersson,Quality Score,1,Percent,87
20200820,1234,Kalle,Pettersson,Sales Result,2,Numeric,2000
20200820,1234,Kalle,Pettersson,Campaign Result,3,Numeric,25.5
Related topics