Posts

Showing posts with the label QC

Export ALM Requirements / Requirement traceability to Excel Sheet

Image
Different ways to do that: SQL which fetches the “requirement traceability” i.e. test cases associated to the requirement from ALM: SELECT  REQ_COVER.RC_REQ_ID,  TEST.TS_NAME, TEST.TS_USER_03, TEST.TS_EXEC_STATUS, TESTCYCL.TC_USER_04, TESTCYCL.TC_USER_06, TEST.TS_SUBJECT FROM   REQ_COVER, TEST, TESTCYCL Where    TEST.TS_TEST_ID =  REQ_COVER.RC_ENTITY_ID And TESTCYCL.TC_TEST_ID = TEST.TS_TEST_ID AND TS_SUBJECT in (5140, 5141)   Note: TS_SUBJECT are the folder ID’s within which test cases are stored in test plan module =================================================================== Click on Dashboard > Analysis View > Then Click on Analysis and select New Excel report > Create a query in Quick Builder > Save the Query > Click on Generate button ==================================================================== Happy Testing!!

Move / Copy folders between projects and domains in QC / ALM

Image
Have you ever tried copying folders between projects and different domains in Quality Center or ALM ? If you have you would know that it's as simple as the steps below: Select the resource or folder that you want to copy in the test resource tree. To copy more than one item, use the CTRL key. Choose Edit > Copy. Alternatively, right-click and choose Copy. Open another instance of Quality Center and log in to the project to which you want to paste the resource or folders. Select the folder to which you want to copy the resources or folders. Choose Edit > Paste. Alternatively, right-click and choose Paste. The Paste Resources to Target Project dialog box opens.  Select one of the following options: Copy resources and link to existing related entities . QC copies the test resources or folders and pastes them into the target project. The copied test resources or folders are linked to existing test resources and called tests with the same name. If a related test re...

SAP TAO and QTP

Image
What is SAP TAO? SAP TAO is an automation testing tool released by SAP in integration with focus-frame. TAO (Test Optimization and Acceleration) is designed for SAP GUI based applications integrated with SOLMAN (Solution Manager) and HPQC SOLMAN Provides the necessary tools around the Implementation, Operational and Optimization aspects of your SAP Application life cycle. The two add-ins that are mandatory for TAO to be functional are "SAP" and "Web". Where does QTP fit in?   Pros SAP TAO wraps up QTP and QC and QTP acts as execution engine, test scenarios are created and driven from QC through business components.  SAP TAO helps in automatic generation of test components for end to end scenarios.   Cons  QTP and SAP TAO are really good when it comes to automation the  only challenge is  installation. installation process consisting of four areas Quality Center – This will host Quality Center software, patches, add-ins and S...

HP ALM Client logger / Log Manager

Image
I am not sure how many of you know about this feature. This one without doubt helps when we have no clue what is wrong with QTP/QC HP ALM Client logger /log manager You can either get it from here https://hpln.hp.com/content/hp-alm-client-log-manager-alm-1100-and-later Switch it on from here: Navigate to C:\Program Files (x86)\HP\QuickTest Professional\bin\ClientLogs.exe or C:\Program Files (x86)\HP\Unified Functional Testing\bin\ClientLogs.exe Once you have run the logger , find the logs at C:\Users\ \AppData\Local\Temp\

ALM and BPTWrapperTest

Image
Problem : Unable to run a few tests in ALM 11 that were executing before the upgrade Solution : The reason is named “BPTWrapperTest” that takes a BPT test - downloads all its components - and generates a single QTP “BPT Wrapper” test to run. Why? : BPT performance issues that were seen in QC10. Issues:  Mostly data related tests break when running BPT in ALM11. Workaround: Disable this feature from the System Registry and modify the registry key value of UseBPTWrapperTest to ‘N’. Here is the path of the registry key in Windows 7/ iSpace: Win 7/ iSpace == HKEY_LOCAL_MACHINE >> SOFTWARE >> Wow6432Node >> Mercury Interactive >> Test Director >> BPT >> UseBPTWrapperTest Dont like the workaround?: Change Environment(“TestName”) to Environment(“ActionName”) DataTable.Value(“test”) to DataTable.Value(“test”, Enviroment(“ActionName”)) Tip: The only reason you are not able to not find th...

Export Test Steps from QC to excel

