|
The Batch Capture module contains a feature in the Import
menu called Employees From Emp.Txt. The following document
describes the Emp.Txt format.
The Emp.Txt file is an ASCII text
file,
with each line representing 1
employee. 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 - ie no commas.
| Description |
Start Character |
Length |
| Employee Number |
1 |
10 |
| Employee Pay Number |
11 |
10 |
| Employee Card Number |
21 |
10 |
| Employee First Name |
31 |
20 |
| Employee Surname |
51 |
20 |
| Hired Date ( dd/mm/yyyy) |
71 |
10 |
| Shift Code |
81 |
6 |
| Company |
101 |
20 |
| Branch |
121 |
20 |
| Department |
141 |
20 |
| Category |
161 |
20 |
| Cost Centre |
181 |
20 |
| Scale |
201 |
20 |
| Employee Type |
221 |
20 |
| Work Group |
241 |
20 |
| ID Number |
261 |
20 |
|
|
|
- Notice the gap between the
Shift
Code and the Company field. This gap is currently not used.
- The employee number is considered unique for each employee.
This is also the only field which MUST be in the Emp.Txt file.
- If the employee already exists then the
data
in TNA 2000 is updated. Only those
fields
which are present will be updated. For example, you can update
everyone=s
Card
Number by simply importing a text file containing just the Employee
Number and Card number.
|
