Bosch Appliances PT-400 manual Importing a Subscriber Database

Security Escort Technical Reference Manual 7.0 Importing a

Subscriber Database

EN 77

Table 1:Importing a Subscriber Database

Data Fields in	Excel	Restrictions
Required Order	Column
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	C	This	field	can	be	up	to	sixteen characters. This field can contain
Number		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	I	This	field	can	be	up	to	sixteen characters. This field can contain
Number		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	O	This	field	can	be	up	to	254 characters. This field can contain any
Text Field 1		printable ASCII character except the “?”.
Supplemental	P	This	field	can	be	up	to	254 characters. This field can contain any
Text Field 2		printable ASCII character except the ‘?”.
Supplemental	Q	This	field	can	be	up	to	254 characters. This field can contain any
Text Field 3		printable ASCII character except the “?”.
Supplemental	R	This	field	can	be	up	to	254 characters. This field can contain any
Text Field 4		printable ASCII character except the “?”.
Pager Phone	S	This	field	can	be	up	to	16 characters. This field can contain only
Number		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.

Bosch Security Systems 6/12 38947D