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.
Содержание TR4020
Страница 50: ...50 Time Main Menu Setup See also Date This Menu Item allows you to set the TR40xx s current date ...
Страница 72: ...72 Machine Number See Machine Number Programming Mode Menu Item ...
Страница 74: ...74 Time See Time Programming Mode Menu Item ...
Страница 75: ...75 Date See Date Programming Mode Menu Item ...
Страница 77: ...77 Bell duration See Bell duration Programming Mode Menu Item ...
Страница 78: ...78 Bell Table See Edit bell table Clear bell table Programming Mode Menu Items ...
Страница 79: ...79 Default Event Table See Edit default event table and Clear default event table Programming Mode Menu Items ...
Страница 80: ...80 Default shift See Default shift Programming Mode Menu Item ...
Страница 81: ...81 Lock activation duration See Lock activation duration Programming Mode Menu Item ...
Страница 82: ...82 Internal reader prefix See Prefix to match Programming Mode Menu Item ...
Страница 83: ...83 Internal reader extract from character See From character Programming Mode Menu Item ...
Страница 84: ...84 Internal reader number of characters to extract See Number of characters Programming Mode Menu Item ...
Страница 85: ...85 External scanner prefix See Prefix to match Programming Mode Menu Item ...
Страница 86: ...86 External scanner extract from character See From character Programming Mode Menu Item ...
Страница 87: ...87 External scanner number of characters to extract See Number of character Programming Mode Menu Item ...
Страница 88: ...88 External scanner start character See Start character Programming Mode Menu Item ...
Страница 89: ...89 External scanner end character See End character Programming Mode Menu Item ...
Страница 90: ...90 External scanner baudrate See Baudrate Programming Mode Menu Item ...
Страница 120: ...120 Initializing The System Reset is in progress Please wait for a while ...
Страница 131: ...131 Please wait Just wait for a while ...