Excel with Ease: Test Automation and QTP

Cover......Page 1
Brief Contents......Page 6
Contents......Page 8
 Preface......Page 18
 About this Book......Page 19
Section 1: Test Automation......Page 24
   History......Page 26
   Objective......Page 27
   Test Automation Key Factors......Page 28
   What to Automate......Page 30
   What not to Automate......Page 31
  Swot Analysis......Page 32
   Threats......Page 33
  Test Automation: Myths and Realities......Page 34
   Disadvantages of Automation Testing......Page 36
  Feasibility Analysis Phase......Page 37
   Need Analysis......Page 38
   ROI Analysis......Page 39
   Tool Analysis......Page 40
  Framework Design......Page 41
  Script Design......Page 42
  Maintenance......Page 43
   Practical Questions......Page 44
  Test Automation Approach......Page 45
   Waterfall Development Model......Page 46
   W-Model......Page 48
   Agile Development Model......Page 49
   Test Automation Basis......Page 51
  Test Automation—Testing Types to be Covered......Page 54
  Test Automation—Team Dynamics......Page 56
   Practical Questions......Page 58
  Framework Components......Page 59
   Modular-Driven Framework......Page 60
   Data-Driven Framework......Page 61
   Keyword-Driven Framework......Page 62
   Hybrid Framework......Page 65
   Agile Automation Framework......Page 68
    Quick Tips......Page 69
 Chapter 5: Business Model-Driven Framework......Page 70
  Framework Components......Page 71
  Architecture......Page 72
  Framework Layout......Page 74
  Framework Structure......Page 75
   Quick Tips......Page 78
   Practical Questions......Page 80
   Identifying Business Components......Page 81
   Identifying Test Scenarios within each Business Component......Page 82
   Designing Business Scenario Tables......Page 83
   Quick Tips......Page 92
 Chapter 6: Agile Automation Framework......Page 93
  Framework Components......Page 94
  Screen Components......Page 95
   Component Tables......Page 96
  Framework Structure......Page 109
   Practical Questions......Page 112
   Framework Setup......Page 113
   Test Automation Development......Page 114
   Designing SCTs......Page 120
   Designing BCTs......Page 125
   Developing Screen Component Scripts......Page 127
   Developing Business Component Scripts......Page 130
   Developing Master Driver......Page 133
  Technical/Functional Interchanges and Walk-Through......Page 134
  Configuration Management......Page 135
  Test Automation Metrics......Page 136
   Coverage......Page 137
   Progress......Page 139
   Quality......Page 140
   Process......Page 143
   Practical Questions......Page 144
 Chapter 8: Test Automation Process......Page 145
   Objective......Page 146
  ROI Analysis Process Flow......Page 147
   Total Automation Cost (TAC)......Page 148
   Objective......Page 149
  Proof of Concept......Page 150
  Framework Design Process Flow......Page 151
   Objective......Page 152
  Business Knowledge Gathering Process Flow......Page 153
  Script Design Process Flow......Page 156
  Script Execution Process Flow......Page 158
  Test Results Analysis Process Flow......Page 159
   Test Results......Page 160
   Test Result Analysis......Page 161
  Maintenance Process Flow......Page 162
  Building One-Point Maintenance......Page 163
  Version Control Strategy......Page 164
   Communication Model for New Automation......Page 165
  Test Automation Documents......Page 166
   Automation Task Tracker......Page 167
   Practical Questions......Page 168
Section 2: VBScript......Page 170
  VBScript Editors......Page 172
  VBScript Variables......Page 173
   Variable Declaration......Page 174
  VBScript Operators......Page 175
   If… Statement......Page 176
   For Next......Page 177
   While......Page 178
   Date–Time Functions (Table 9.1)......Page 179
   String Functions (Table 9.2)......Page 182
   Conversion Functions (Table 9.3)......Page 183
   Array Functions......Page 184
   Miscellaneous......Page 186
   On Error GoTo ......Page 188
   Pass an Array to a Function......Page 189
   Function to Sort Numbers......Page 190
   Function to Format Date......Page 191
   Function to Pad Zeros......Page 194
   Practical Questions......Page 195
  Methods......Page 197
  Properties......Page 199
  Creating Dictionary Object......Page 200
  Creating Dictionary of Dictionary Object......Page 201
   Practical Questions......Page 204
   Properties......Page 205
   Methods......Page 206
  Meta Characters......Page 207
  How to use VBScript Regular Expression Object......Page 208
   Match Zero or More Preceding Expression (*)......Page 209
   Match Alphanumeric Character (\\w)......Page 210
   Match Any Single Character Not within a Range [^a-z]......Page 211
  E-mail Matching......Page 212
   Searching Notepad File for a Regular Expression String......Page 213
   Practical Questions......Page 214
