Bosch Appliances PT-400 manual Importing a Subscriber Database

Page 76

Security Escort Technical Reference Manual

EN 76

7.0 Importing a

Subscriber Database

This section describes the file format required to import data into the Subscriber Database. There is no way to undo this operation, therefore, DO A DATABASE BACKUP FIRST and verify the updated data before the changed database is placed in service. If there are problems, restore the Subscriber Database from the backup.

The file of new data record entries must be in tab delimited text format. It must be placed in the Security Escort subdirectory (typically C:\Escort) and be named TABMERGE.DAT. The data fields must be in the following order, delimited by the horizontal tab character (decimal 8), and the record must be terminated with a carriage return (decimal 13). If a data field has no data, store the terminating tab character for that field. The total number of characters in all the fields of a record must be 255 characters or less, including the tab and carriage return characters. After the TABMERGE.DAT file is stored in the Security Escort subdirectory, start ESC32.EXE, enter the Subscriber Database, and click the DATA MERGE button. Be patient, it may take a while. Watch for the disk activity to stop. After the data is successfully merged, it is a good idea to remove the TABMERGE.DAT file to disable the DATA MERGE feature.

Bosch Security Systems 6/12 38947D

Image 76

Contents Security Escort Limited Warranty Software License AgreementYou MAY You may notRemedy Table of Contents Figures Tables Subscriber Database AdvancedSecurity Escort System Architecture System ComponentsMaintenance Transmitter Point TransmitterReceiver Alert UnitCentral Console TransponderSoftware Overview Alarm Sequence Transmitter System OperationTransponder Scanning Receiver’s ResponseCentral Console Response During Alarm Selected in the Security PreferencesOperator’s Response Central Console ScreenTest Sequence Transmitter Multiple AlarmsCentral Console Response Setting Up The System Initial System ConfigurationSystem Menus and Screens File MenuReports Database Subscriber DatabasePager Password Phone NumberPager ID Pager GroupEnable Reed Switch Disable Shorted LoopAlarm on Shorted Loop Alarm When Armed, Trouble When Disarmed on Shorted LoopAlarm Group Transponder AreaRequires Check-in DoneDatabase Record Created, Modified, Modify OperTransponder ID Comm Port IndexInsert New Edit DataKill Transponder Delete PointTrouble Type Text Trouble Tamper TextTrouble Response Text Show Points+, -, Bus + and Bus Point TypeData Entry After Selection of Receiver Point Type If the Enable algorithm tweaks field is Alert 1, Alert 2, Alert 3, and Test SelectionAssigning Alert Units to Receivers AlgorithmVideo Switcher LocationMap FloorCancel Virtual Fence AreaCut PasteUtilities Menu Backup Restore ScreenFloppy a Clear Entire FileTurn On Alarm Strobes Display Unauthorized AlarmsSound Unauthorized Alarms Turn On Outside SoundersLimit Alarms to 1 Transponder Require Alarm ReportSecurity Alarms Silent Installer Alarms SilentAuto Silence Alarm In X Seconds Man Down Delay Timer X SecondsMan down jitter timer ‘X’ Seconds Auto Reset Comm Ports ‘X’ HoursGuard Tour Minutes System Defaults ScreenPop-up Trouble Box Contact Information Low Battery Report Not Testing ReportNew Alarm Reports Weekly Maintenance Test ReportView Alarm Groups Schedules ScreenThis schedule defines the check-in times Edit Schedule TimesView Alarm Groups Screen Ellipsis …Remove AddAlarm Groups Screen Alarm Group #Alarm Group State Screen On armedSetup Menu History Filter Screen PrinterHistory Archive File a History Archive File BPoints, Reporting Alarm Transmitter Low BatteryDatabase Backup and Restore Database ErrorsLogin Changes Analyze AlarmsMaster Computer Switch Point TroublesLow Battery Transponder Troubles PopupPager AC LossBus Faults Output Device ErrorTamper Remote Key ActivationPop-up Trouble and Pager Delay Map CommandsCommunications Port Monitor Comm Port Overload Network Comm FailureDevice Type Map Not Responding MapReceived Transmission Map Strobe Red LED MapLow Battery Map Out Of Service MapPoint Out Of Service Point In ServiceOn Output Command Click On Output Command again TransponderTotal Alarms Received Using Reset Transponder TroublesIncoming Format Errors Successful Incoming MessagesIncoming Retried Messages Total Outgoing MessagesEnable Remote Key Tamper MapAC Loss Map Refresh DataAlarm Min Level Alarm DifferentialTest Differential ByteRAM EE Buss Fault Receiver Configuration ScreenRAM Point Info RAM Point StatAbort Button to Remove a Device from the Setup Mode Reset Point Red LED StrobeOff AmbientEnable Rec Stop Test and Reset CountersIncoming Communication Errors Transmitting PointTotal Remote Access Connections Total Wrong Access Code AttemptsLast Remote Access Time Reset StatusMaximum Low Battery Messages Maximum Test Strobe MessagesMax Man Down Messages Supervision MonitorsShow Maintenance Levels Enable Algorithm TweaksDisplay Maintenance Alarm Sound Maintenance AlarmNo Password Timeout Bring to Front on AlarmAlarm Zone Bring to Front on TroubleAlarm Spot Size Transponder Comm Port Setup ScreenLinear Depth Low DepthMon Power Remote Comm Port Setup ScreenCarrier Det No CTSRemote Setup Screen Default Slave ComputerPassword LF OnlyPassword Verify DisabledVideo Switcher Control Video Switcher RestoreSecurity Escort System used for remote access EditDelete DialAccess Password Verify PasswordEntered into Access Password Character System ID Pager Setup ScreenPrinter Menu Select Alarm Printer Screen Hold Printer DataSelect FormfeedNetwork Menu Common Open File ScreenBosch Security Systems 6/12 38947D Subscriber Image File Path Subscriber Image ExtensionSubscriber Image Scaling % Network Socket Status ScreenAbout Menu Demo Lanyard Alarm, SubscriberWinsock Data Screen Demo Man Down Alarm, Subscriber Demo Test Subscriber 3 with low batteryDemo Maintenance Alarm Demo Maintenance TestFiles Required For Security Escort Image Files Map File Generation ScalingMultiple Map Files Security Escort Pager SetupSubscriber Images Dial-up Paging Modem Setup Local Paging SetupService and Security Alarm Pager Setup Subscriber Database Advanced ScreenAlarm Area Setup Manual PagesImporting a Subscriber Database Importing a Subscriber Database Data Fields Excel Restrictions Required Order ColumnBosch 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