Security Command R500 Specifications Page 453
- Page / 584
- Table of contents
- TROUBLESHOOTING
- BOOKMARKS
Rated. / 5. Based on customer reviews
Configuring ODBC Data Exchange Reports
PlantScape Server and Client Configuration Guide 435
smallfloat = 0.000000e+00
where name=’01SQLANA’
plscpcg.book Page 435 Monday, May 28, 2001 10:11 AM
- PlantScape 1
- Honeywell Trademarks 2
- Support and Other Contacts 2
- Training Classes 3
- Related Documentation 3
- 7 Configuring Controllers 7
- 8 Configuring Points 7
- 9 Configuring Alarm Paging 8
- 13 Configuring Reports 10
- Contents 11
- 16 Configuring Schedules 13
- 17 Configuring Recipes 13
- 21 Command Reference 15
- 22 Troubleshooting Advice 16
- Glossary 17
- 1 About This Guide 19
- Before Reading This Guide 20
- How to Use This Guide 21
- 1 – About This Guide 22
- 2 Configuration Overview 23
- Quick Builder 24
- Control Builder 25
- Display Builder 25
- PlantScape Server Utilities 26
- Server Scripting 27
- Configuration Procedures 28
- 3 Configuration Tutorial 31
- Assumptions 32
- 3 – Configuration Tutorial 36
- Defining a Station 37
- Defining a Serial Connection 41
- Downloading the Database 54
- Starting the Stations 56
- What Next? 69
- 4 Using Quick Builder 71
- Quick Builder Overview 72
- Copying Project Files 73
- Backing Up Project Files 74
- About Station 76
- Connection Methods 77
- Startup Pages 77
- Associated Stations 78
- Station Setup Files 78
- SafeBrowse 78
- “Station.ini” on page 83 79
- Printers 80
- Setting Up Station 81
- Configuring Timeout 85
- Configuring Startup Pages 85
- Configuring Alarms 86
- Connections Tab 87
- Displays Tab 88
- Toolbars Tab 88
- Sounds Tab 89
- Web Access Tab 89
- Toolbars Dialog Box 91
- Command Properties Dialog Box 92
- Server Display Program 93
- Pushbutton Interrupt Codes 95
- Server Wide Settings 96
- Station Alarm Settings 97
- Alarm Summary Options 97
- Station Configuration Display 98
- Start Up/Idle Timeout Action 99
- Printer Assignment 99
- Area Assignment Tab 100
- Station.ini 101
- WindowsObjects= 106
- Keyboard Service Program 107
- Area profiles page 93 109
- To learn about Go to: 109
- Areas page 92 109
- Configuring areas page 92 109
- Defining and Enabling Areas 110
- Area Profiles 111
- Configuring Area Lists 112
- Configuring Area Time Periods 112
- Configuring Area Profiles 113
- 7 Configuring Controllers 115
- Monitoring Communications 117
- Communications Redundancy 118
- Defining Channels 119
- Setting Flow Control 120
- Defining Channels 121
- 7 – Configuring Controllers 122
- 104 R400 122
- 1 Shield Signal Shield 122
- 2 TXD Transmit serial data 122
- To other RS-422 devices 123
- To other RS-485 devices 124
- Defining Controllers 125
- Testing Communications 126
- Enabling a Channel 127
- Enabling a Controller 127
- 110 R400 128
- Information 130
- 114 R400 132
- 8 Configuring Points 133
- About Points 134
- About Points 135
- Point Types 136
- Point Servers 137
- Main Properties 138
- Point ID 139
- Description 140
- Area Code 140
- Scanned Point Parameters 140
- Status Point Parameters 141
- 8 – Configuring Points 142
- 124 R400 142
- Status Point Output (OP) 143
- Status Point Mode (MD) 143
- Analog Point Parameters 144
- Main Properties 145
- 128 R400 146
- Analog Output (OP) 147
- Accumulator Point Parameters 148
- Controller ServerField 149
- Flow Meter 149
- Accumulator Point 149
- AZGALLONS 149
- Rawcounts 151
- Address Types 162
- Point Scanning 163
- Exception Scanning 164
- Scan Packets 165
- 148 R400 166
- Control Properties 167
- Pulse Width 168
- Control Confirmation 170
- Control Modes 171
- Control Level 172
- Reverse Output 172
- Configuring Alarms for Points 173
- 160 R400 178
- Accumulator Point Alarm Types 180
- Elevating the Alarm Priority 181
- Disabling Alarming 183
- 166 R400 184
- Types of History Collection 185
- Extended History 186
- Fast History 186
- Configuring History Archiving 188
- Creating History Archives 190
- Removing History Archives 192
- Associated Displays 193
- Group Faceplate Templates 194
- 178 R400 196
- Advanced Point Configuration 197
- Using Auxiliary Parameters 198
- Building Points Off-Scan 199
- Real Value 201
- Instrument Value 201
- Reserved Data Format Names 204
- External Alarm Notification 205
- Configuring Unanswered Alarms 206
- Customizing Alarm Colors 206
- Point Processing Limits 207
- 190 R400 208
- Scanning Scheduling 209
- Configuring Algorithms 211
- Action Algorithms 212
- Defining Algorithms 213
- Finding Free Algorithm Blocks 214
- 9 Configuring Alarm Paging 215
- 198 R400 216
- Configuring Alarm Paging 217
- Alarm Paging Settings 218
- Configuring Alarm Paging 219
- Configuring Modem Information 221
- Configuring Pager Details 223
- 206 R400 224
- Nominating Alarms to be Paged 225
- Enabling Pagers 226
- Alarm Message Content 226
- About Security 228
- About Station-Based Security 229
- About Operator-Based Security 229
- About Security Levels 230
- Defining an Operator 234
- About Operator Passwords 236
- Password Administration 236
- Operator Failed Login Alarms 237
- 220 R400 238
- Assigning Areas to Stations 240
- Assigning Areas to Operators 240
- Assigning Areas to Displays 241
- 224 R400 242
- Configuring Group and Trend 243
- Displays 243
- Configuring Groups 244
- Creating Groups 245
- Modifying Groups and Points 246
- Deleting Groups and Points 246
- Navigating to Group Displays 246
- Custom Navigation Methods 247
- About Trend Set Displays 248
- Trend Set Display Types 249
- Related Display Types 249
- Creating Trend Sets 250
- Changing Trend Sets 251
- High Range 252
- Low Range 252
- Calling Up Trend Set Displays 253
- 236 R400 254
- 238 R400 256
- 13 Configuring Reports 257
- Report Types 258
- Additional Custom Reports 259
- Configuring Reports 260
- Configuring a New Report 261
- 13 – Configuring Reports 262
- 244 R400 262
- Configuring Reports 263
- 246 R400 264
- Alarm and Event Reports 266
- Alarm and Event Reports 267
- Alarm Duration Reports 268
- Alarm Duration Reports 269
- Cross Reference Reports 270
- (rptxxx.htm): 271
- Downtime Analysis Reports 272
- History Archive 273
- Point Attribute Reports 274
- Sequence of Events Reports 275
- Batch Reports 276
- Yes, the incremental re-run 278
- Creating a Points List 279
- Batch Report Filenames 279
- ODBC Data Exchange Reports 282
- Microsoft Excel Reports 283
- 266 R400 284
- Security Issues 285
- Free Format Reports 288
- Free Format Report Reference 290
- Formatting Section 291
- Using Point Values 292
- Performing Calculations 292
- Working with Historical Data 293
- Formatting the Report Output 294
- A (Acquired Field Value) 296
- B (Start of Report Body) 297
- F (Fetch From Point) 301
- 284 R400 302
- Print_Format 302
- [History Type] 302
- Examples 303
- 286 R400 304
- G (Give to Point) 305
- P (Perform Calculation) 308
- R (Read From File) 309
- T (Totalize History) 312
- W (Write to File) 313
- 296 R400 314
- X (Demand Point Processing) 315
- Free Format Report Example 316
- Report Output 317
- Configuring and Monitoring a 319
- Redundant Server System 319
- 302 R400 320
- Network Redundancy 321
- Station Network Redundancy 322
- Single Network Configuration 324
- Dual Network Configuration 326
- 310 R400 328
- Redundant Arbitration 329
- 312 R400 330
- DEL LNK00 331
- ADD LNK00 NETWORK_LINK 331
- %SystemRoot% 333
- 316 R400 334
- 318 R400 336
- Monitoring Redundant Servers 339
- Synchronizing Other Files 342
- Synchronizing Other Files 343
- 326 R400 344
- If the Primary Server Fails 346
- If the Backup Server Fails 347
- 330 R400 348
- 332 R400 350
- 334 R400 352
- Architecture 353
- Overview 354
- Plant-Wide Network 355
- Data Access 356
- Point IDs 357
- Point Count Licensing 358
- Distributed Server Displays 359
- Notifications 361
- Alarm Message Index 362
- Journalled Events 362
- Journalled Operator Changes 363
- Extended Event Archiving 364
- Downtime Analysis 364
- Security 365
- Working with Algorithms 366
- Configuring Hardware Items 366
- Performance Considerations 366
- Multicasting 367
- Operator Keyboard Support 368
- Internationalization 368
- Configuring “This Server” 370
- Distributed Server Tuning 372
- 356 R400 374
- 16 Configuring Schedules 375
- About the Schedules Option 376
- Configuring Holidays 377
- Configuring Shifts 377
- 16 – Configuring Schedules 378
- 360 R400 378
- Selecting a Schedule 380
- Adding a Schedule 380
- Deleting a Schedule 381
- 364 R400 382
- 17 Configuring Recipes 383
- About Recipe Configuration 384
- Configuring Recipes 386
- Configuring Recipes 387
- Chaining Recipes 388
- Configuring Custom Reports 389
- Field Description Data Type 391
- 17 – Configuring Recipes 392
- 374 R400 392
- Configuring Downtime Analysis 393
- About Downtime Analysis 394
- Configuring Downtime Reasons 395
- 380 R400 398
- 382 R400 400
- Configuring Extended Event 401
- Archiving 401
- Tape Drives for Archiving 402
- 390 R400 408
- Applications 409
- PlantScape ODBC Support 410
- Configuring a Data Source 412
- 398 R400 416
- Point Tables 417
- 400 R400 418
- Event Tables 422
- History Tables 423
- 406 R400 424
- Case-Sensitive Searches 425
- Troubleshooting ODBC Driver 425
- Step 1. Linking Tables 426
- Step 2. Viewing Tables 428
- 416 R400 434
- 418 R400 436
- Making a Report Secure 437
- 420 R400 438
- Creating SQL Transactions 439
- 422 R400 440
- Checking Commands 442
- Point Reference Type 443
- DD-MMM-YY 445
- HH:MM:SS 445
- Parameter 446
- Table Reference Type Report 447
- DD-MMM_YY HH:MM 448
- SQL Report Example 450
- 434 R400 452
- PlantScape OPC Support 454
- Accessing OPC Server Data 455
- PlantScape Data Addressing 456
- PlantScape OPC Support 457
- PV VT_I4 yes 457
- Mode VT_I4 yes 457
- Network API 470
- Retrieving Point Parameters 472
- Using Cell Formulas 474
- Functions 477
- NAPI_rputdat_double 478
- NAPI_rputdat_str 478
- Formula Arrays 479
- GetHistVal_Date 481
- GetHistVal_Offset 482
- GetHistValArray_Date 483
- 466 R400 484
- GetHistValArray_Offset 485
- GetPointVal 486
- GetPointValArray 487
- NAPI_rGetdat_int 488
- NAPI_rGetdat_float 488
- NAPI_rGetdat_double 488
- NAPI_rGetdat_long 488
- NAPI_rGetdat_str 489
- NAPI_rGethstpar_date 490
- NAPI_rGethstpar_ofst 491
- NAPI_rGetPnt_Num 492
- NAPI_rGetPnt_Status 493
- NAPI_rGetVal_Ascii 494
- NAPI_rGetVal_History 495
- NAPI_rGetVal_Number 496
- NAPI_rPutdat_int 497
- HSSERVA 498
- NAPI_rPutdat_float 499
- NAPI_rPutdat_double 499
- NAPI_rPutdat_long 499
- NAPI_rPutdat_str 499
- NAPI_rPutVal_Number 500
- 21 Command Reference 501
- 21 – Command Reference 502
- 484 R400 502
- 486 R400 504
- Disk Space Considerations 506
- Configuration Commands 511
- 494 R400 512
- 496 R400 514
- Configuration Commands 517
- 500 R400 518
- 502 R400 520
- Part Description 520
- PlantScape Control Panel 523
- 506 R400 524
- Diagnostic Commands 527
- Administration Commands 534
- 522 R400 540
- 524 R400 542
- 526 R400 544
- 530 R400 548
- 22 Troubleshooting Advice 549
- Miscellaneous Tips 554
- Glossary - 2 556
- Glossary - 4 558
- Glossary - 6 560
- Glossary - 8 562
- Glossary - 10 564
- Glossary - 12 566
- Glossary - 14 568
- Glossary - 16 570
- Index - 14 R400 584
Related products and manuals for Security access control systems Security Command R500
(40 pages)© 2020, manymanuals.com. All rights reserved. | 0.028 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals