Bosch Appliances PT-400 manual Importing a Subscriber Database

Page 77

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

Page 76 Page 78
Image 77
Page 76 Page 78
Contents Security Escort Software License Agreement Limited WarrantyYou MAY You may notRemedy Table of Contents Figures Subscriber Database Advanced TablesSystem Components Security Escort System ArchitecturePoint Transmitter Maintenance TransmitterReceiver Alert UnitSoftware Overview TransponderCentral Console System Operation Alarm Sequence TransmitterTransponder Scanning Receiver’s ResponseSelected in the Security Preferences Central Console Response During AlarmOperator’s Response Central Console ScreenCentral Console Response Multiple AlarmsTest Sequence Transmitter Initial System Configuration Setting Up The SystemSystem Menus and Screens File MenuSubscriber Database Reports DatabasePhone Number Pager PasswordPager ID Pager GroupDisable Shorted Loop Enable Reed SwitchAlarm on Shorted Loop Alarm When Armed, Trouble When Disarmed on Shorted LoopTransponder Area Alarm GroupRequires Check-in DoneCreated, Modified, Modify Oper Database RecordTransponder ID Comm Port IndexEdit Data Insert NewKill Transponder Delete PointTrouble Tamper Text Trouble Type TextTrouble Response Text Show PointsPoint Type +, -, Bus + and BusData Entry After Selection of Receiver Point Type Alert 1, Alert 2, Alert 3, and Test Selection If the Enable algorithm tweaks field isAssigning Alert Units to Receivers AlgorithmLocation Video SwitcherMap FloorVirtual Fence Area CancelCut PasteUtilities Menu Restore Screen BackupFloppy a Clear Entire FileDisplay Unauthorized Alarms Turn On Alarm StrobesSound Unauthorized Alarms Turn On Outside SoundersRequire Alarm Report Limit Alarms to 1 TransponderSecurity Alarms Silent Installer Alarms SilentMan Down Delay Timer X Seconds Auto Silence Alarm In X SecondsMan down jitter timer ‘X’ Seconds Auto Reset Comm Ports ‘X’ HoursPop-up Trouble Box Contact Information System Defaults ScreenGuard Tour Minutes Not Testing Report Low Battery ReportNew Alarm Reports Weekly Maintenance Test ReportSchedules Screen View Alarm GroupsThis schedule defines the check-in times Edit Schedule TimesEllipsis … View Alarm Groups ScreenRemove AddAlarm Group # Alarm Groups ScreenAlarm Group State Screen On armedSetup Menu Printer History Filter ScreenHistory Archive File a History Archive File BTransmitter Low Battery Points, Reporting AlarmDatabase Backup and Restore Database ErrorsAnalyze Alarms Login ChangesMaster Computer Switch Point TroublesTransponder Troubles Popup Low BatteryPager AC LossOutput Device Error Bus FaultsTamper Remote Key ActivationMap Commands Pop-up Trouble and Pager DelayCommunications Port Monitor Comm Port Overload Network Comm FailureNot Responding Map Device Type MapReceived Transmission Map Strobe Red LED MapOut Of Service Map Low Battery MapPoint Out Of Service Point In ServiceClick On Output Command again Transponder On Output CommandTotal Alarms Received Using Reset Transponder TroublesSuccessful Incoming Messages Incoming Format ErrorsIncoming Retried Messages Total Outgoing MessagesTamper Map Enable Remote KeyAC Loss Map Refresh DataAlarm Differential Alarm Min LevelTest Differential ByteReceiver Configuration Screen RAM EE Buss FaultRAM Point Info RAM Point StatAbort Button to Remove a Device from the Setup Mode Red LED Strobe Reset PointOff AmbientStop Test and Reset Counters Enable RecIncoming Communication Errors Transmitting PointTotal Wrong Access Code Attempts Total Remote Access ConnectionsLast Remote Access Time Reset StatusMaximum Test Strobe Messages Maximum Low Battery MessagesMax Man Down Messages Supervision MonitorsEnable Algorithm Tweaks Show Maintenance LevelsDisplay Maintenance Alarm Sound Maintenance AlarmBring to Front on Alarm No Password TimeoutAlarm Zone Bring to Front on TroubleTransponder Comm Port Setup Screen Alarm Spot SizeLinear Depth Low DepthRemote Comm Port Setup Screen Mon PowerCarrier Det No CTSDefault Slave Computer Remote Setup ScreenPassword LF OnlyDisabled Password VerifyVideo Switcher Control Video Switcher RestoreEdit Security Escort System used for remote accessDelete DialVerify Password Access PasswordEntered into Access Password Character System ID Pager Setup ScreenPrinter Menu Hold Printer Data Select Alarm Printer ScreenSelect FormfeedCommon Open File Screen Network MenuBosch Security Systems 6/12 38947D Subscriber Image Extension Subscriber Image File PathSubscriber Image Scaling % Network Socket Status ScreenWinsock Data Screen Demo Lanyard Alarm, SubscriberAbout Menu Demo Test Subscriber 3 with low battery Demo Man Down Alarm, SubscriberDemo Maintenance Alarm Demo Maintenance TestFiles Required For Security Escort Map File Generation Scaling Image FilesSubscriber Images Security Escort Pager SetupMultiple Map Files Local Paging Setup Dial-up Paging Modem Setup Subscriber Database Advanced Screen Service and Security Alarm Pager SetupManual Pages Alarm Area SetupImporting a Subscriber Database Data Fields Excel Restrictions Required Order Column Importing a Subscriber DatabaseBosch Security Systems 6/12 38947D Autobackup to the slave database CR/LF Idle Time Multiplex Point Refresh Data 47, 53, 54 System Preferences Security Escort Technical Reference Manual Index Bosch Security Systems 38947D
Top Page Image Contents