|
Automatic
Importing of Employees
Summary
:
The
Batch Capture module contains a feature in the Import menu called
Employees From Emp.Txt. The
following document describes the Emp.Txt format.
Details
:
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.
Layout
:
|
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 |
|
|
|
Notes
:
-
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.
|
