Export test cases form quality center to excel sheet or XML format. (27621 Views)
Reply
Occasional Contributor
tanujm
Posts: 1
Registered: ‎07-04-2012
Message 1 of 52 (27,621 Views)

Export test cases form quality center to excel sheet or XML format.

Hi all, 

is there a way to export test case form quality center to excel sheet or xml format ???

 

 

thanks

tanuj 

Please use plain text.
Trusted Contributor
visit_alok
Posts: 139
Registered: ‎07-03-2012
Message 2 of 52 (27,615 Views)

Re: Export test cases form quality center to excel sheet or XML format.

Yes you can export data from QC to Excel and vice versa.

 

To do so you need to install the excel addin into the client machine from where you want to export the data.

 

1. Go to the Addin page -> More HP Quality Center Add-ins -> Microsoft Excel Add-in.

2. Download the addin and install it. (Need admin rights on the local machine to install it. No admin rights required to run).

3. Login to QC.

4. If you are in Requirement or Test Plan module then you need to change the View to Grid View. (For defect module there is no separate views)

5. If you want selected data then first set the filter according to your requirement.

6. Right Click on the data and go to the "Export".

7. Provide the location and the appropriate format (extension).

Please note :- Any solution or queries expressed in my postings are mine alone, and do not reflect the opinions of my employer.
Please use plain text.
Trusted Contributor
alexanderk
Posts: 122
Registered: ‎04-03-2012
Message 3 of 52 (27,603 Views)

Re: Export test cases form quality center to excel sheet or XML format.

Actually you don't need to install Excel Add-in to EXPORT data.

Add-in is needed if you want to IMPORT data from excel file to QC.

Please use plain text.
Advisor
GD
Posts: 19
Registered: ‎06-29-2011
Message 4 of 52 (27,592 Views)

Re: Export test cases form quality center to excel sheet or XML format.

You can use an Excel report to export test cases if you like.  Here is a query that I used to export some test cases:

 

SELECT

 

 TEST.TS_TEST_ID as "Test ID", /*Test.Test ID*/
 TEST.TS_NAME as "Test Name", /*Test.Test Name*/
 TEST.TS_DESCRIPTION as "Test Desc.", /*Test.Description*/
 DESSTEPS.DS_STEP_NAME as "Step Name", /*Design Step.Step Name*/
 DESSTEPS.DS_DESCRIPTION as "Step Desc.", /*Design Step.Description*/
 DESSTEPS.DS_EXPECTED as "Expected Result", /*Design Step.Expected Result*/
 TEST.TS_STATUS as "Test Status", /*Test.Status*/
 TEST.TS_TYPE "Test Type", /*Test.Type*/
 TEST.TS_RESPONSIBLE as "Test Designer", /*Test.Designer*/
 TEST.TS_USER_03 as "Test Priority", /*Test.Priority*/
 TEST.TS_USER_04 as "Test Reviewer" /*Test.Reviewer*/


FROM

 

 Test,
 DESSTEPS

 

WHERE

 

DS_TEST_ID = TS_TEST_ID

Please use plain text.
Honored Contributor
Trudy Claspill
Posts: 3,091
Registered: ‎09-09-2010
Message 5 of 52 (27,583 Views)

Re: Export test cases form quality center to excel sheet or XML format.

Alternately, depending on what exactly you want to export from QC to Excel, you can choose to display data in Grid View (if available this is an option under the View menu in some modules), then select items, then right click in the Grid area and select Export.

[If this post solves or helps solve your issue, mark the thread as solved and give KUDOS to the author for their assistance.]

(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)
Please use plain text.
Respected Contributor
Andrey_L
Posts: 206
Registered: ‎04-02-2012
Message 6 of 52 (27,582 Views)

Re: Export test cases form quality center to excel sheet or XML format.

Hi,

Not so long ago, I found on one of QA forums great tool (Thomas H Kendall)

And I almost sure that this tool will help you!

Tool can download from QC: Requirements, Tests, Test Sets. Also you can select what fields you want do download!

 

see attacments

Please use plain text.
Occasional Visitor
sivaraj2003
Posts: 1
Registered: ‎12-21-2012
Message 7 of 52 (26,564 Views)

Re: Export test cases form quality center to excel sheet or XML format.

