Bosch Appliances PT-400 Manual

A SERVICE OF

next previous

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.