Section 3: Basic QTP......Page 216
 Chapter 12: QTP: Introduction......Page 218
   Record/Playback......Page 220
   Object Repository......Page 221
   Quality Center Integration......Page 222
   QTP Automation Testing Workflow......Page 223
  Using QTP Help......Page 224
   Contents Tab......Page 225
   Search Tab......Page 226
   Practical Questions......Page 227
  Object Identification Properties......Page 228
  Normal Object Identification Process......Page 229
   Smart Identification (SI)......Page 231
   Ordinal Identifier......Page 234
   Practical Questions......Page 237
   Adding Environment Variables......Page 238
   Designing Reusable Actions......Page 239
  Scripting Methods......Page 240
   Record & Playback Method......Page 241
   OR Method......Page 242
   Descriptive Programming......Page 243
   Hybrid Method......Page 244
  Scripting Guidelines......Page 245
   Practical Questions......Page 246
  When to Use Environment Variables......Page 247
  How to Define Environment Variables......Page 248
   How to Define User-Defined Internal Environment Variables......Page 249
   How to Access Environment Variablesin Test Scripts (Fig. 15.6)......Page 253
   How to Export Environment Variables from QTP Environment Tab to an External XML File......Page 254
   How to Store Arrays in Environment Variable......Page 255
   Practical Questions......Page 256
  Creating a New Library File......Page 257
  Associating a Library File to a Test Script......Page 258
  Designing Custom Library (DLL) Files......Page 259
   Designing DLL Files Using Visual Basic......Page 260
   Accessing Custom DLL Files from QTP......Page 261
   Extern Object......Page 262
   Practical Questions......Page 263
 Chapter 17: Action......Page 265
  Action Parameterization......Page 268
   Output Parameter......Page 269
   Local Reusable Action......Page 270
  Action Calls......Page 271
  Splitting an Action......Page 274
  Renaming Actions......Page 275
  Removing a Called Action from a Test Script......Page 276
   Removing Actions from Test Flow Pane (as in QTP 11.0)......Page 277
  Creating an Action Template......Page 278
   Practical Questions......Page 279
  Adding New Objects to Shared OR......Page 280
  Adding New Objects to Local OR......Page 282
  Add/Remove Object Properties......Page 283
  Associating a Shared Object Repository to a Test Script......Page 285
  Modify Object Property Values – Regular Expression......Page 286
  Highlight Application Object in Object Repository......Page 288
  Object Spy......Page 289
   Reading all Test Object Properties and Values of an Object......Page 290
  Identification and Native Properties......Page 291
  Define New Test Object......Page 292
  Analyzing Comparison Results......Page 293
  Merging Shared Object Repositories......Page 296
   Problems with Merging Object Repository......Page 298
  How to Design Object Repository......Page 299
   Default Capture Hierarchy Design......Page 300
   Functionality-Based Hierarchy Design......Page 302
   Screen Creation Time-Based Hierarchy Design......Page 303
  The Repositories Collection Object......Page 305
   Methods......Page 306
   Quick Tips......Page 307
   Practical Questions......Page 308
  Parameterize Action with Local Datatable......Page 309
  Parameterize Action with Global Datatable......Page 310
  Datatable Methods......Page 311
  How to Read All Data of Global Datasheet......Page 315
  Global Datatable Settings......Page 316
   Quick Tips......Page 317
   Practical Questions......Page 318
  Working with Browser......Page 319
   Methods......Page 320
   Browser Identification......Page 321
  Working with Page......Page 322
   Methods......Page 324
   Methods......Page 325
   Methods......Page 326
   Methods......Page 327
   Methods......Page 328
   Methods......Page 329
   Methods......Page 331
  Function to Find Cell Ordinates of a Keyword Present in WebTable......Page 333
   Usage......Page 334
   Usage......Page 335
  Exporting Webtable Values to Dictionary Object......Page 336
  Some Useful Methods......Page 341
   Usage......Page 337
   RandomNumber......Page 345
   SystemUtil......Page 346
   Setting......Page 347
   RegisterUSerFunction......Page 348
  Some Useful Examples......Page 349
   Practical Questions......Page 353
  When to Use Descriptive Programming......Page 354
   Description Objects......Page 356
  Regular Expressions......Page 357
  Child Objects......Page 359
   OR-Based Test Script Code......Page 360
  Working with Multiple Opened Browsers......Page 361
   Usage......Page 364
  Comparison of or and DP Approaches......Page 365
   Practical Questions......Page 366
 Chapter 22: Synchronization......Page 367
   Sync......Page 368
   WaitProperty......Page 369
  Defining Default Timeout Time......Page 370
   Quick Tips......Page 371
   Practical Questions......Page 372
  Checkpoint......Page 373
   QTP Inbuilt Checkpoints......Page 374
   Coded Checkpoints......Page 375
   Inserting Standard Checkpoint Using Record/Playback Method......Page 377
   Inserting Table Checkpoint Using Record/Playback Method......Page 379
   Inserting Page Checkpoint Using Record/playback Method......Page 380
   Inserting Image Checkpoint Using Record/Playback Method......Page 382
   Inserting Bitmap Checkpoint Using Record/Playback Method......Page 384
   Inserting Text Checkpoint Using Record/Playback Method......Page 386
   Scripting Coded Text Checkpoint......Page 387
   Inserting Text Area Checkpoint Using Record/Playback Method......Page 388
   Scripting Coded Text Area Checkpoint......Page 389
   Inserting Database Checkpoint Using QTP Database Checkpoint......Page 390
  Accessibility Checkpoint......Page 391
   Inserting Accessibility Checkpoint Using Record/Playback Method......Page 392
    Practical Questions......Page 393
  Breakpoints......Page 394
  Step Commands......Page 395
   Watch tab......Page 396
   Command tab......Page 398
   Quick Tips......Page 400
   Practical Questions......Page 401
 Chapter 25: Recovery Scenario and Error Handler......Page 402
  Modifying QuickTest Test Settings......Page 403
  Recovery Scenarios......Page 404
  Recovery Scenario Design......Page 405
   Methods......Page 410
  Adding Recovery Scenario to Scripts at Run-Time......Page 411
   Methods......Page 412
   Quick Tips......Page 413
   Practical Questions......Page 414
 Chapter 26: Test Results......Page 415
   Test Result Analysis......Page 416
  Test Result Filters......Page 417
  Reporter Object......Page 418
   Inserting Custom Statements in Test Results......Page 419
   Inserting Image Files in Test Results......Page 420
  HTML Test Results......Page 422
  Setting Test Run Options......Page 423
   Local System Monitor Settings......Page 424
   Quick Tips......Page 425
   Practical Questions......Page 426
  Open PuTTY......Page 427
   Function to Execute Batch/Job File on PuTTY Window......Page 428
   Methods......Page 431
  Managing Folders......Page 433
   Methods......Page 434
  Enumerating Files and Folders......Page 435
   Enumerating Sub Folders......Page 436
   Enumerating Files Inside Sub Folders......Page 437
   Windows Task Manager......Page 438
   Windows Environment Variables......Page 440
   Scheduling Script Execution......Page 441
   System Computer Name and Username......Page 442
   Extern Object......Page 443
   Practical Questions......Page 444
