Excel with Ease: Test Automation and QTP

✍ Scribed by Gupta, Rajeev

• Tongue: English
• Leaves: 673
• Category: Library

✦ Table of Contents

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