Filter
Top Products
Security Escort | Technical Reference Manual | 7.0 Importing a
Subscriber Database
EN | 77
Bosch Security Systems | 6/12 | 38947D
Table 1: Importing a Subscriber Database
Data Fields in
Required Order
Excel
Column
Restrictions
Subscriber Name
A
This field can be up to 30 characters. This field can contain any
printable ASCII character except the “?”.
Subscriber ID
B
This field can be up to twelve characters. This field can contain
only ALPHA, numeric and the dash ASCII characters.
Here Phone
Number
C
This field can be up to sixteen characters. This field can contain
only numeric, “#”, “*”, “(“, “)”, comma and the dash ASCII
characters.
Here Address 1
D
This field can be up to 30 characters. This field can contain any
printable ASCII character except the “?’.
Here Address 2
E
This field can be up to 30 characters. This field can contain any
printable ASCII character except the “?”.
Here City
F
This field can be up to twenty characters. This field can contain
any printable ASCII character except the “?”.
Here State
G
This field can be up to three characters. This field can contain
only ALPHA ASCII characters.
Here Zip
H
This field can be up to ten characters. This field can contain only
ALPHA, numeric and the dash ASCII characters.
Away Phone
Number
I
This field can be up to sixteen characters. This field can contain
only numeric, “#”, “*”, “(“, “)”, comma and the dash ASCII
characters.
Away Address 1
J
This field can be up to 30 characters. This field can contain any
printable ASCII character except the ‘?’.
Away Address 2
K
This field can be up to 30 characters. This field can contain any
printable ASCII character except the “?”.
Away City
L
This field can be up to twenty characters. This field can contain
any printable ASCII character except the “?”.
Away State
M
This field can be up to 3 characters. This field can contain only
ALPHA ASCII characters.
Away Zip
N
This field can be up to 10 characters. This field can contain only
ALPHA, numeric and the dash ASCII characters.
Supplemental
Text Field 1
O
This field can be up to 254 characters. This field can contain any
printable ASCII character except the “?”.
Supplemental
Text Field 2
P
This field can be up to 254 characters. This field can contain any
printable ASCII character except the ‘?”.
Supplemental
Text Field 3
Q
This field can be up to 254 characters. This field can contain any
printable ASCII character except the “?”.
Supplemental
Text Field 4
R
This field can be up to 254 characters. This field can contain any
printable ASCII character except the “?”.
Pager Phone
Number
S
This field can be up to 16 characters. This field can contain only
numeric, “#”, “*”, “(“, “)”, comma and the dash ASCII characters.
Pager Password
T
This field can be up to 6 characters. This field can contain only
numeric, and ALPHA ASCII characters.
Pager Pager ID
U
This field can be up to 10 characters. This field can contain only
numeric ASCII characters.
Subscriber Type
V
0 Unclassified, 1 Commuter, 2 Faculty, 3 Resident, 4 Security, 5
Staff, 6 Installer, 7 Out of Service, 8 Watchman, 9 Visitor, 10
Point type, 11 Acknowledgement. This field should contain only
numeric ASCII characters.
Handicapped Type
W
0 No handicap, 1 Blind, 2 Deaf, 3 Handicapped, 4 Wheel chair. This
field should contain only numeric ASCII characters.
Transmitter ID
X
This field may be up to 9 characters. This field should contain only
numeric ASCII characters.
Away Name
Y
This field can be up to 30 characters. This field can contain any
printable ASCII character except the “?”.
Image Filename
Z
This field can be up to 30 characters. This field can contain any
printable ASCII character that is valid for a file name.
Height Feet
AA
0-7, This field should contain only numeric ASCII characters.
Height Inches
AB
0-11, This field should contain only numeric ASCII characters.