Punch Import File Layout
The data file must be formatted
correctly in order to be imported by the TimeForce system. The file format
is displayed on the right-hand side of the main “Punch Imports” screen.
IMPORTANT:
The punches contained in the Excel file must be in order of date. All
fields in the punch import file require a value. To skip a certain type
of data, insert a “0” into the field instead of leaving the field blank.
The punch file layout is
as follows:
|
Column Name |
Data Type |
Required |
Description |
|
CardNumber |
Number (10 characters) |
Required |
The employee's card number. |
|
Date |
Date (01/01/2004) |
Required |
Date of the punch. |
|
Time |
Time (04:00)
5 characters |
Required |
Time of the punch. |
|
Type |
Number (1 character) |
Required |
Punch Type:
1=Break, 2= Lunch, 3=Normal |
|
Department |
Number (10 characters) |
Required |
Department number assigned to the punch. |
|
Job |
Number |
Required |
Job number assigned to the punch. |
|
Task |
Number |
Required |
Task number assigned to the punch. |
|
Quantity |
Number (10 characters) |
Required |
Quantity assigned to the punch. |
|
In/Out |
Number (1 character) |
Required |
In/Out Type
1=IN, 2=OUT, 3=AUTO |
|