[hemmerling] Application Lifecycle Management ( ALM ) 2/2

Related pages:

• Application Lifecycle Management ( ALM ) 1/2.
• Project Management Software & Software to be used in Projects.
• Requirements.
• Team Software, Collaboration Software, Groupware & Application Lifecycle Management.
• Testing.
• Scripting Programming Languages for Windows 1/3.

• Localhost "HP ALM Help / API" - "HP ALM Open Test Architecture API Reference" of “HP Quality Center Community Edition”.
  • “The OTAClient.dll is downloaded to the following folder: 'C:\Users\<client user name>\AppData\Local\HP\ALM-Client\<server name>\OTAClient.dll'” ( e.g “C:\Users\Administrator\AppData\Local\HP\ALM-Client\localhost\OTAClient.dll” ).
  • The online HTML documents about OTA feature many VBScript examples & many C# examples.

• “Z:\ALM_Win32\TARGETDIR\resources\docs\Help.zip” of the HPQC11.52 ISO image contains all documentation, including a complete PDF and HTML documentation.
  • The online HTML documents about OTA feature many VBScript examples & a single C# example.

• GitHub "ro0sterjam/ HPQCConnector / OTA_API_Reference.chm" ( 2009 ), 5.43 MBytes.
• On Vista / Win7 / Win8, You must “unblock” the Microsoft Help file ( .chm ) in the properties.
• The OTA API reference of 2009 differs much from the 2002-2007 edition!

• Complete NNIT "HP Quality Center 9.2" Documentation.
  • NNIT "HP Quality Center 9.2" Documentation, "API Reference Documentation"
    1. “OTA_API_Reference.chm” ( 2002-2007 ), 4.315 MBytes.
    2. “Site_Admin_API_Reference.chm”.
    3. “custom_test_type.chm”.
    4. “quality_center_db.chm”.
• On Vista / Win7 / Win8, You must “unblock” the the Microsoft Help files ( .chm ) in the properties.
• The OTA API reference of 2002-2007 differs much from the later 2009 edition! Some say it provides much richer informations than the later 2009 edition!

• HP Enterprise Business Community "Quality Center Support and News Forum", Thread "OTA API Book in PDF format" - “Mercury Test Architecture Guide 8.2 SP1” ( “OTA_FormataTemplatesTD4QC-v8.pdf” ) is available for download.

• Localhost "HP ALM Help / API" - "HP ALM REST API" of “HP Quality Center Community Edition”.

• YouTube.
  • YouTube - Search for "qc ota -6qc".
  • YouTube "QC OTA & QTP - How to schedule a recurring tesstset".

