OTA, an API for extending Quality Center
Last week, I provided consultancy regarding QuickTest Professional and the WebServices add-in (more about this add-in next week!). At some point, the customer came to me and asked for advice regarding access to the Quality Center (QC) database. What was interesting about this query is that I discovered that the customer was not aware about the Open Test Architecture (OTA).
So, today, I want to give you insight about what is the OTA and give you a short example showing what you can achieve with it.
First of all, the OTA is:
- An integration API that allows the integration of any third-party tool within Quality Center;
- A manipulation API that permits the interaction with the Quality Center application without having to use the GUI frontend.
We will not talk about the integration API so if you are interested in learning more, log on your QC server then select Help > Documentation and read the OTA Guide.
Architecture
The QC Client/Server architecture is a 3-tier architecture (web server, application server and database server). The figure below shows the interaction between the components. They consist of:
- Client application: the QC GUI front-end that you use when accessing Quality Center through your browser. Or any other application that communicates with QC using the API;
- Web server: the QC communication between the client and the server are performed using the HTTP protocol;
- Application server: by default, the JBOSS application server is installed with Quality Center. the QC application is built using Java and requires a J2EE application server. The J2EE platform is particularly well designed for client/server applications over the Internet
- Quality Center application: developed to be executed on a J2EE application server;
- Database Server: the database that holds the Quality Center information.
Quality Center API
The manipulation API is called Quality Center API and allows the interaction with Quality Center. It also allows you to interact with the database through the API making the interactions more secure. Also, it avoids your DBA (DataBase Administrator) having to provide an access to the database server(s) hosting the Quality Center database(s).
The API has only 1 entry point which is the TDConnection object. From this object, you can access a lot of Quality Center functionalities. The API functions are accessible through VBScript and any COM aware programming languages. It means that you can use this API as a standalone .VBS application, a macro in an Excel file, a script in QuickTest Professional or any other application where you would like to integrate such functionalities.
As an example, we are going to download all the defects that are stored on a Quality Center project using the Excel application.
The steps involve:
- Connect to the project
- Run a query to retrieve a list of defects
- Store the result in an Excel worksheet
1. Connect to the project
Each project stored in a Quality Center server is identified by its pair Domain/Project and a project is accessible only if the user belongs to this project. The connection to a server can be done by using only 4 lines of code:
Dim QCConnection
‘ Return the TDConnection object.
Set QCConnection = CreateObject(“TDApiOle80.TDConnection”)
QCConnection.InitConnectionEx “http://
QCConnection.login “<username>”, “<password>”
‘ DEFAULT = Domain, QualityCenter_Demo = Project
QCConnection.Connect “DEFAULT”, “QualityCenter_Demo”
2. Execute a query
To execute a query in Quality Center, you have several options available.
The first one is to use the Command object. This object can run SQL queries for any Quality Center table. However, you need to be aware of what table to query and make sure you know what you do because you can mess up Quality Center. Also, this Command object can be used only if you are part of the TDAdmin group in this project.
The second one is to use a Factory object. The factory object returns objects that are part of the API, restricting the user from making mistakes. This is the method we’ll be using in this article. To access the defects, we are using the BugFactory:
Dim BugFactory, BugList
Set BugFactory = QCConnection.BugFactory
Set BugList = BugFactory.NewList(“”) ‘ Get a list of all the defects.
3. Store the result in an Excel worksheet.
We assume that you are running this script from a VBS file. Consequently, we have to open Excel first, then store the data in an Excel worksheet:
Dim Bug, Excel, Sheet
Set Excel = CreateObject(“Excel.Application”) ‘ Open Excel
Excel.WorkBooks.Add() ‘ Add a new workbook
‘ Get the first worksheet.
Set Sheet = Excel.ActiveSheet
Dim Bug, Row
Row = 1
‘ Iterate through all the defects.
For Each Bug In BugList
‘ Save a specified set of fields.
Sheet.Cells(Row, 1).Value = Bug.Field(“BG_BUG_ID”)
Sheet.Cells(Row, 2).Value = Bug.Summary
Sheet.Cells(Row, 3).Value = Bug.DetectedBy
Sheet.Cells(Row, 4).Value = Bug.Priority
Sheet.Cells(Row, 5).Value = Bug.Status
Sheet.Cells(Row, 6).Value = Bug.AssignedTo
Row = Row + 1
Next
‘ Save the newly created workbook and close Excel.
Excel.ActiveWorkbook.SaveAs(“c:\QualityCenter_Demo_DEFECTS.xls”)
Excel.Quit
Summary
Today, you have seen how to use the QC API to perform a simple task such as retrieving a list of defects. Bear in mind that you can do much more than that.
Find here a more complete example of the script described in this article.
October 6th, 2007 at 3:44 am
Thank you for sharing!
October 20th, 2007 at 9:09 am
I couldn’t understand some parts of this article OTA, an API for extending Quality Center, but I guess I just need to check some more resources regarding this, because it sounds interesting.
November 8th, 2007 at 6:12 pm
It would be REALLY great if you could also provide an example that would retrieve a list of defects from QC and populate them into an MS-Access table!
How about it?
November 21st, 2007 at 2:12 pm
Briljant! How to do this with Test Sets, Test Plans & Requirements
December 2nd, 2007 at 7:04 am
How to do this with Test Sets, Test Plans & Requirements .I mean if i want to download the testcases from TestPlan provided the path to Test Cases in TestPlan.
December 17th, 2007 at 7:05 pm
Brilliant article. Found several others that only confussed me, this one really got me going.
December 22nd, 2007 at 12:50 am
Thank for sharing, very good artical. Can you please share Test Sets, Test Plans & Requirements or provide a path to the ex: – Thank you.
January 11th, 2008 at 1:35 pm
Thanks a lot for sharing this info.
Can you please share similar short example for Test Plan and Releases fo rversion 9.2.
February 11th, 2008 at 9:06 am
very useful artical
February 13th, 2008 at 7:30 am
Hi
I am trying to intgrate QC Api with a java application. i am trying to pul data from the API & pass the data to the Java Api direcly without the involment of Database, & the data is used to build statistics reports,
can some one help the way to go about,
Thanks in advance !
March 5th, 2008 at 11:47 pm
I tried the following code, but it gave me a QCConnection.login not supported error message.
Dim QCConnection
‘ Return the TDConnection object.
Set QCConnection = CreateObject(“TDApiOle80.TDConnection”)
QCConnection.InitConnectionEx “http:///qcbin”
QCConnection.login “”, “”
‘ DEFAULT = Domain, QualityCenter_Demo = Project
QCConnection.Connect “DEFAULT”, “QualityCenter_Demo”
March 6th, 2008 at 7:36 pm
I am planning to do a presentation on OTA at local HP/Mercury user group next week. If you don’t mind, I would like to use parts of your blog for my presentation. I also have 2 presentations on BPT and OR/DP posted on my website (www.connectedtesting.com) – feel free to use them.
Thanks again,
Igor
March 8th, 2008 at 6:25 pm
Hi Jim,
> I tried the following code, but it gave me a QCConnection.login not supported error message.”, “
”
> QCConnection.login “
You get an error message when trying to use the Login function of the TDConnection object. This happens because the Login function is only available in Quality Center 9.0 and above. The version of Quality Center you are using is earlier than that and uses a different approach for authentificating.
You can refer to your OTA Reference documentation that you can find in the Help section of Quality Center.
Thanks,
Valery
April 2nd, 2008 at 4:24 pm
Hi Admin,
Great article!
The script runs fine for me until it comes to printing the query to excel.
(any of the ‘Sheet.Cells(Row, x).Value = Bug.xxx’ commands crash it)
What is the easiest way to test if buglist has been populated properly?
Thanks,
Perry
April 2nd, 2008 at 8:12 pm
Figured it out,
The “complete example” worked fine for me.
April 15th, 2008 at 5:29 am
Is there a similar example that uses either php or Java?
April 21st, 2008 at 12:29 pm
Hi, I have tried to connect Quality Center thru VB using the code mentioned above but it displayes an error “Server has been disconnected while performing Login action”
Please help me regarding this issue.
April 26th, 2008 at 11:18 am
Hi,
I am trying to download all the defecs from quality center to MS Access database, but when the text contains single quotes, it is not storing to database
Please anyone help. If anyone having code to do this in VB6 please send it to me at PankajR_D@infosys.com
April 27th, 2008 at 1:49 pm
Salim: I also need to integrate QC API with a Java Application. If you had any luck with this or got any replies – please share them on the forum. THanks
Debbie
Salim Aftab Says:
February 13th, 2008 at 7:30 am
Hi
I am trying to intgrate QC Api with a java application. i am trying to pul data from the API & pass the data to the Java Api direcly without the involment of Database, & the data is used to build statistics reports,
can some one help the way to go about,
Thanks in advance !
April 28th, 2008 at 5:07 pm
Hi
Thanks for sharing.
I was looking for a VB script where I could pass the test cases already uploaded in Quality center using Excel.
My requirement is:
The script should be able to pass the case irrespective of the number of steps.
The script need not connect to Quality center nor Loginto.
The script should be able to copy the Expected result in the Actual result and also change its tense.
Eg: Expected – The webedit should have a valid value
Actual – The script should write the above sentence as
The webedit had a valid value
May 9th, 2008 at 11:17 pm
Any word on whether or not a Java API exists?
I find it hard to believe that an application written in Java does not have a Java API.
May 13th, 2008 at 10:26 pm
Where can I find a user manual or guide for the Quality Center OTA API? Please email to daveeedaveee@yahoo.com if anyone has a copy.
May 15th, 2008 at 1:12 pm
Hi,
I am looking at integrating SOAP UI pro ( tool for testing webservices) with Quality Center. Our test cases are in SOAP UI pro and we are using QC for test management. We would like the test cases from SOAP UI pro mapped with test cases in QC and the results from SOAP UI should get updated in QC
Please advice of the proceedings.
Thanks
S.Geethanjali.,PMP
May 28th, 2008 at 7:53 am
Its very usful for me. Can we fetch the email id from the Test Director
July 2nd, 2008 at 3:15 pm
Someone wanted some code to populate a table in MSAccess – Have Fun
Function QCIntTest()
Dim Connection As TDConnection
Dim qcBugFact As BugFactory
Dim qcBugFilter As TDFilter
Dim qcBugList As List
Dim iProjectCount
Dim XServerName As String
Dim rs As Recordset
Dim db As Database
Set db = CurrentDb()
DoCmd.SetWarnings False
DoCmd.RunSQL “Delete From QualityCenterDefects;”
XServerName = “http://qualitycenter.companyname.net/qcbin”
XUserID = “xuserid”
XPassword = “xpassword”
XDomain = “xdomain”
XProject = “xproject”
‘ Connect to QC
Set Connection = New TDAPIOLELib.TDConnection
Connection.InitConnectionEx XServerName
Connection.Login XUserID, XPassword
Connection.Connect XDomain, XProject
Set qcBugFact = Connection.BugFactory
Set qcBugFilter = qcBugFact.Filter
Set qcBugList = qcBugFilter.NewList
‘ tsUserLogin.txtReportStatus.Caption = “Logged in.”
‘ tsUserLogin.Repaint
Set rsadd = db.OpenRecordset(“QualityCenterDefects”)
XCount = 0
For Each XBug In qcBugList
XID = XBug.ID
XStatus = XBug.Status
XAssignedTo = XBug.AssignedTo
XDetectedBy = XBug.DetectedBy
XPriority = XBug.Priority
XSeverity = XBug.Field(“BG_SEVERITY”)
XSummary = XBug.Summary
XCount = XCount + 1
rsadd.AddNew
rsadd.Fields(“Domain”) = XDomain
rsadd.Fields(“ProjectName”) = XProject
rsadd.Fields(“DefectID”) = XID
rsadd.Fields(“DefectStatus”) = XStatus
rsadd.Fields(“DefectAssignedTo”) = XAssignedTo
rsadd.Fields(“DefectDetectedBy”) = XDetectedBy
rsadd.Fields(“DefectPriority”) = XPriority
rsadd.Fields(“DefectSeverity”) = XSeverity
rsadd.Fields(“DefectSummary”) = XSummary
rsadd.Update
Next
MsgBox “# Bugs:” & XCount
rsadd.Close
Connection.DisconnectProject
Connection.ReleaseConnection
July 4th, 2008 at 4:47 am
Hi,
I want to open an application using VAPI-XP test script. I have stored the exe file somewhere on my desktop. After opening the application I want to go to Reports tab and generate a particular report.
Can anyone please provide me with the code. I am new to scripting.
August 5th, 2008 at 4:22 am
Hi guys,
I’d like to do the same, but instead of outputting to an excel file, I’d like to run the script inside a webpage and have it pull down a particular favourites list. Is this possible? I’m pretty terrible with my coding and would like the data arranged into a table. Cheers.
August 21st, 2008 at 1:18 pm
Hi All,
This was a good article
I need how to integrate CVS to QC
As CVS is the third party configuration management Tool i need to integrate with QC .
So Open Test Architecture with API is useful
So here comes the process
So if any one could explain me the process then that could be great
August 26th, 2008 at 5:14 am
Hi,
Can someone please provide me code for importing and exporting test cases from Test lab to excel.
The example mentioned in this article states only about defects. Is there any way to do the same for Test Plan, Requirements and Test Lab(specially).
Still I found an Addin available with QC for Test Plan and Requirements. But there is no solution available for Test Lab. How we can import executed test cases in Excel to QC Test lab with results and vice versa.
Please provide input on this if any.
Thanks,
Preeti
August 29th, 2008 at 3:23 pm
Hi,
Can we share the test plans/Test cases from 1 project to other project?
For Eg: i have two projects say QA1 and QA2. i want to utilize the test cases in QA1 project.
is it possible? could you please share the info if it possible?
Regards,
kishore.
September 1st, 2008 at 1:57 pm
Hi Kishore,
It is not possible to share Test Cases, Defects, Test Sets, etc. between projects. A QC Project is like a container which holds a set of data which is not visible outside the project itself.
However, you can copy data from one project to another. The limitation to this is that if you make a change in a project, it is not reflected in the other project.
Hope this helps.
Regards,
Valery
September 2nd, 2008 at 4:29 pm
Hello,
How can I get the requirement in Excel sheet with the path (i.e folders and subfolders)?
Thanks
Puneet
September 4th, 2008 at 6:55 pm
Thankyou for this wonderful website!!
Can you please let me know how I can pull out the root cause of each defect (Code,Environment etc) and the test stage (intergartion, UAT etc )for a project using the API menthod. A sample code would be really helpul.
September 9th, 2008 at 8:28 am
Hi,
Very Good article. In addition, could you also share on how to use the command object to run SQL queries directly ? I am part of the TDAdmin group of th QC project used in my team.
Thanks,
Nandita
September 16th, 2008 at 10:17 am
I am using Test data which is there in Excel sheet, and i am working on QTP, my scripts needs this data during run time. Every thing is working fine when i execute scripts directly from QTP. Now the problem comes.. I am integrating QTP with Quality Center and i want my scripts to fetch the data in the same way without modifying my code. Is there a way to open excel from QC and read data from it.
please provide this info as early as possible..
September 23rd, 2008 at 8:56 pm
Hi,
Does any one have a excel file with marcos where we can store the screeprints with step numbers and even with the description and any one can give the vb code.
October 31st, 2008 at 7:09 am
Hi
This is a good article. Could some one help me in how to upload test results available in excel sheet to Quality center.
November 20th, 2008 at 10:21 pm
Hi,
I am trying to build a tool to capture the metrics from QC. I need to script which will select multi folder in the test lab and list testsets in both these folders.
Regards,
Raju
November 25th, 2008 at 12:53 pm
I want to learn QTP and script, where can I find step by step document to learn QTP tool and QTP script.
November 26th, 2008 at 8:51 am
hi all,
Thanks for the wonderful code to extract all defects from QC.
can any one tell me how can we extract a defect with particular filter.
Consider that, if i need to extract the defects based on different projects or the detected date.
I want to know how to set filter in the above code for extracting defect.
Thanks in advance.
December 5th, 2008 at 6:44 pm
hi,
This article helped me a lot to proceed in a different way for my framework. since i am using AOM framework i would like to make the test case pass or fail using my framework.
can anybody give me a code to access test set and test tree and how to make pass/fail the test set?
thanks
December 9th, 2008 at 7:42 am
How to access all functionalities(or methods) available for ‘TDConnection’ object. Also how to find name of an OTA object and all of it’s methods and properties.
January 13th, 2009 at 7:14 am
I am in desperate need of a Java API for this functionality as well!
It seems a little bit silly to talk Java to com4java which talks to COM which talks to Java…
January 20th, 2009 at 10:34 pm
Hi Tommy,
The only API provided by HP is a COM based API which, because of the technology used, can only work in Windows.
Thanks,
Valery
February 5th, 2009 at 10:36 am
Can we download any QC files using Excel Macro code?
February 26th, 2009 at 11:01 am
Hi,
Is it possible to upload the QTP test results from our local machine to QC. I want it to be the same way as it looks like when we run it from QC (xml format)
March 11th, 2009 at 10:20 am
Hi,
I need to integrate SoapUI in QC (like Reply Nr. 23).
How can I get the Results of an SoapUI-Run as attachment in QC and how can I set the Result in the Testset an the Test.
Also I need to know, how to become the Name of the selectet TestSet and Test.
Thanks for your answer
Ralf
March 16th, 2009 at 3:21 pm
Hi I tried to execute the above mentioned QC Code for QC automation, but I m gettin the error message like “Object doesn’t support this property or method” on ” QCConnection.login UserName, Password” while trying to setup QC connection
March 18th, 2009 at 2:54 pm
Hi,
I m trying to build a progress graph for the desired folder from the testlab. can any bidy proveide me with the Code.
March 26th, 2009 at 5:30 am
Hi,
Can someone please provide me code for importing and exporting test cases from Test lab to excel.
Still I found an Addin available with QC for Test Plan and Requirements. But there is no solution available for Test Lab. How we can import executed test cases in Excel to QC Test lab with results and vice versa.
Please provide detailed info regarding this
Thanks & Regards
Neetha
April 3rd, 2009 at 1:40 pm
To Puneet: If you still need to get the folder path of a requirement, testset, or test try this:
Dim rqmtL As IFactoryList
Dim RQ As ReqFactory
Set RQ = QC.ReqFactory
Set RF = RQ.Filter
RF.Filter(“rq_req_id”) = RQID ‘* Id of requirement want path for
Set rqmtL = RQ.NewList(RF.Text) ‘* Returns rqmts that match filter
Rqmt_Path = rqmtL.Item(1).Path
Buy the way does anybody know how to get the content of the RichText area in a Requirement?
April 27th, 2009 at 9:15 am
Hi,
Could you please let me know how to integrate QC with the opensource tool SoapUI. Is there any Plug-ins available for the same?
Thanks
Sriram
May 14th, 2009 at 3:13 am
In the test lab, where I have a Test Set, I usually select a few test cases and those are shown in the Execution Grid. However, for running I can select a few of them. How can I get the test case names/ids of these selected test cases , off the entire set of test cases in the test set ( using OTA)?
June 15th, 2009 at 6:55 pm
Here is some advice for people trying to communicate with the QC from Java:
- Use Jawin (javinBrowser.jar) to create Java class wrappers for the OTA API Dll (OTAClient.dll)
- To run your app, include a VM argument pointing to jawind.dll
-Dorg.jawin.hardlib=…./jawind.dll
- Start coding:
ITDConnection c = new ITDConnection(TDConnection.CLSID);
c.InitConnectionEx(“http:…”); // connect to the QC
c.Login(“user”,”pw”); // login
c.Connect(“”,”"); // connect to
email me if you are doing something similar and want to share the experience.
jdevEng_ERASE_THIS_@_ERASE_THIS_gmail.com
De Nada
June 18th, 2009 at 8:39 am
If some one has a solution for this , it would be great help .
I need to write a OTA script to do the following in QC .
> I have newly moved test cases to a test set
> all the test cases are now showing status as “No Run”
> I need to explode this test set now .
– What i mean by explode is ,i need to select one test case in test set
– click on the Run button above or ctrl+F9
– On the manual Runner window the details like RunName is pre-populated .
– After this i need to click on Stop Run or ctrl+Q – this creates a new Run which i can continue to run the next time
i have the below script , but this thing creates run with a new RunName
Dim runName$
runName = “Linked_Run”
‘Set testInstanceF = theTestSet.TSTestFactory
Set RunF = theTSTest.RunFactory
Set theRun = RunF.Item(1)
theRun.Status = “No Run”
theRun.Post
theTSTest.Status = “Not Completed”
theTSTest.Post
June 18th, 2009 at 8:43 am
# Divya P U Says:
May 14th, 2009 at 3:13 am
In the test lab, where I have a Test Set, I usually select a few test cases and those are shown in the Execution Grid. However, for running I can select a few of them. How can I get the test case names/ids of these selected test cases , off the entire set of test cases in the test set ( using OTA)?
Divya u need to write a big scripts for this , this very much possible and i have created a excel based macro for this which works fine , i have the below code
For Each TestCase In TestList
Dim DesignStepFactory, DesignStep, DesignStepList
Set DesignStepFactory = TestCase.DesignStepFactory
Set DesignStepList = DesignStepFactory.NewList(“”)
If DesignStepList.Count = 0 Then
‘Save a specified set of fields.
Sheet.Cells(Row, 1).Value = TestCase.Field(“TS_SUBJECT”).Path
Sheet.Cells(Row, 2).Value = TestCase.Field(“TS_NAME”)
Sheet.Cells(Row, 3).Value = TestCase.Field(“TS_DESCRIPTION”)
Sheet.Cells(Row, 4).Value = TestCase.Field(“TS_RESPONSIBLE”)
Sheet.Cells(Row, 5).Value = TestCase.Field(“TS_STATUS”)
July 2nd, 2009 at 12:24 pm
HI,
I am trying to write macro code in excel which will pass the testcases in QC if we provide the path of test case. Please guide or help me to write it.Or else if someone tried it please let me know.
July 22nd, 2009 at 6:03 am
this is really healpful stuff, but i need more help for all of you,
1. i have multiple test sets in my test lab, once the run is completed i just want to execute the failed cases automatically, how to filter the failed cases from each test set from the results?
if some one can send information on this, that will be really healpful for me..
July 22nd, 2009 at 3:09 pm
I need to login in QC by php script and if the connect is ok, the script must open the project home page bypassing official login page of Quality Center
for example a wrote this script but it isnt working
can anybody help me? thanks
InitConnectionEx($qcurl);
$tdc->Login($usr, $pwd);
header(“Location: http://mercury/qcbin/start_a.htm“);
?>
July 23rd, 2009 at 11:17 am
Can somebody tell me how to create a script which adds a user to all the existing projects(say more than 100) in Quality Center. Doing it manually is a tideous task.
Regards
Kunal
August 22nd, 2009 at 4:00 pm
Hello,
I’d like to make my own macro to insert tests from a Excel sheet.
I’m looking for how to add a test to the test factory.
Other thing, I’d like to flush the tests factory and tests set in order to export them into an Excel sheet.
Thanks for Advance.
August 28th, 2009 at 7:33 am
dinesh,
the Macro what u asked for is very much possible , just go though the OTA help document provided. It gives you all the steps to and example to yours task.
in brief what you will have to do is .
> Connect to QC
> Create object for Test Lab factory , Test Set Factory , Run Factory and Step Factory
> Make a list of test cases that needs to be passed.
> Iterate the test cases within the Steps Factory
a snippet of code is as below :
Dim StepIntVal As Integer
StepIntVal = Replace((theStep.Name), “Step”, “”)
If (StepIntVal > ws.Cells(row, 4).Value) Then
GoTo 153
Else
If (StepIntVal >= ws.Cells(row, 3).Value) Then
theStep.Status = ws.Cells(row, 5).Value
theStep.Post
End If ‘Step Start value
End If ‘ Step End value
Next ‘ Step end
—————————————————————————-
ali yajiv ,
The problem is alo possible; again here you have to create objects for each factory.
If theTSTest.Status(“Failed”) then
———
——–
End If
September 14th, 2009 at 7:34 pm
Hi, I have no idea how much this blog is monitored but it looks like there was a reply as recent as last month
:) I’m hoping you might be able to answer a question for me! Using the OTA API can you download *all* the BPT information including the automated script associated with the component? That’s really the bottom-line question I need answered first for my work. Second is if anyone has any code snippets\examples of retrieving any of the BPT information, but specifically I would like to see an example of how I would retrieve the associated automated script.
Any help would be much appreciated!
Wendy
September 25th, 2009 at 11:13 am
Hello,
Please check out the first plugin for integration soapUI with HP Quality Center. The plugin allows you to sync test cases with Quality Center and also update test cases in QC. Some of the features are for this plugin are:
* windows installer for easy installation
* ability to export soapui request/response to QC
* ability to update test case name, test steps status
* soapUI Action (button on project level) to sync with Quality Center.
* some other bug fixes and enhancements
I would really appreciate if your team can register on the website and download the latest trail version of the plugin for testing the functionality. Comprehensive user guide with screen shots can be found on the website.
As always, your comments and suggestions are highly valuable. Please use the forums to suggest new features or bugs.
Sincerely
Farooq
http://www.agiletestware.com
October 1st, 2009 at 12:59 pm
I need your help in importing test result from excel to QC? i have a excel sheet which have testid and corresponding test status (pass/fail), i want to upload this into QC test lab? i tried lot but not able to get any working solution. currently we got stuck. can anybody helps us how to do that using OTA API?
It will be your great help if you can provide some scripts/help so that we can able to import our test result from excel to QC test lab.
Appreciate your response…
Thanks,
Devraj.
October 16th, 2009 at 10:45 am
Hi, Can anyone tell me how can I make use of these in HTML… It would be great if anyone can give a complete code of HTML for the example given above..
Thanks in advance.
October 27th, 2009 at 1:40 pm
Hi,
I need to do the following task in QC using OTA API
>to upload test case which has two files .xml and .dat
can somebody tell me how i can do this
Thanks,
Manju
October 30th, 2009 at 9:41 am
Hi Devrajqc,
Can you email me with your problem and I can come up with a solution for you.
Thanks
Farooq
admin@agiletestware.com
November 18th, 2009 at 8:26 am
How can we pull deferred defects from QC using QC API
December 4th, 2009 at 7:44 am
Hi,
I need your help in importing test result from excel to QC. I have a excel sheet which have testid and corresponding test status (pass/fail), i want to upload this into QC test lab. i tried lot but not able to get any working solution. currently we got stuck. can anybody helps us how to do that using OTA API?
It will be your great help if you can provide some scripts/help so that we can able to import our test result from excel to QC test lab.
December 28th, 2009 at 9:45 am
Hi,
I have a few hundreds test cases which are scattered over a few hundred excel files that needs to be uploaded into Test Director.
Is there a way to automate this via VB .net instead of manually opne the few hundreds excel file and upload via the add-ins?
A sample code or reference on how this can be doen will be great.
Thanks.
rgds.
January 1st, 2010 at 12:03 pm
How to retrieve the Domain and Project upon providing the UserName and Password using macro?
January 8th, 2010 at 7:34 pm
I am trying to write a vbscript to export the COUNT , that tests in TESTPLAN are mapped to test cases. or Requirements mapped count. Please guide me to solve this. I don’t no how to access the mapped test cases and count.
January 19th, 2010 at 2:50 pm
GohWah, I have the same problem as you have. A few hundred test scripts in excel that need to be imported into Quality Center without having to use the wizard addin. I am reviewing the OTA but have not yet discovered how to import into Test Plan module. I can EXPORT fine. Please anyone help.
February 12th, 2010 at 12:33 pm
I would like to know how VAPI-XP is related to OTA? How does OTA helps VAPI-XP to work?
February 15th, 2010 at 9:17 am
Connect to Quality Center OTA Client using PHP
———————————————————
http://technologicaguru.blogspot.com/2009/06/connect-to-quality-center-ota-client.html
March 10th, 2010 at 6:26 pm
Hi All,
Question is that How to count Group Iterations for business component using OTA API?
I’ve written a script which gives me the Test case name, its status(passed/ Failed) of each test set from Test Folder, but i don’t found any Class method or property which gives me the Business Component’s group iterations.
Can any one answer?
March 27th, 2010 at 8:17 pm
Hi,
can you please provide me API to add an item to the list in QC,
Thanks in advance.
Rajesh
March 31st, 2010 at 7:59 am
The below code gives an error “your QC is not connected. Please check with the administrator”
Set TSetFact = QCConnection.TestSetFactory
Set tsTreeMgr = QCConnection.TestSetTreeManager
nPath = “Root\folder\” ‘<————- FILL IN PATH TO TESTSET
Set tsFolder = tsTreeMgr.NodeByPath(nPath)
If tsFolder Is Nothing Then
MsgBox "error"
End If
MsgBox tsFolder.Path
Set tsList = tsFolder.FindTestSets("Main") ' 1 Then
MsgBox “FindTestSets found more than one test set: refine search”
ElseIf tsList.Count Then
MsgBox “success”
Else: tsList.Count = 0
MsgBox “FindTestSets: test set not found”
End If
If there is a workaround or resolution please share
April 15th, 2010 at 8:01 pm
Hi,
I need code to export the test cases from test plan to our local system in excel.Please help me.
April 19th, 2010 at 3:42 pm
Hi, I want to upload an excel spreadsheet with Business Components info (parameters names, types, default values, etc) to Quality Center in order to generate a component on it.
A sample code or reference on how this can be done will be great.
Thanks!
April 21st, 2010 at 12:03 am
Did anyone actually get the Java to COM to work? I’m looking to execute QC tests from our Hudson CI server. If it’s promising that could lead to a Hudson plugin.
April 21st, 2010 at 3:31 pm
Percy, we use called scripts in QC. Unfortunately, the step description in QC looks like HTML so when I apply the stripHTML to the step description, what normally appears as “Call ” becomes just “Call”.
I’ve tweaked your stripHTML to add a second regular expression to remove the around the script name when preceeded by the word “Call”
You might want to incorporate this too. I inserted it in between your replacement of line breaks and the replacement of all other tags
Dim calledScriptRegExp
Set calledScriptRegExp = New Regexp
calledScriptRegExp.IgnoreCase = True
calledScriptRegExp.Global = True
calledScriptRegExp.Pattern = “Call ”
‘Replace all line breaks with VB line breaks
strOutput = Replace(strHTML, “”, vbLf)
‘Replace all “Call ” lines to look like regular text, not HTML so they don’t get stripped
strOutput = calledScriptRegExp.Replace(strOutput, “Call script “”$1″”")
‘Replace all HTML tag matches with the empty string
strOutput = objRegExp.Replace(strOutput, “”)
April 21st, 2010 at 3:37 pm
My last post was supposed to have greater than and less than signs in it. “Call <script>” becomes “Call”
the reg expression line should be
calledScriptRegExp.Pattern = “Call <(.+)>”
if that doesn’t translate to this blog it’s (.+) surrounded by angle brackets.
May 31st, 2010 at 10:14 am
Hi
I have a query on the OTA workflow. In our project we have scripts having 100+ steps and I want to generate a report which has the step level pass/fail. Now I think we can implement it by using the custom field by working on OTA workflow. I am not sure if I can in the right direction and also I am not sure how to work on this. Can you please help me how to go about it and also what level of access will be required by me to implement this. Currently I am the project manager on the project and only have the viewer access.
Regards
Abhishek
June 17th, 2010 at 10:17 am
Excellent code!! Worked!!! Can someone give similar code, but not for defects, but for PULLING EXECUTION STATUS (pass/fail/no run) to excel, each day?
Our project is stuck and running slowly because of this. Please help.
August 9th, 2010 at 10:53 am
For QC v8.2 the QCconenction.Login will not work..u will get error QCConnection.login not supported error message. please use as below.
Dim sDomain, sProject
sDomain = \XX\ ‘<– Change me.
sProject = "XX" '<– Change me.
QCConnection.InitConnectionEx "http://../qcbin" '<– Change me.
QCConnection.ConnectProjectEx sDomain, sProject, sUserName, sPassword
August 17th, 2010 at 5:40 pm
Hi,
I need to know the API for Test plan folder in QC10.0 version
My requirement is :
To update the “Dependancy” field in Test case undera a folder by running a vb script.
Cud u pl help in giving the name to use for the dependency field in VBscript.
Thanks
August 19th, 2010 at 2:30 pm
I need to get the graph from QC OTA and publish it. Here is my code
Dim Graph
Dim Filter
Set Filter = TestFactory.Filter
Set graph1 = TestFactory.BuildSummaryGraph(“TS_STATUS”, “TS_STATUS”, “”, 0, Filter, False, False)
MsgBox Graph.ColCount
MsgBox Graph.GraphTotal
MsgBox Graph.MaxValue
MsgBox Graph.RowCount
I get the error as below
Microsoft VBScript runtime error (41, 1) : Type mismatch: ‘BuildSummaryGraph’
August 25th, 2010 at 4:39 pm
Hi,
I want to write a VB script to update the responsible tester name field for corresponding test cases fetching the input from excel using Macro. The connectivity from Excel is working. Please let me know on how to update this specific field – that is what field name has to mentioned in the query to update the responsible tester name.
Thanks
October 21st, 2010 at 3:41 pm
I want to get the list of users with their QC Login ID and Full name for a project. Please share.
November 9th, 2010 at 10:28 am
is there any script to upload test cases to QC 10. I tried using the excel plugin but it is not working. I have excel 2007.
November 11th, 2010 at 1:55 pm
hi
i have a prob while exporting the test set
My Testplan is like the followin
Project –> Module –> Release –> UseCase id
while my Test lab looks like
Project -> Release –> Iteration –> Module — Type of test (Acceptance, functional)
can anyone let me know how to export only the test lab so that i get the execution status of the test cases
December 11th, 2010 at 6:19 pm
Hi do you know how to export the QTP script from QC? I can view the script under Test Script tab and want to batch copy the script to local file
December 23rd, 2010 at 6:04 pm
Need specific help on importing test results into QC from excel. Thanks
January 12th, 2011 at 10:00 am
I need to export the count of the test instatnces in a test set according to their test satus. Please help me with the code in VBS.
Thanks
February 17th, 2011 at 11:06 am
Hi,
I am trying the script provided by Percy for exporting the test cases from QC to excel, but getting an error message. The version is QC 10.
Please let me know if anyone is using the same script for QC 10.
Thanks & Regards,
Sarfraz.
February 20th, 2011 at 7:25 pm
When I am using the script
Dim QCConnection
Set QCConnection = CreateObject(“TDApiOle80.TDConnection”)
QCConnection.InitConnectionEx “http://10.61.4.185:8080/qcbin”
QCConnection.login “username”, “”
QCConnection.Connect “Default”, “DECE”
Dim BugFactory, BugList
Set BugFactory = QCConnection.BugFactory
Set BugList = BugFactory.NewList(“”)
Dim Bug, Excel, Sheet
Set Excel = CreateObject(“Excel.Application”) ‘ Open Excel
Excel.WorkBooks.Add() ‘ Add a new workbook
‘ Get the first worksheet.
Set Sheet = Excel.ActiveSheet
Dim Defect, Row
Row = 1
‘ Iterate through all the defects.
For Each Bug In BugList
‘ Save a specified set of fields.
Sheet.Cells(Row, 1).Value = Defect.Field(“BG_BUG_ID”)
Sheet.Cells(Row, 2).Value = Defect.Summary
Sheet.Cells(Row, 3).Value = Defect.DetectedBy
Sheet.Cells(Row, 4).Value = Defect.Priority
Sheet.Cells(Row, 5).Value = Defect.Status
Sheet.Cells(Row, 6).Value = Defect.AssignedTo
Row = Row + 1
Next
‘ Save the newly created workbook and close Excel.
Excel.ActiveWorkbook.SaveAs(“c:\QualityCenter_Demo_DEFECTS.xls”)
Excel.Quit
exactly at Sheet.Cells(Row, 1).Value = Defect.Field(“BG_BUG_ID”)
I am getting an error message as
Line 19
Char 1
Error Object required:”
Please help me guys
March 9th, 2011 at 9:44 am
Hi,
I do want to create a vbscript in excel that will search and extract the Test ID and the corresponding TC Name from the Test Plan Tree on the basis of the TC Requirement Reference entered.
The idea is the TC Requirement Reference will be provided, the script will search all the test cases in the Test Plan tree and will extract the corresponding TC name and Test ID and will write it down in a excel file.
Please can any one help me out with this requirement?
March 11th, 2011 at 9:37 pm
I have testers who dont have QC access and log their results in excel, can i write an api to log the results in QC from excel?
March 17th, 2011 at 3:41 pm
Hi,
Where do I user Filter in extracting Bug Defects, for example defects only created after 01/01/2011. I do not want to extract Each Bug in Buglist but only ones created after Jan 2011.
All reply will be highly appreciated.
Thanks
April 6th, 2011 at 5:38 pm
Hi,
I am beginning with API QC and i would be grateful you answer me.
How to use the Open Test Architecture API in order to run VAPI-XP test from Quality Center using (reading) Resources Module.
The Resources Module tree looks like below:
Ressources
MyApli
DataTable
Functions
function1
function2
………….
………..
The VAPI-XP test scripts are made up of function calls from \MyAppli\ (see tree ) and DataTable are the script parameters. For instance
script1 may be made up of function1 and function2 and I’d like to know, please which API objects I have to use. Something like
import function1/function2/DataTable into the script1.
Thank you very much to reply
Cheers,
April 7th, 2011 at 9:47 am
I spent a couple of days searching on Google to find something that would get me started on OTA, this was perfect.
One little problem, however, when I look at the Site Admin tool in QC I find the session that I had opened is still listed despite executing the clean up code given.
April 25th, 2011 at 9:36 am
i got an error msg at this line ” Excel.WorkBooks.Add() ”
syntax error
May 11th, 2011 at 11:18 am
Nice Article..Keep me posted..
May 20th, 2011 at 6:53 am
Nice and thanks. I need information regarding executing test cases thru macros like field names etc.,
thanks – Sri
June 9th, 2011 at 7:19 pm
I am using your code to export QC tests to excel and it works wonderfully. I have also made your that the credit for creating the script also goes to you.
Good work.
-Ab
July 18th, 2011 at 9:58 pm
I have prepared the vba code to export test case with result (pass/fail) to QC Test lab for each test set.
I want to run this query (using OTA archi) in ms excel 2007 for QC 9.0.
But one basic question i have is before running the query in Excel do i need to download any excel add-ins or anything as such?
Thanks,
Santosh
August 10th, 2011 at 7:53 am
I have test results. I mean Request and response and the test case is passed.
Both request and responses are in ‘.txt’ type files.
I have to run the test cases in QC and need to upload these tests results for the test cases in Test Lab.
Can you please tell me can we do this from xls file and VB scripts?
August 17th, 2011 at 6:10 am
The code below ,is for uploading attachments to quality center 10.00
Function UpLoadAttachmentToQC(FilePath)
Set ObjCurrentTest = QCUtil.CurrentTest.Attachments
Set ObjAttch = ObjCurrentTest.AddItem(Null)
ObjAttch.FileName = FilePath
ObjAttch.Type = 1
ObjAttch.Post
ObjAttch.Refresh
End Function
FilePath=”C:abc.vbs”
Call UpLoadAttachmentToQC(FilePath)
but to achieve the same task in quality center 9.00———–
Function UpLoadAttachmentToQC(FilePath)
Set ObjCurrentTest = QCUtil.CurrentTest.Attachments
Set ObjAttch = ObjCurrentTest.AddItem(Null)
ObjAttch.FileName = FilePath
ObjAttch.Type = 1
ObjAttch.Post
ObjAttch.save(True)——————- Extra method is needed
ObjAttch.Refresh
End Function
FilePath=”C:abc.vbs”
Call UpLoadAttachmentToQC(FilePath)
my question——–
Is save method is not working with quality center 1.00 Version ??
Also tell me the difference between post nad save Method ??
August 20th, 2011 at 6:22 pm
I have a requirement where I need to retrive the execution status of all the initiatives in a release from Quality Center to excel file .
Basically, i am looking for a macro that would actually get the me execution status ie., # of test cases passed, failed,outscoped. This data should be transported from Quality center to Excel sheet . I have a constraint that I am not suppossed to creat any filters for reports int he dashborad.
August 25th, 2011 at 4:30 pm
Hi guys,
Can anyone let me know the way how to find out the No.of test cases executed in the test lab. Am going to get this details by giving the From-To date. So that macro should give the exact executed TC count which are exectued within the given date limit.
Pls guide me to get rid of this puzzle.
Thanks in advance
October 4th, 2011 at 11:03 am
Can we upload attachment in QC without executing the script from QC?
October 12th, 2011 at 5:06 pm
Hi dude!
Can you pls, tell me how to get the list of items from QC Defects fields using API?
Ex: I need to get the list of items available in Severity field like “1-Critical”, “2-High”, and so on …
November 1st, 2011 at 6:10 pm
Helo All,
Is there any way we can download an attachment stored under a defect?
under defect module, there are lot of defects , using defect ID , i should be able to download all word documents under that defect.
i want to do this using QC API, please help.
November 7th, 2011 at 10:51 am
Hi,
Can you please tell me how to run selenium test cases from qc?
Thanks,
Sneha
November 7th, 2011 at 8:39 pm
I need your help in importing test result from excel to QC? i have a excel sheet which have testid and corresponding test status (pass/fail), i want to upload this into QC test lab? i tried lot but not able to get any working solution. currently we got stuck. can anybody helps us how to do that using OTA API?
November 10th, 2011 at 2:23 pm
Hi, am using JACOB api to access HP quality center to run scripts, Can anyone please share sample code to connect QC through JAVA… Thanks in advance Srikanth kasam.srikanth@gmail.com
November 16th, 2011 at 6:33 am
Hi,
Thanks for this article but,
How can I write into a table of SQL server, thru OTA using vbscript.
I tried using list and commit; but it shows errors.
Next is how do I do the same to any particular field of any table in OTA using vbscript macto.
Thanks Maxx
November 25th, 2011 at 10:18 pm
Hi,
How can I find all available fields in Defect Field.
i want to extract all defects raised today , but i am not able fins which fields holds the value of detected date. Can you please help.
Thanks
saj
November 27th, 2011 at 4:41 pm
HI all,
I would like to fetch individual test step results from QC using Excel macro can anyone help me with the code
November 30th, 2011 at 9:10 am
Hi,
I need to know if I can populate the all fields in Defects tab while raising a new defect, using OTA. I would like to know if I can pull values from excel to populate the defect fields, to make it generic.
December 3rd, 2011 at 4:31 pm
Hi,
i have a doubt in exporting the defects from Qualitycenter10.0 to MS ACCESS. i have a field called “Product”(i mean different Applications using the same Domain and Password) in the defects data.i want to export all the defects(for all applications) into MS Access db. i could not able to find the field name in the BUG table in Quality center for the column product.Could you pls help me in getting the data through VBA as i needed it urgently.
Thanks in advance!!!!!!!!
December 7th, 2011 at 11:54 am
Hi,
I am trying to download the test results from test lab to my local system, but i don’t have the path where the test results are stored. Can you please help me by providing the code for downloading the test results from test lab to my local system.
Thanks
N.Parameswaran.
January 3rd, 2012 at 6:07 pm
I’m trying to find an example where I can turn a QC defect into a Requirement. I’d like to add a button on the Defect details page that will take some of the defect fields and generate a new requirement.
January 5th, 2012 at 11:08 pm
Hi,
I’m trying to get the defect information from Central Defect project, using filters Detected in Version of a project.
Can you please help?
Thanks,
Amit Chaudhary
January 13th, 2012 at 11:06 am
Hi,
I need to pull defect report from QC in excel. The ablove script is working fine for that. But i need the following fields too:
-> Sub Project Id
-> Root Cause
-> Sub Root cause
When i use the code like
Sheet.Cells(Row, 6).Value = Bug.RootCause
it is throwing error. Please suggest the exact name for the above fields. TIA
January 13th, 2012 at 10:43 pm
Hello,
Have you ever tackled bringing in tests written in Excel in to Quality Center. I tried recording a macro in Excel but it stops once I click on Tools> Export to Quality Center. Any chance of getting a macro or other code to do the export from Excel to Quality Center?
Thanks,
Mirko Prudek
January 16th, 2012 at 3:13 pm
I found the answer in google, remove the topic pls.
January 25th, 2012 at 10:44 am
hi,
I want all the fields in the bug table and do not know the field names, how can I use For loop withing For Loop:
For Each Bug In BugList
For i = 0 to countof bugfields
Sheet.Cells(Row, 1).Value = Bug.Field(??) — here I need to use some index
Row = Row + 1
Next
January 28th, 2012 at 12:46 pm
Hi,
I want the code for “How to raise a defect in QC using the Excel VBA Macro”. Can any expert solve me this issue plz????
January 30th, 2012 at 6:51 am
I need an excel macro code to extract the number of test runs associated with each of the testcase in a testset from QC Test Lab. Any guidelife would be appreciated.
February 7th, 2012 at 10:33 am
Hi,
I want a code that connects database of QC using java.
Thanks in advance!
February 29th, 2012 at 11:57 am
Hi All,
I have just managed to extract all the test cases from Test Plan with desired columns including their step descriptions & expected results using SQL Query Builder
Please find it below if it comes to any of your use:
Select a.TS_USER_01 as ITT_Ref,a.TS_USER_02 as URN,a.TS_TEST_ID as Test_ID,b.DS_STEP_NAME as Step_Name,b.DS_DESCRIPTION as Description,b.DS_EXPECTED as Expected_Result from TEST /*Test*/ a, DESSTEPS /*Design Step*/ b where (a. TS_TEST_ID = b. DS_TEST_ID )and (a.TS_SUBJECT /*Test.Subject*/ in (Select ALL_LISTS.AL_ITEM_ID /*Test Plan Folder.Item Id*/ from ALL_LISTS /*Test Plan Folder*/ where ALL_LISTS.AL_DESCRIPTION /*Test Plan Folder.Name*/
=”))
March 1st, 2012 at 6:28 am
I want to change Release field and Project field for 2200 Test cases by running a program
Please help me in this regard.
March 8th, 2012 at 1:56 pm
Hi
I need is to MAP a testcase with a Requirement with VBscript in QC, both testcase and requirements already exists in QC.
Can any one provide me with the available ReqFactory APIs
April 1st, 2012 at 7:01 pm
Hi,
Thanks for article but I am facing an issues:
1. We have to include Excel.Workbook.Add to some variable, wchich you have not assigned.
2. I am getting R6025- Pure virtual Function Call error.
Plz help me out.
April 4th, 2012 at 3:54 am
Hi,
This article rocks!!!! really helpful I am using this in my code. And it is working cool!!!
I need one help on this code is that currently we have following code:
Sheet.Cells(Row, 1).Value = Bug.Field(“BG_BUG_ID”)
Sheet.Cells(Row, 2).Value = Bug.Summary
Sheet.Cells(Row, 3).Value = Bug.DetectedBy
Sheet.Cells(Row, 4).Value = Bug.Priority
Sheet.Cells(Row, 5).Value = Bug.Status
Sheet.Cells(Row, 6).Value = Bug.AssignedTo
I want to fetch defect for selected project. How can I filter it , is there any help.
If i have two project then I have to select defects for only one project. Currently it is giving me all defects!!! please help..
April 13th, 2012 at 5:27 pm
If you want to run it in Excel, change Sheet.Cells to ActiveSheet.Cells
April 26th, 2012 at 5:05 am
HI, we need to export test cases from excel file in to QC using OTA. Can you pls help in this…we have problem how to read test case data from excel. the test cases are writen in standard QC format.
In the excel file, there are multiple test cases and each test case consists of different steps. each step has input action and corresponding expected result. pls help
May 23rd, 2012 at 2:16 pm
I want to retrieve Defect data and Test Lab data from QC 10 into internal website, without using any excel. Want to provide a user interface on an internal website. Could someone please let me know if this is possible? If yes, then can some code snippets be shared here? Thanks a lot!
June 2nd, 2012 at 10:53 am
Hey its very nice really helpful
but can some one tell how can i do the same in Java
is there any way by which i can convert dll into Jar ?
if so then which DLL needed to be convert.
Actually I want to use the same in Selenium.
June 24th, 2012 at 6:11 pm
HI,
I would like to know how to filter defects using Defect cause and category.
What field name need to use.. like “BG_USER_??”
Thanks
June 29th, 2012 at 6:48 am
Hi … This is amazing article.
I am searchin for a script in which we can update the status fo the test cases as pass or failed are per mentioned in the excel sheet .
Could you please help me for this.
Thansk a lot again
July 9th, 2012 at 6:05 pm
Is it possible to execute certain manual testcases in a testset with the status of the execution,the testcases name and their path in the QC taken from an excel sheet..? If Yes, can u please share the code.
July 24th, 2012 at 7:15 am
Hi,
Very useful article.
I am supposed to create a daily report representing the execution status (Pass/Fail/On Hold/ No Run) of test cases in specific folder.
Could you please help me?
Thanks in advance!
Regards,
Kanchan
July 24th, 2012 at 4:32 pm
Hi, Is there a way to extract requirements to an excel sheet?
July 24th, 2012 at 4:34 pm
Hi,
I want to get the child elements of a group requirement. Please advise on how to do so. thanks
July 25th, 2012 at 4:42 pm
Hi
Is it possible to download attachments from QC to local drive?
Please help
Thanks
August 2nd, 2012 at 7:44 pm
can we export test case s from Excel to QC 10 using OTA.
this question has been asked several times in above blog but not answered.
Please let me know is it possible to export them?
August 13th, 2012 at 12:42 pm
Is there any VB script for user adding to Quality center10(i have 100 user i want to add at a time).
August 20th, 2012 at 2:40 pm
Hi All,
I want to extract test run count for each test case.
E.g if i have executed test case 3 times in same test set then it should give me count as 3 rather than 1.
Can you please help me on this?
Thanks in advance
Regards,
Shubhangi
September 26th, 2012 at 7:28 am
Hi,
Currently the code exttracts only some fields like Defect_Id, Summary, Detectedby, priority, status & AssignedTO.
If i need to display all the filed into excel sheet then?
Please le me know.
Thanks
Madhukar Sreeramoju
October 7th, 2012 at 11:15 am
Hi,
for connecting QC version 10 to MSExcel,in the OTA code in visual basics what should be given in th gap “http:// /qcbin”.