Image
Go to Dashboard in QC and under Analysis Tab , select the option New Excel Report. Enter the below query in the Query Area:           Select TS_TEST_ID,TS_NAME,TS_DESCRIPTION,DS_STEP_ORDER,DS_STEP_NAME,           DS_DESCRIPTION,DS_EXPECTED           FROM TEST,DESSTEPS           where TEST.TS_TEST_ID = DESSTEPS.DS_TEST_ID           and TEST.TS_TEST_ID in (xxxx,xxxx)           ORDER BY TS_TEST_ID, DS_STEP_ORDER     3.   Click on the Generate button Note: xxxx,xxxx should be replaced by test case ids. You can know your test case ids from the test plan module.

BPT - Check if a component has failed

Image
As we all know in BPT a test case comprises of many components put together. Now the best practice would be when a component fails we stop the entire BPT test rather than continue testing, so here is a simple code that will do just that: Function ComponentFailHandler      If Reporter.RunStatus = micFail Then ExitTest End Function   Can it get easier than this? :P

DB query - total number of BPT components used in each test case

Image
Slect ts_name, count(*) from ( SELECT B.TS_TEST_ID, A.BC_BPT_ID, C.CO_ID, A.BC_CO_ID, B.TS_NAME, C.CO_NAME FROM Table1 A INNER JOIN Table2 B ON A.BC_BPT_ID = B.TS_TEST_ID INNER JOIN Table C ON A.BC_co_ID = C.CO_ID ) BPT group by ts_name Happy Testing!

BPT Component Parameters Names and their values using OTA

Image
Set qtApp = CreateObject("QuickTest.Application") Set objBPTComp=qtApp.BusinessComponent Set parametersDF=objBPTComp.ParameterDefinitions For i=1 to parametersDF.count                 If parametersDF.item(i).inOut=0 Then ‘To identify input parameter                            msgbox parametersDF.Item(i).Name & " = " & parameter(parametersDF.Item(i).Name)                 End If Next Happy Testing!

Merge Object Repository the Business Process Testing(BPT) way!

Image
To update a shared object repository from a local object repository of a BPT Component: Select Resources > Object Repository Manager. The Object Repository Manager opens. In the Object Repository Manager, select File > Open or click the Open button . The Open Shared Object Repository dialog box opens. In the sidebar, select the location of the object repository file, for example, File System or Quality Center Resources. Browse to and select the .tsr file that contains the shared object repository you want to update, clear the Open in read-only mode check box, and click Open. The file opens with the objects and properties displayed in editable format. Select Tools > Update from Local Repository. The Update from Local Repository dialog box opens. Make sure you are connected to your Quality Center project. Click the down arrow next to the Add Tests button , and select Browse for Component. The Open QuickTest Component from Quality Center Project dialog box opens...

QC cannot run manual BPT components

Image
Have you ever tried to run manual components in any version that supports BPT framework. You would be surprised that you get a wrong error message stating: "Cannot run component xyz in busines process test xyz. This version of Quality Center does not support running components of the type MANUAL." Really? No that's a wrong error message. What happens is QC is  it would always try to run the components automated first, even if the components in the test  are "manual" components. Solution : When you go to run the test, make sure you click on the little black down arrow next to the Run button. From there select, "Run Manually"

All in One - HP changes the way we automate and test

Image
Hewlett-Packard is incorporating three different components, previously available separately, into its HP Unified Functional Testing (UFT) automated testing application so developers can test all aspects of a multi-tiered application from a single interface. The company will also offer a cloud service that will allow developers to test mobile applications. UFT 11.5, due to be released early next month, has been updated to better accommodate this more rapid pace of development UFT 11.5 simplifies the testing process by combining a number of different tests into one screen Now, developers can test, from a single console, all three layers: the interface, the service layer and the database layer. The consolidation of features also better supports continuous integration, a practice of frequently testing the software being developed, through the use of tools such as Jenkins, to which UFT can be connected. UFT 11.5 also includes a new patented recognition technology that can scan a...

QTP Test Automation Framework Architecture

Image
Here is a mindmap that I had created some time back on a hybrid test automation framework, this gives a nice idea of the functionalities a framework might want to incorporate.

Launch Report Button Missing in QC Test Lab

