Automatic Importing / Exporting of
Leave
The Batch Capture module contains a feature in the Import
menu called Leave From Leave.txt. The following document
describes the Leave.txt format.
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.
| 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
|
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. |
