D.6. Time and Attendance data file format
The TR40xx saves the time/attendance data onto a Floppy Disk using a so-called delimited text format.
This data format is widely accepted by a variety of different software packages including the
Microsoft Excel,
Access
and many others.
With delimited text format, fields within a record are separated by a TAB character (tabulation, ASCII=
09 Hex) while records are separated from each other by CR (Carriage Return, ASCII= OD Hex) and LF (Line
Feed, ASCII= 0A Hex) characters. Fields are guaranteed to contain ASCII characters in the 20-7F Hex only.
All numerical values are represented by their string equivalents.
Each TR40xx’s record consists of the following fields:
Field Length*
Format
Event 1
E
, can be “1”, “2”, “3” or “4”
Date 10
“DD
-
MM
-
YYYY”
Time 8
“hh
:mm:ss
”
ID-code Variable
“
’
xx…x”
, apostrophe is added to make sure that this field is treated as a string
by applications like
Microsoft Excel
Shift 2
“SS”
, can be in the range from 00 to 99
Machine No
2
“NN”
, can be in the range from 00 to 99
*Length doesn’t include the TAB character
The ID-code field content can be fine customized. See
Fine-tuning ID-code processing
for more
information.
Summary of Contents for TR4020
Page 72: ...72 Machine Number See Machine Number Programming Mode Menu Item ...
Page 74: ...74 Time See Time Programming Mode Menu Item ...
Page 75: ...75 Date See Date Programming Mode Menu Item ...
Page 77: ...77 Bell duration See Bell duration Programming Mode Menu Item ...
Page 78: ...78 Bell Table See Edit bell table Clear bell table Programming Mode Menu Items ...
Page 80: ...80 Default shift See Default shift Programming Mode Menu Item ...
Page 81: ...81 Lock activation duration See Lock activation duration Programming Mode Menu Item ...
Page 82: ...82 Internal reader prefix See Prefix to match Programming Mode Menu Item ...
Page 83: ...83 Internal reader extract from character See From character Programming Mode Menu Item ...
Page 85: ...85 External scanner prefix See Prefix to match Programming Mode Menu Item ...
Page 86: ...86 External scanner extract from character See From character Programming Mode Menu Item ...
Page 88: ...88 External scanner start character See Start character Programming Mode Menu Item ...
Page 89: ...89 External scanner end character See End character Programming Mode Menu Item ...
Page 90: ...90 External scanner baudrate See Baudrate Programming Mode Menu Item ...
Page 120: ...120 Initializing The System Reset is in progress Please wait for a while ...