Importing a Schedule

Purpose

The procedure to import a Schedule is listed below.

Import File Format

The File must be in a comma separated format. Each record in the import file must contain the following fields

Import File Format Example

1,123,14:00 09/01/2009,21:00 09/01/2009,3

Where

Sequence Number = 1

Employee ID = 123

Time In/Date In = 14:00 09/01/2009

Time Out/Date Out = 21:00 09/01/2009

Job ID = 3

Figure 2.54.1 Import File Format Fields

Field	Description
Sequence Number	A numeric value that is used to maintains the order of the records. Note: This field may be left blank.
Employee ID	This field is compared with the Employee ID1 and ID2 fields within Focus to match the record to an employee in Focus. Note: Formatting characters should not be included in this value.
Time In/Date In	The time and date the employee should clock in. The date must be a date within the date range of the schedule otherwise it is not added. An example of a valid Time In/Date In is 14:00 03/01/2011. Note: The time format must be in a 24 hour format.
Time Out/Date Out	The date and time the employee should clock out. Note: The time format must be in a 24 hour format.
Job ID	The Job ID must be a value from 1 to 64 that represent the 64 Jobs within Focus.

Procedure to Import a Schedule

· While in Focus Setup, select Employees > Schedules.

· Select any Schedule and click Edit.

· Click OK.

· Click Tools.

· Click Import.

· Select the File Name and path for the schedule file.

· Click OK.

Related Topics