• You may use VBScript scripts to implement a tool-internal workflow.
• For accessing and controlling HPQC from outside by OTA or REST interface, you may use “any” software platform ( e.g. VBScript, C#, Python, Java,..).

• “HPQC Community Edition 12.20” is shipped - as earlier editions too - with the Microsoft Script Editor.
  1. Login with the “ALM Desktop Client”.
  2. Click on the gear-wheel in the right top corner
  3. Select tbe menu item “Customize...”, so that the screen “Application Lifecycle Management - Customization” is displayed.
  4. Click on the item “Workflow”, so that the screen “Workflow” is displayed.
  5. Click on the link “Script Editor. Enables you to write VBScript code for all modules. You can also sue the Script Editor to modify the script generated4 by the above tools”. The VBScript editor loads in an extra Windows window.
  6. Click on the red window close button [x] in the right upper corner to close the tool.
  7. Click on the link “Return” in the upper right corner of the browser application, to return to the application.
• There is no “File / Load” menu item. So you may import data by copy+paste via Clipboard, but you can´t load a file . File saving is supported.

• The Shareware VBScript editor VbsEdit for Windows.
  • “The evaluation version never expires”.
  • For calling 64-bit only HPQC12 by 32-bit only OTA API ( of HPQC12 ), you must run the 32-bit edition of VbsEdit, i.e. “VbsEdit 32-bit” ( at mouse-rightclick ).
• “Microsoft Script Editor”.
  • EN.Wikipedia "Microsoft Script Editor".
  • With German “Microsoft Word 2000”, it is available at the menu item “Extras Makro / Microsoft Skript-Editor” . At ”? / Info” it calls itself “Microsoft Entwicklungsumgebung 6.0”.
  • I was told by experts, that Microsoft offers / offered an affordable license to integrate the “Microsoft Script Editor” into software applications, and so to ship the binary applications with integrated “Microsoft Script Editor”. This might be useful if the application can be controlled from external VBScript scripts by Windows interface.

• Official instructions:
  • Localhost "HP ALM Open Test Architecture API Reference" - “Download and register the library for the server by running the Client Registration add-in. Open the Help menu and select Add-ins Page. On the Add-ins Page, select HP ALM Client Registration. At the bottom of the Add-ins Page, run Register HP ALM”.
• What do you really need to do?
  • At Localhost "HP ALM Client Registration", please click on the links
    • Register HP ALM.
    • Register HP ALM Site Administration.

• Search for Programs
  • For Win7, execute “Start / Run”
  • For Win8.
    • Please click on “Windows” button.
    • On the blue Windows app screen, please click on the search button “Magnifying Glass”.
• Type ”%windir%\SysWoW64\cmd.exe” and click on the “Ok” button, to launch 32-bit COMMAND.COM.
• Execute your script: “cscript vbscriptfile.vbs”.

• Call “Regedit”.
• Modify the Registry key „HKEY_CLASSES_ROOT\VBSFile\Shell\Open\Command”
  • From '%SystemRoot%\System32\WScript.exe ”%1”%*'.
  • To '%SystemRoot%\SysWOW64\WScript.exe ”%1”%*'.

• You must run the 32-bit edition of Shareware VBScript editor “VbsEdit” ( i.e. “VbsEdit 32-bit” at mouse-rightclick ), to address 64-bit only HPQC12 via 32-bit only OTA API of HPQC12.

Dim QCConnection
Set QCConnection = CreateObject("TDApiOle80.TDConnection")
MsgBox("Connect to QC Server")
 
QCConnection.InitConnectionEx "http://localhost:8080/qcbin"
MsgBox("Connection Established.")

QCConnection.login "sa", "123456789012"
MsgBox("Login Authenticated.")

• The Making of Software. software engineering applied "Quality Center Workflow Debugging".
  • “Users of HP Quality Center (HP QC) who do workflow programming often suffer from the very limited – not to say: lacking – support that HP QC offers for debugging of workflow code. It can easily happen that programmers spend hours in search of a tiny but nasty defect”.
  • “But there is help that greatly improves workflow programming and debugging in HP QC: You may use Microsoft Visual Studio (MVS) as a debugging environment for HP QC workflow programs. You can then add breakpoints, inspect variables, step through programs, and much more”.

• Code Project "QC DATA PULLER using C#".
• codeOtel "How to connect HP Quality Center using C# and ASP.net".
• Aaron Evans.
  • GitHub "fijiaaron".
    • GitHub "fijiaaron/QCIntegration" - “This is a sample utility written in C# that uploads test results into Quality Center from a csv file. It uses the Open Test Architecture (OTA) API for communicating with Quality Center”.
  • fijiaaron.
    • fijiaaron - Search articles about "qc".
    • fijiaaron "Updating test results in QC using the QC OTA API explained".
    • fijiaaron "Executing Tests in Quality Center using the OTA API".
• QualityCenterAPI.
  • QualityCenterAPI "C# .NET program that uses the Quality Center API".

• Google - Search for "ota com python", Google - Search for "ota python".
• Jds "Generating Custom Reports with Quality Center OTA using Python".
• Polteq. Leaders in software testing "Mission-critical software testen. Technisch en non-traditioneel testen bij Polteq "Retrieve all testcase data with HP QC OTA and Python"
• Python Test Scripts "Python with HP Quality center".
• StackOverflow.
  • StackOverflow "Reading specific test steps from Quality Center with python".
  • StackOverflow "Automating HP Quality Center with Python or Java" - “But I think the real question here is, why would you want to do it in Python or Java. Why not write what you need directly in QC using it's Workflow feature. Which will allow you to write your logic in VBScript, and have it invoked inside QC UI on user actions. For instance you can bind to the Post event of a Defect / Bug and check if there is a comment and if there is not prompt the user directly with a message”.
  • W3facility "Quality Center OTA API – TDFilter using Python" - VBScript 'testSetFilder.Filter(“CY_CYLE”) = ”>= 0”' → Python “SetFilter()”.
• Xceptance Blog "HPQC and XLT – Integration Example".

• Worksoft "How to run a HP QC script without calling Certify" → VAPI XP.

• Blog The Knowledge Hub // Archive "Open Test Architecture(OTA)" → VB?.
• Quick Test Professional Tutorial "Quick Test Professional (QTP) - QC Open Test Architecture (OTA)" → VB?.
  • “Example 1: How to Connect to Quality Centre using OTA API”.
  • “Example 2: How to Use Filter method to filter the results (Bug Factory)”.
  • “Example 3: Find a specified requirement in a specified folder”.
  • “Example 4: How to Create a Test using OTA”.
• SQA Forums.
  • SQA Forums "Mercury QC OTA Bug Filter Examples" - “The example from the helpfile works, but I need to set the criteria to find a range of values, not just a single one” → VB.
• User-friendly Tech-Help "How to log a Bug in ALM using OTA?" → VB?.
• Testing Concepts. Learn, Experience and Spread the Joy.
  1. Testing Concepts. Learn, Experience and Spread the Joy "QA Concepts: What is OTA? How to use OTA API? What all are possible with OTA API?" → VB?.
  2. Testing Concepts. Learn, Experience and Spread the Joy "How to Connect to Quality Centre using OTA API" → VB?.
  3. Testing Concepts. Learn, Experience and Spread the Joy "How to Use Filter method to filter the results (Bug Factory)" → VB?.
  4. Testing Concepts. Learn, Experience and Spread the Joy "Find a specified requirement in a specified folder: OTA" → VB?.
  5. Testing Concepts. Learn, Experience and Spread the Joy "How to Create a Test using OTA" → VB?.

• Learn Excel Macro. Lets Excel in Excel "HP Quality Center – Connect to HP QC using Excel VBA".
• Blog Excel Report Generator using OTA from QC.
• Advanced QTP "Scripting QTP by Dani Vainstein".
  • HP Enterprise Business Community "Quality Center Support and News Forum", Thread "how to extract runs from test instance with OTA → C#, VBA.
• LinkedIn Group "HP Quality Center OTA Developer", Thread "Need to create execution status report in excel from QC by using VBA" → VBA.
• Blog Test Automation. This blog aims to detail solutions to everyday challenges involved in test automation using QTP, Quality Center (QC), Excel and Open Source Tools.
  • Test Automation. This blog aims to detail solutions to everyday challenges involved in test automation using QTP, Quality Center (QC), Excel and Open Source Tools "Treeview for Quality Center Test Plan Using OTA & OTA Code Examples" → VBA.
• SQA Forums.
  • SQA Forums "VBA OTA examples including a Test Plan Treeview" → Excel VBA.

• Microsoft
  • Microsoft MSDN Library "VBScript".
  • Microsoft Download Center "VBScript Quick Reference".
  • Microsoft TechNet "VBScript Primer. Microsoft® Windows® 2000 Scripting Guide" - “VBScript Overview”, “VBScript Reference”.
  • Microsoft TechNet, Script Center.
    • Microsoft TechNet, Script Center "Scripting: Your First Steps".
• Advanced QTP "VBScript Tutorial" - “Register For This Site. ERROR: The email address entered is not within an allowed domain” . Just apply for a freebie ( e.g. Advanced QTP "Scripting QTP by Dani Vainstein" ), and you will have the chance to create an account even with a else rejected E-Mail address.

• Automation-Simplified. Work Smart not Hard, Automate it all "A quick intro to Quality Center Open Test Architecture API.....".
  • Google Docs Presentation "QC OTA presentation".
• Blog Joe Colantonio, Automation Awsomeness - Search for "ota".
• Codetweet "How To Create A Folder In Test Plan In ALM/QC Using OTA API" → VBScript.
• Aaron Evans.
  • fijiaaron.
    • fijiaaron "Documentation for TDConnection (OTAClient API)" - On Vista / Win7 / Win8: “Right click on the file and select Properties. Then click 'Unblock'”.
• EyeOnTesting - Tagged with "qualitycenter", EyeOnTesting - Tagged with "qc".
  • EyeOnTesting - The Software Testing Community "Quality Center 10 test instance defect linkage" - VBScript?.
• feelsgood11 "How to use Quality Center Open Test Architecture API" → VBScript.
• Blog Functional Testing. HP Mercury Tools Specific weblog.
  • Functional Testing. HP Mercury Tools Specific weblog "OTA, an API for extending Quality Center" → VBScript.
• Go gaga over testing "QC OTA - Test Lab".
• HP.
  • HP Enterprise Business Community "Quality Center Support and News Forum", Thread "OTA API Reference".
    • “The OTA API reference file for HP QC 10.0 is not very helpful compared to the HP QC 9.2 OTA reference help file” - Reference to the blog article Techno Logica - Stuff on Test Automation, Automation Tools, Scripting,QTP, QC, PHP... "Quality Center Open Test Architecture API -OTA COM 9.0", 2008.
  • HP Enterprise Business Community "Quality Center Support and News Forum", Thread "ALM 11 - TDConnection Object failing to login (OTA)" - Proper VBScript connect code for HPQC11 and HPQ12.
  • HP Enterprise Business Community "Quality Center Support and News Forum", Thread "ALM 12 - connection error, missing dlls?" - Proper instructions for HPQC12 how to call VBScript scripts by COMMAND.COM.
• HP Quality Center ( HPQC ) - HP Quality Center Script Language.
  • SmartBear "Editing HP Quality Center Scripts".
    • “You want more info on VB script and QTP, you can check out my Blog Software Engineering - Performance Automation.
    • “There are lots of different code snippets available in the Administrator's Guide and/or the API Reference Manual”.
  • QF-TEST "19.1 HP ALM - Quality Center".
• HP Test Center ( HPTC) - The skript Language is VB Script.
• Learn QTP for those with a zest to test - QTP (UFT) Forums "How to Execute a testset from QC using OTA framework" → VBScript.
• Frank Lindholm "Importing automated test results to HP QC/ALM" → VBScript.
• Wilson Mar "HP ALM Quality Center : Its Annoyances, and what to do about them" / "HP ALM Quality Center : How To Make It Work" - “VB OTA Coding”.
• Motu 4 QC - Tips & Tricks.
  • Motu 4 QC - Tips & Tricks "WorkFlow Script Editor" - “You can access to the code of the Script Editor through the 'Customize...' choice of the menu inside the Project, select the Workflow link. On the Right Part select Script Editor link”.
  • Motu 4 QC - Tips & Tricks "Automatic TestSet Execution via Script" → VBScript.
• The “QCUtil” object is available in the software application “QuickTest Pro” only, so not with HPQC.
• RelevantCodes. A test automation blog by Anshoo Arora "Executing QC TestSet via OTA API (QCRunTestSet)" → VBScript.
• StackOverflow.
  • StackOverflow - Tagged Questions "OTA".
  • StackOverflow "Get list of ALM project AND domains names in VBScript (QC11 OTA)" → “VBScript”.
• Technology For All. For me this is my Past,Present and Future digital Library "Download QC OTA API Reference Handbook /Documentation", 2010 - How to save the document from the HPQC online help, no download offer.
• Vivit TQA, Germany "User Group Treffen 'Testen & Test-Management mit HP'", 2013-04-18.
  • Vivit TQA, Germany "API-­‐Programmierung und –Nutzung bei HP Quality Center / ALM" ( PDF ).

• HP WinRunner ( formerly: Mercury WinRunner ).
  • EN.Wikipedia "WinRunner", DE.Wikipedia "WinRunner".
• EN.Wikipedia "HP Application Lifecycle Management".
• Components of the HP ALM suite: “HP Functional Testing”,...

• HP LoadRunner ( formerly: Mercury LoadRunner ).
• Hewlett-Packard "HP LoadRunner. Software-Testtool mit unübertroffener Leistungsfähigkeit und Flexibilität zum Testen der Anwendungsleistung".
• Hewlett-Packard "HP LoadRunner. Unmatched power and flexibility software testing tool for application performance".
• Blog Hewlett-Packard "HP LoadRunner and Performance Center Blog".
  • Hewlett-Packard "HP LoadRunner and Performance Center Blog", Article "Download HP LoadRunner and enhance your experience with the tips below".

• Hewlett-Packard "Loadrunner Trials" - A free time-unlimited edition of “LoadRunner Community Edition”, a 32-bit / 64-bit Windows application, is available for download. Features:
  • “Free for unlimited time - Available with 50 virtual users (VUsers)”.
  • “All protocols included except DCOM and GUI”.
• On my Athlon XP2400 computer, the software may be installed improperly ( while some process crashes happen during installation with “APPCRASH” messages ), but aborts when excuted ( with “APPCRASH” messages ) .
• Microsoft Download Center "Web Services Enhancements (WSE) 3.0 for Microsoft .NET".

• SlideShare "Introduction to Performance testing".

• Guru99 "Free HP Loadrunner Tutorials".
• Hewlett-Packard.
  • Hewlett-Packard "HP Videos" - "HP LoadRunner: How to download and Install".
  • YouTube "HP LoadRunner -- Download and Installation Guide -- Load Testing".
  • YouTube "Load testing, HP LoadRunner: How it works & terminology".
  • YouTube "Performance testing & HP LoadRunner - How it works and terminology".
• YouTube - Search for "loadrunner".
• YouTube Channel "Vijay S".
  • YouTube "HP LoadRunner Tutorial #1 - Introduction to HP LoadRunner".

• EN.Wikipedia "LoadRunner".

• HP QuickTest Pro ( formerly: Astra Quick test by Mercury Interactive ).
• Hewlett Packard "Unified Functional Testing (UFT)".

• Software Testing Help "QTP Tutorials – 25+ HP Quick Test Professional (QTP) Training Tutorials".
• Guru99 "Free QTP (Quick Test Professional) Tutorials" - Free training videos #.

• Experts told me, that “Unified Functional Testing” (UFT) may be used for automation of “HP Quality Center” actions executed by the graphical user interface.
• EN.Wikipedia "HP QuickTest Professional".
• Learn QTP... for those with a zest to test.
• Blog QTP Tutorials & Interview Questions.

• EN.Wikipedia "Stress testing (software)", DE.Wikipedia "Lasttest (Computer)".