Section 4: Advanced QTP......Page 446
 Chapter 29: QTP Automation Object Model......Page 448
  Launching QuickTest......Page 449
   Setting DCOM Configuration Settings......Page 450
   Executing Desired Test Script on Remote QTP Machine......Page 451
   Methods......Page 452
  Objectrepositories Collection Object......Page 455
   Methods......Page 456
   Properties......Page 457
   Methods......Page 458
   Properties......Page 460
   Methods......Page 461
   Properties......Page 463
   Properties......Page 464
   Properties......Page 466
   Properties......Page 468
   Methods......Page 472
   Properties......Page 476
   Practical Questions......Page 479
  HTML DOM......Page 480
   HTML Element Object......Page 481
   Document Object Methods......Page 482
   Quick Tips......Page 490
   Practical Questions......Page 491
  Methods......Page 492
  Properties......Page 494
  Append Data to an Existing Notepad File......Page 495
   Practical Question......Page 498
  Excel Object Model......Page 499
   Creating a New Workbook and Worksheet......Page 500
   Open an Existing Workbook......Page 501
   Read an Excel Workbook......Page 502
   Search for a String in Excel Workbook......Page 503
   Replace All Occurrences of a String with Another String in Excel Workbook......Page 504
   Modifying Excel Cell Properties......Page 505
   Deleting all Blank Rows of a Worksheet......Page 506
   To Access Data of an Already Opened Excel File......Page 507
  Excel Object Browser......Page 508
  Excel as Database......Page 509
   DSN-less Connection......Page 511
   Quick Tips......Page 517
   Practical Questions......Page 518
  Connection Object......Page 519
   Methods......Page 520
   Property......Page 521
  Connection to a Database......Page 522
   DSN Connection......Page 523
   DSN-less Connection......Page 524
  Connecting to MS Excel Database......Page 525
  Connecting to MS Access Database......Page 526
  Connecting to MS SQL Server Database......Page 527
  Connecting to Oracle Database......Page 528
  Function to Execute Query on Oracle DB......Page 529
   Practical Questions......Page 532
  XML Structure......Page 533
   Methods......Page 534
   Properties......Page 535
   Loading XML File......Page 536
   Reading XML File......Page 537
   Converting XML to Excel File......Page 538
   Exporting XML Data to Array......Page 539
   Practical Questions......Page 541
  Word Automation Object Model......Page 542
   Creating a New Document......Page 543
   Adding Picture to Documents......Page 544
   Formatting Text in Documents......Page 545
   Searching for Text in Documents......Page 546
   Replacing Texts in Documents......Page 547
   Creating Tables in Documents......Page 548
   Practical Questions......Page 549
  Microsoft Outlook......Page 550
   Object Model......Page 551
   Login to Outlook......Page 552
   Sending an E-mail......Page 553
   Outlook Security Dialog Box......Page 554
   Enumerating Mailbox Folders......Page 556
   Reading E-mail Messages......Page 557
   Launching Lotus Notes......Page 559
   Sending E-mail with Attachments......Page 560
   Sending E-mails using Telnet via Gmail......Page 562
   Launching QTP Using an E-mail Trigger......Page 565
   Practical Questions......Page 566
  Integrating QTP with QC......Page 567
   QC Database......Page 569
   Connecting QTP with QC Database......Page 570
   Export QC Test Cases to Excel Via QTP......Page 572
   Export QC Test Cases to Excel without QTP......Page 575
   Executing QC Test Suite Using an E-mail Trigger......Page 580
   Practical Questions......Page 584
