Import file details
The following table displays the details of the import file sent from the HRMS to WFM.
IMPORTANT Every column header is required to be present in the import file, even if data is not required to be present for that column. If a column header is missing, then the import will fail.
| Element | Description |
|---|---|
| File Location | C:\Program Files\Common Files\Calabrio ONE\Data Server\gis\vacationreports\<tenant> |
| File Name | VacationHours_From_HRMS |
| File Header | VACATION FROM HRMS DATE: <date> |
| Column Headers |
login Data optional. This is the email address that users enter when they log in to Calabrio ONE. Although login and employeeId are individually optional, you are required to include data in at least one of these two columns. Otherwise, the data import file will not be processed. |
|
vacationTypeLabel Data required. The data value entered for vacationTypeLabel in all rows must match exactly the vacation type name as configured in Calabrio ONE(Application Management > Vacation Planning > Vacation Types). This value cannot contain commas. |
|
|
availableHours Data required. This is the number of hours of vacation available to the agent. |
|
|
totalEarnedHours Data optional. This is the total number of vacation hours earned by the agent for the year. If the optional totalEarnedHours field is not included in the file, Calabrio ONE defaults its values to zero and overwrites the existing values. This can result in a negative value when calculating the hours used for an agent. If the field is included in the file, the value entered cannot exceed 9999. |
|
|
employeeId Data optional. Although login and employeeId are individually optional, you are required to include data in at least one of these two columns. Otherwise, the data import file will not be processed. |
The following is an example of an import file.
VACATION FROM HRMS DATE: 2018-04-19
login,vacationTypeLabel,availableHours,totalEarnedHours,employeeId
smithj@example.com,Floating Holiday,16,24,john.smith
smithj@example.com,Vacation,120,160,john.smith
jonest@generic.com,Vacation,70,80,teri.jones
adamsb@generic.com,Vacation,120,120,betty.adams
NOTE Data elements are limited to 2 digits to the right of the decimal point. If there are more than 2 digits, the value will be rounded to 2 digits before import. Errors in records are logged in the log file.
Commas that are part of the HRMS import data must be escaped with a backslash (for example, “3\,000”) in order to be treated as literals and not file delimiters.