Introduction The Complete Solution Starter Kits Software Hardware

Pricing Availability Reports Documentation Downloads

 
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.

© 2005 by CapeSoft Software (Pty) Ltd       Disclaimer