I downloaded the 'QC Download Tool v5.1.xls' and i provided the QC URL, User name and Pwd in the pop-up window.

But i get a message that "Quality Center User Authentication Failed. Invalid User name or password"

I provided the same Username / pwd that i use to access QC over the web. I am not using QC Client in my machine and I do not have any add-ins installed. Is there a way i can download the test scripts/sets to Excel??

Please use plain text.
Occasional Visitor
mimistorey
Posts: 1
Registered: ‎02-06-2013
Message 8 of 52 (25,974 Views)

Re: Export test cases form quality center to excel sheet or XML format.

Somebody put what looked like a really useful tool (QC Download Tool v5.1) on here to export tests into excel but it doesn't work with Excel 2010.  Has anybody got a later version which will work?

Please use plain text.
Occasional Visitor
SN0001
Posts: 2
Registered: ‎02-14-2013
Message 9 of 52 (25,750 Views)

Re: Export test cases form quality center to excel sheet or XML format.

Hi

 

This tool looks very user friendly,  unfortunately authentication is getting failed when I enter my QC login details.  Can some one please help with the functionaing of the tool.

 

Thanks

SN

Please use plain text.
Occasional Visitor
Vina
Posts: 2
Registered: ‎02-14-2013
Message 10 of 52 (25,708 Views)

Re: Export test cases form quality center to excel sheet or XML format.

authentication should work if you remove start_a.jsp frm the url.

Please use plain text.
Occasional Advisor
Masthi
Posts: 8
Registered: ‎11-07-2011
Message 11 of 52 (25,685 Views)

Re: Export test cases form quality center to excel sheet or XML format.

still getting authentication error

Please use plain text.
Occasional Visitor
Kate00
Posts: 1
Registered: ‎02-26-2013
Message 12 of 52 (25,406 Views)

Re: Export test cases form quality center to excel sheet or XML format.

Hello,

 

I used the Download Tool and received the following message:  'Root\DCM Upgrade 2012\SAT_UAT\DCM UI Functionality' is not a valid integer value.  This is the path to my Test Set.  Does anyone know what I'm doing wrong?

Please use plain text.
Occasional Visitor
RFinan
Posts: 1
Registered: ‎03-06-2013
Message 13 of 52 (25,166 Views)

Re: Export test cases form quality center to excel sheet or XML format.

I'm trying to get this to work and I'm struggling a little bit. I've managed to get the blue logon screen to appear, but when I enter the QC details and select Authenticate, I get a Visual Basic error "Compile error in hidden module: Logo".

Does anyone know how to resolve this?

Thanks

Please use plain text.
Frequent Advisor
Sogeti-HPQCGuru
Posts: 21
Registered: ‎03-18-2013
Message 14 of 52 (24,749 Views)

Re: Export test cases form quality center to excel sheet or XML format.

Please try to eliminate the Root folder.

Please use plain text.
Frequent Advisor
Sogeti-HPQCGuru
Posts: 21
Registered: ‎03-18-2013
Message 15 of 52 (24,748 Views)

Re: Export test cases form quality center to excel sheet or XML format.