Section 5: Test Automation Lab......Page 586
  Introduction......Page 588
   Components......Page 589
   Workflow......Page 591
   Test Automation Manager: Overview......Page 592
Section 6: Functional Testing 11......Page 598
   New Run Results Viewer......Page 600
   Log Tracking......Page 601
   Use Extensibility Accelerator for Web Add-in Extensibility Development......Page 602
   New Object Spy Functionality......Page 603
   Add Images to Run Results......Page 604
   Web Add-in Extensibility Enhancements......Page 605
   New Supported Sperating Systems and Environments......Page 606
   New browsers supported by QTP 11......Page 607
 Chapter 40: Business Process Testing......Page 608
  Life Cycle of BPT......Page 610
  Creating Business Components......Page 615
  Defining Component Details......Page 616
  Adding Snapshot......Page 617
  Defining Business Component Parameters......Page 618
   Defining Output Parameters......Page 619
  Adding Design Steps......Page 620
  Converting Manual Component to Automated Component......Page 621
  Creating Business Process Tests......Page 622
   Creating Business Process Test......Page 623
   Adding Components to a Business Process Test......Page 624
   Defining Input Parameters of the Business Components......Page 625
  Debugging Business Process Tests......Page 628
  Creating Test Set......Page 630
  Executing Test Set......Page 631
  Creating Application Area......Page 636
Appendices......Page 638
 Appendix A—Test Script Template......Page 640
 Appendix B—Scripting Guidelines......Page 641
  Action Naming Convention......Page 642
 Appendix D—Script Review Checklist......Page 643
 Appendix E—Test Tool Evaluation Chart......Page 645
 Appendix F—Object Identification Standards for a Typical Web Application......Page 646
 Appendix G—Quicktest Pro System Requirements......Page 647
 Appendix H—HP Functional Testing 11 Product Availability Matrix......Page 649
 HP Quicktest Professional 11.00 Product Availability Matrix Appendix......Page 663
Index......Page 666