Schedule Import Interface logic
This section describes how the Standard Schedule Import Interface converts team CSV data into the Workforce Management application. This section references field specifications in the Schedule Import Interface Field Specification section.
General
The schedule import file is a CSV text file with columns enclosed in quotes if there are commas in the column field value. The records in the file are processed sequentially from top to bottom.
Break Logic
Breaks are supplied in this format:
StartTime,EndTime,TimeCode,HourType,Duration
Where:
|
Field |
Required |
Description |
|---|---|---|
|
StartTime |
Yes |
The start date and time of the break/window. Format: YYYYMMDD hh24mm |
|
EndTime |
Yes |
The end date and time of the break/window Format: YYYYMMDD hh24mm |
|
TimeCode |
Yes |
The time code for the break. |
|
HourType |
Yes |
The hour type for the break. |
|
Duration |
No |
Duration of the break. If this field is not supplied, the system uses EndTime - StartTime minutes. |
For a series of breaks, use the tilde (~) symbol to
separate the breaks in the Sch_Break_String:
StartTime,EndTime,TimeCode,HourType,Duration~StartTime1,EndTime1,TimeCode1
,HourType1,Duration1~StartTime2,EndTime2,TimeCode2,HourType2,Duration2...For example, this code block specifies a break taken from 10:00-10:30 and a lunch break taken from 13:00-13:45 at the REG hour type on January 2, 2004:
20040102 1000,20040102 1030,BRK,REG~20040102
1300, 20040102 1345,LUN,REG