Staff & Non-suppliers cannot be updated through the Generic Import function. This is because it is difficult to distinguish whether two people with the same surname, or even the same surname and first name are actually two different people, or the same person. Thus the Generic Import is restricted to only importing new records, not updating existing staff members.
The data file to import Staff & Non-suppliers must consist of sixteen (16) comma separated columns. The columns must be in the following order:
Column |
Field |
Required/Optional |
Description |
1 |
Surname |
Required |
If the surname exists in the Staff/Non-suppliers table, a new staff member will still be added. |
2 |
First Name |
Optional |
|
3 |
Work Address |
Optional |
|
4 |
Work Postcode |
Optional |
|
5 |
Work Phone |
Optional |
|
6 |
Work Fax |
Optional |
|
7 |
Staff Type |
Required |
This value for this field must be 'S' for Staff, 'N' for non-staff, or 'O' for non-supplier. |
8 |
Comments |
Optional |
|
9 |
User ID |
Optional |
|
10 |
E-mail Address |
Optional |
|
11 |
Title |
Optional |
|
12 |
Initials |
Optional |
|
13 |
Directorate |
Required |
|
14 |
Position |
Optional |
|
15 |
Location |
Optional |
If you supply a location, the location must already exist in the Property Module. |
16 |
Reference Number |
Optional |
|