|
Automatic
Importing / Exporting of Leave
Summary :
The Batch Capture module contains a feature
in the Import menu called Leave From Leave.txt.
The following document describes the Leave.txt format.
Details
The Leave.txt file is an ASCII text file, with each line representing 1
leave record. The record
can be up to 261 Characters long. The
fields are in "fixed positions",
in other words each field has a set number of characters. There is no
inter-field separation character - i.e. no commas. Note though can gaps
do exist between some of the fields.
Layout :
|
Description
|
Start
Character |
Length |
|
Employee
Number |
1 |
10 |
|
Requested-On
Date ( dd/mm/yyyy ) |
12 |
10 |
|
Leave
From Date (dd/mm/yyyy ) |
23 |
10 |
|
Leave
To Date (dd/mm/yyyy) |
34 |
10 |
|
Leave
Type (1-255) |
45 |
3 |
|
Paid-Leave
Days |
49 |
6 |
|
Paid-Sick
Days |
56 |
6 |
|
Approved |
63 |
1 |
|
Approved
By |
65 |
20 |
|
Approved
On (dd/mm/yyyy) |
86 |
10 |
|
Reason |
97 |
40 |
|
Comment |
138 |
40 |
Notes
1) Imported records will be scheduled
for processing when they are imported.
2) If a leave record with the same
employee number, and fromdate, is imported, then the new record will
overwrite the old record.
3) An example Leave.txt file is located in
the DOCS directory on the TNA 2000 CD
4)
A report, Leave
Export Report, has been added. This creates a Leave.txt
file from current leave records.
|