Image
There are a lot of instances when we want to launch the summary report from the Test Instance Properties window in test lab, but the Launch report button is not present. This happens after new patches get installed. Resolution : Install the correct version of   Reinstall Visual C++ 2005 (version 8.0.56336) or SP1 Reinstall .NetFramework 3.5 SP1 Reinstall all Add-Ins currently installed on the Client machine With windows 7 and QC\QTP 11. 1) uninstall qtp addin 2) Install the vsc++ http://www.microsoft.com/download/en/details.aspx?id=14431 download and run vcredit_x64.exe 3) install qtp addin

Query to extract all test steps of a test set in QC dashboard

Image
SELECT CYCLE.CY_CYCLE AS TEST_SET, TEST.TS_NAME AS TEST_NAME, TEST.TS_TYPE AS TEST_TYPE, DESSTEPS.DS_STEP_NAME AS STEP_NAME, DESSTEPS.DS_DESCRIPTION AS STEP_DESCRIPTION, DESSTEPS.DS_EXPECTED AS STEP_EXPECTED_RESULT FROM TESTCYCL, TEST, CYCLE, DESSTEPS WHERE TEST.TS_TEST_ID = TESTCYCL.TC_TEST_ID AND TESTCYCL.TC_CYCLE_ID = CYCLE.CY_CYCLE_ID AND TEST.TS_TEST_ID = DESSTEPS.DS_TEST_ID AND CYCLE.CY_CYCLE = 'Test Set name' ORDER BY CYCLE.CY_CYCLE,TEST.TS_NAME,DESSTEPS.DS_STEP_NAME

Frequently Asked Questions QTP Book - Technology Specific Guide for QTP

Image
Frequently Asked Questions: Can I buy this TSG-QTP( Technology Specific Guide for QTP) in India? Yes. The book is available only in India, we are working at options for other countries. Please order the books online by clicking here Where can i Buy this book(TSG-QTP)? There are different buying options for this book. Click here to see possible buying options Is the book available in any book store? No, Currently the book is only available online I am ordering book in bulk quantity, can i get discount on the same? If you are ordering more than 5 copies, you can contact  us for discounts. How can i provide feedback for this book? You can always provide your feedback by contacting us

Here is what the experts had to say - TSG-QTP ( QTP book )

Image
After a long struggle to get the copyright from HP , the ISBN number from Delhi, prominent QTP experts to review and finally a publisher , I am happy to let you know that my book is out and quite a few copies are sold. Below is a snapshot of the mail I send to prospective testers, would be great if you could forward the same to people you know. Thanks in advance. Okay, so all of you who said you'd wait for the paperback of my new book “Technology Specific guide for QTP”, now comes the time. Please visit the website to read the reviews and newsletter. This book will get you started on the path of automation, introducing solutions, roadblocks, patches and ideas that will help give you a solid foundation in the field of automation. Each problem has a series of solutions available that will let you test your knowledge and apply it to the business situations you’re facing at your company. Everyone from a novice user to an automation expert will have something they would have never...

Technology Specific Guide for QTP - ( QTP book )

Image
We have received a lot of queries regarding the book, the book has been off the shelves and out of stock on flipkart and other websites. The best way to get the book Technology Specific Guide for QTP – QTP for Web Testing - now is directly through us: Mail us at : aditya_kalra@ymail.com timothyrajan@gmail.com   Have you ever wondered? How do I evaluate my skill-set in automation? What do I do to become an expert in a test automation tool like QTP? What do I do every time I hit a roadblock while automating a new solution? What are the latest out of the box features HP has to offer? Then grab a copy of “Technology Specific Guide for QTP – QTP for Web Testing” today.! http://bluemagic-automation.blogspot.in/ What’s In It for You? Everyone from a novice user to an automation expert will have something they would have never heard of or used. Our motivation for writing the book was noticing that a lot of people have found themse...

Utility to create tests in test plan of Quality Center

Image
Problem: Create tests in the test plan by copying a base test in QC to a destination folder in QC with the test names from the file system's existing folders/files. Solution: Created a macro using OTA to do the same: Code: Private Sub CommandButton1_Click()         If LoadQCConnectForm Then     End If         Dim FSO As Object     Dim Folder As Object     Dim FolderName As String     Dim SubFolder As Object     Dim strTestCase As String     Dim TestCaseName As String         'Parent Directory - Change this to whichever directory you want to use     FolderName = GetVariable("Fitnesse Path")          Set FSO = CreateObject("Scripting.FileSystemObject")     Set Folder = FSO.GetFolder(FolderName)       ...