Download the manual

APPENDIX A - Layout of Export/Import file
The import function expect an ASCII text file with the following fields. Character fields are enclosed in
double quotes, Numeric fields are not. Each field is separated by a comma, each line is separated by a
carriage return-Line feed
Ex
“V3.0,“BLOGGS”,”fred”,28,”12/12/2000"
In this example, 28 is a numeric field, the other fields are characters
1 VERSION
2 SURNAME
3 NAME
4 SEX
5 FILENO
6 CODE
7 STATUS
8 STREET
9 CITY
10 STATE
11 ZIP
12 TEL
13 DOB
14 COM_DATE
15 ENTERED
16 RECALL
17 RETRAIN
18 TERMINATED
19 RECALLYES
20 RETRAINYES
21 SHIFT
22 CLASS
23 DEPARTMENT
24 WORKGROUP
25 NOISECLASS
26 PROTCLASS
27 COMPANY
28 ADDRESS
29 COMMENT1
30 PREEMP1
31 PREEMP2
32 PREEMP3
33 MILITARY
34 TIMESERVED
35 EXPLOSIVES
36 TROUBLE
37 HOBBIES
38 POWERTOOLS
39 DIZZINESS
40 RINGING
41 COLDS
42 OTHER
43 REFERRED
44 ANTIBIOTIC
45 MUMPS
46 HISTCHANGE
47 COMMENT2
48 NBTEST
49 TAG
50 PERS
51 SPARE1
52 SPARE2
53 AGE
54 DATE_TEST
55 TRECALL
56 TRETRAIN
57 LEN_EMPLOY
58 TCLASS
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Numeric
Numeric
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Character
Numeric
Numeric
Numeric
Character
Character
Character
Character
Character
Character
Numeric
Character
4
18
18
1
8
10
1
28
20
3
4
13
8
8
8
8
8
8
1
1
5
27
27
12
1
1
30
30
51
36
36
36
1
2
1
1
1
1
1
1
1
1
1
1
1
1
130
2
1
1
1
1
2
8
8
8
2
27
“V3.0", or any dummy field (see Note below)
Employee number
Employee status
Commencement date
Re-test date
Re-train date
Y/N
Y/N
Occupation
Workgroup noise level
Hearing Protector class
Previous employer 1
Y/N
Years
Y/N
Y/N
Y/N
Y/N
Y/N
Y/N
Y/N
Y/N (discharges)
Y/N
Y/N
Y/N
Y/N
Number of tests
re-test date
occupation
Page 89