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 twenty-seven (27) 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 City |
Optional |
|
5 |
Work State |
Optional |
|
6 |
Work Postcode |
Optional |
|
7 |
Work Phone |
Optional |
|
8 |
Work Fax |
Optional |
|
9 |
Home Address |
Optional |
|
10 |
Home City |
Optional |
|
11 |
Home State |
Optional |
|
12 |
Home Postcode |
Optional |
|
13 |
Home Phone |
Optional |
|
14 |
Staff Type |
Required |
This value for this field must be 'S' for Staff, 'N' for non-staff, or 'O' for non-supplier. |
15 |
Comments |
Optional |
|
16 |
User ID |
Optional |
|
17 |
TCP/IP Address |
Optional |
|
18 |
E-mail Address |
Optional |
|
19 |
Title |
Optional |
|
20 |
Initials |
Optional |
|
21 |
Division |
Optional |
|
22 |
Branch |
Optional |
|
23 |
Directorate |
Optional |
|
24 |
Position |
Optional |
|
25 |
Location |
Optional |
If you supply a location, the location must already exist in the Property Module. |
26 |
Section |
Optional |
The value in this field will be added to the Sections table if it does not already exist. |
27 |
Reference Number |
Optional |
|