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 200 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.

EXAMPLE   

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

Gamification import example file

Related topics