I was able to find a solution. This is beacuse it is missing the "c:\windows\syswow64\comdlg32.ocx" file (which is an active x control). this link (http://windowsxp.mvps.org/comdlg32.htm) gives you the file to download and how to register… in my case (in the image attached) you can see it is referenced in "SysWow64" and not System32 as the link explains… this is the only change I did when copying and registering the file. I suggest you open the project and check the references (Open Excel Press and hold ALT+F11. Once in go to Tools->References) to see where VB is looking for this file at and put it there and register it. If you are on Windows Vista or 7, ensure that when running the command in the CMD prompt you should open it as an administrator (click Start, click All Programs, click Accessories, right-click Command Prompt, and then click Run as administrator).

Hope this helps!

VBScriptPic.png

Please use plain text.
Occasional Visitor
LKAMINEDI
Posts: 1
Registered: ‎03-22-2013
Message 16 of 52 (24,742 Views)

Re: Export test cases form quality center to excel sheet or XML format.

THANK YOU THOMAS FOR  THE GREAT TOOL

 

IT WORKED FOR ME

 

 

LKAMINEDI

 

 

Please use plain text.
Frequent Advisor
Sogeti-HPQCGuru
Posts: 21
Registered: ‎03-18-2013
Message 17 of 52 (24,732 Views)

Re: Export test cases form quality center to excel sheet or XML format.

Thanks! Glad i can help!

Please use plain text.
Frequent Advisor
Sogeti-HPQCGuru
Posts: 21
Registered: ‎03-18-2013
Message 18 of 52 (24,731 Views)

Re: Export test cases form quality center to excel sheet or XML format.

See answer below.

Thanks,

Sogeti-HPQC Guru
Please use plain text.
Advisor
5hippers
Posts: 19
Registered: ‎10-24-2012
Message 19 of 52 (24,653 Views)

Re: Export test cases form quality center to excel sheet or XML format.

Hi, I have used this tool may times, no problems at all.

 

Now I get the username and password error.

 

I have checked the VBA reference as above and it shows as ticked and valid... any other ideas?

 

 

Please use plain text.
Occasional Advisor
Vaiolina
Posts: 6
Registered: ‎04-17-2013
Message 20 of 52 (24,075 Views)

Re: Export test cases form quality center to excel sheet or XML format.

Hi all,

 

I'm really new in this forum, so I 'm not sure if this is the correct place to ask my question.

 

I'm using HP ALM v11.00, I want to export a test lab (test cases incl. test steps) to an excel (2007) file and make it possible to run the test steps from the excel file. Then to import all the results back  from Excel to HP ALM.

 

I have worked like this before, unfortunately I don't know how to make this setup and what is needed for that.

 

I have downloaded the excel add-in, the TDconnect.exe... I also succesfully exported from excel to ALM ( it stated successfully, but I couldn't see/find where was the export). 

I have tried the tool you have mentioned  "QC_Download_Tool_v5.1.zip" , successfully login, but was not what I needed. Though there was a small window that appeared for VBA password and whatever password I was giving, it was not acceptable.

 

I would appreciate your assistance.


 



 

Please use plain text.
Honored Contributor
Massimo De Rosa
Posts: 656
Registered: ‎03-02-2009
Message 21 of 52 (24,045 Views)

Re: Export test cases form quality center to excel sheet or XML format.

Hi all,

 

here a link to my site. There are lots of  example on how to extract data from qc under "How To - Tips&Tricks" section.

 

Hope this helps.

Ciao, Massimo.

Please use plain text.
Occasional Advisor
Vaiolina
Posts: 6
Registered: ‎04-17-2013
Message 22 of 52 (23,823 Views)

Re: Export test cases form quality center to excel sheet or XML format.

Hi,

unfortunately I couldn't find anything that could help. Any other suggestions?

 

Please use plain text.
Regular Advisor
MACHMAN
Posts: 185
Registered: ‎04-09-2012
Message 23 of 52 (23,763 Views)

Re: Export test cases form quality center to excel sheet or XML format.

[ Edited ]

Hi I am getting the same error when I tried using the tool ( Authentication failed username/pswd incorrect) any suggestions 

 

I tried the steps mentioned above by segati but still getting the same error... ALM 11, Excel 2010

Please use plain text.
Frequent Advisor
Sogeti-HPQCGuru
Posts: 21
Registered: ‎03-18-2013
Message 24 of 52 (23,357 Views)

Re: Export test cases form quality center to excel sheet or XML format.

If you are getting the Authentication Error, please ensure that you have place the .ocx file in the right folder. For 32bit, then it should be in the system32 folder. If you press & hold Alt+F11 it will open up the Microsoft Visual Basic window. Once opened, go to Tools>References and see if you are missing anything in there. Let me know what you find.

 

Thanks,

 

Sogeti-HPQCGuru

Please use plain text.
Occasional Advisor
Vaiolina
Posts: 6
Registered: ‎04-17-2013
Message 25 of 52 (23,338 Views)

Export HP ALM test cases incl. test steps to Excel

Hi,

 

When I tried to "Download Test Set to Workbook"  (QC Download Tool v5.1) - this time I got "root is not a valid integer value".

I have heard that for downloading/exporting test cases with test steps to xls file and being executable from the xls file I need "Excel Offline  Clien"  plug in. Unfortunately I'm not able to find it for download.

 

Any other suggestions?

 

 

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation