Security Command R500 Spécifications Page 431
- Page / 584
- Table des matières
- DEPANNAGE
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
Configuring the PlantScape ODBC Driver
PlantScape Server and Client Configuration Guide 413
Building a History Query
The format for history queries is slightly different from other queries because the
names of points are system-configurable.
To build a query which retrieves the 5-second snapshot values of your sinewave
point over a 10 minute period:
1
Select the Queries tab.
2
Click New, select Design View and click OK to display the Show Table
dialog box.
3
Select History5SecSnapshot, click Add, then close the dialog box.
4
In the first row/first column click the left mouse button and select
TimeStamp from the drop-down list.
In the Criteria row add:
> 8:30 24/5/98 AND < 8:40 24/5/97
(using the actual timespan of your choice)
5
In the second column select Parameter001.
In the Criteria row add:
=’sinewave.PV’
6
In the third column select Value001.
7
In the fourth column select Quality001.
8
Select View
⇒
Datasheet to send the query to your PlantScape database.
Using PlantScape ODBC Driver and Microsoft SQL Server
This section assumes that you have already completed the installation and
configuration of your PlantScape system with the ODBC driver.
It assumes that you have:
• Installed the PlantScape Server software
• Installed the ODBC Client software on a client computer
• Configured a data source on the client computer
• Installed Microsoft SQL Server on the client computer
• Started the PlantScape system on the server computer
plscpcg.book Page 413 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
Produits connexes et manuels pour Systèmes de contrôle d'accès de sécurité Security Command R500
(40 pages)© 2020, manymanuals.fr. Tous droits réservés | 0.088 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels