Test Plan export from QC to Excel? (32658 Views)
Reply
Frequent Advisor
emmad
Posts: 63
Registered: ‎07-06-2009
Message 1 of 27 (32,658 Views)

Test Plan export from QC to Excel?

I've been asked to export the test's (including steps) from a set of manual test's from QC into Excel.  Now I believe this cannot be done? Or is there a way to do it.

Any help would be appreciated.

Honored Contributor
Sud_3
Posts: 353
Registered: ‎02-19-2009
Message 2 of 27 (32,652 Views)

Re: Test Plan export from QC to Excel?

Hi Emmad, 

 

This can be done by using OTA API.  

Save the attached Txt file as .vbs file.Double click to run and follow the instructions. 

Let me know if there any issues.

 

Thanks,

Sudhakar

Frequent Advisor
KyleTF
Posts: 34
Registered: ‎08-23-2010
Message 3 of 27 (32,651 Views)

Re: Test Plan export from QC to Excel?

I would suggest using the Dashboard in Quality Center. Create a new excel report and write a query using the TEST and DESSTEP tables. Try using this query to get you started, you may want to add or take out some info and format the output.

 

SELECT T.TS_NAME, T.TS_TEST_ID, T.TS_DESCRIPTION, T.TS_STEPS, S.DS_STEP_NAME, S.DS_DESCRIPTION, S.DS_EXPECTED
FROM TEST T, DESSTEPS S
WHERE T.TS_TEST_ID = S.DS_TEST_ID

 

you could also you the Document Generator under tools menu in Quality Center, but that will give you an word document.

 

let me know if you need more info.

 

Occasional Contributor
b-thier
Posts: 3
Registered: ‎06-30-2011
Message 4 of 27 (32,617 Views)

Re: Test Plan export from QC to Excel?

I agree with Kyle TF, i've been asked to do this many times and hthis sollution seems to be the best.
Frequent Advisor
sindu
Posts: 54
Registered: ‎10-13-2011
Message 5 of 27 (31,907 Views)

Re: Test Plan export from QC to Excel?

Hey Sudhakar ,

   I found your vbs script that you attached very interesting. How do i connect to TDApiOle80.TDConnection ?

Occasional Visitor
mufaddal_1985
Posts: 1
Registered: ‎05-17-2012
Message 6 of 27 (31,325 Views)

Re: Test Plan export from QC to Excel?

I ran the file u attached. It ran successfully and got completed message. But dont know where and by what name excel is generated?

Frequent Advisor
ShrikantK
Posts: 62
Registered: ‎02-10-2012
Message 7 of 27 (31,279 Views)

Re: Test Plan export from QC to Excel?

Hi,

 

I tried to use your logic in my tool but It is giving me an error that Node not Found,

 

Can you please suggest me?

Occasional Visitor
GoodTester
Posts: 1
Registered: ‎07-13-2012
Message 8 of 27 (30,193 Views)

Re: Test Plan export from QC to Excel?

The attached vbs file works great.. Thank you developer!

 

Few things that we can tweak are:

a) Login, password, domain, project can be directly fed in this .vbs file, so that you do not need to go through these all the time.

b) to avoid the node issue, enter the path this way..

Subject\.....\....\

remember to end with a '\'

c) File gets saved at c:\

search for the latest file in the root [C: drive].

This file gets overridden, everytime you try to extract [do not work out of this file directly, take a copy and work as required].

 

Hope your replies will reach my mailbox [trying to be anonymous though]

 

God bless!

 

Occasional Visitor
Rajesh_Nv
Posts: 1
Registered: ‎07-17-2012
Message 9 of 27 (30,063 Views)

Re: Test Plan export from QC to Excel?

Hi, Is there a way to export the execution status corresponding to each 'Test Step', I understand we can do it for each Test script, but my requirement is for each 'Test Step'

 

Thanks.

Honored Contributor
Trudy Claspill
Posts: 3,769
Registered: ‎09-09-2010
Message 10 of 27 (30,047 Views)

Re: Test Plan export from QC to Excel?

Rajesh_Nv,

Your question is about exporting data from the Test Lab (execution results) rather than the Test Plan, which is the original topic of this thread. Please start a new thread for your new question.
[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.)
Occasional Contributor
AMahmood
Posts: 6
Registered: ‎06-27-2012
Message 11 of 27 (28,563 Views)

Re: Test Plan export from QC to Excel?

[ Edited ]

Hi Sudhakar,

 

I run the script you provided but experienced errors.

 

After giving all required information, I set following path:

 

QC Test plan Folder Path: EBPP TCs\

 

Note: The first error is attached with this message for your reference.

 

What I am doing wrong?

 

Aki

Frequent Visitor
satmaurya
Posts: 2
Registered: ‎07-20-2012
Message 12 of 27 (28,268 Views)

Re: Test Plan export from QC to Excel?

I tried the Script and it worked for one QC url but for another one it was giving error 'Failed to Get Tree Node Value' Code 800403EA...
Occasional Visitor
lakumadevi
Posts: 2
Registered: ‎06-19-2013
Message 13 of 27 (20,349 Views)

Re: Test Plan export from QC to Excel?

Hi ,

I have tried doing multiple times and i got the Node not found error message.can you please help me here .

Occasional Visitor
johaahm
Posts: 1
Registered: ‎07-26-2013
Message 14 of 27 (19,254 Views)

Re: Test Plan export from QC to Excel?

I use a similar SQL query to get planned tests into an Excel report. In principle this works fine, but the steps are not sorted as expected:

assume you have a test with 4 steps. Later on you want to insert a step, for example as the 3rd step (of then 5 steps). 

Then the inserted step is the 5th step of the test looking at  DS_ID, DS_STEP_ID or DS_STEP_ORDER of the DESSTEPS table.

I find no way to reorder any of these IDs in order to get a report where the steps are sorted in the sequence they are displayed in the test plan.

 

Has anyone an idea how to reach the desired sequence ?

Thanks a lot.

 

Occasional Advisor
AlphaXu
Posts: 6
Registered: ‎10-14-2013
Message 15 of 27 (17,143 Views)

Re: Test Plan export from QC to Excel?

Occasional Advisor
AlphaXu
Posts: 6
Registered: ‎10-14-2013
Message 16 of 27 (17,142 Views)

Re: Test Plan export from QC to Excel?

Attach it

Occasional Advisor
AlphaXu
Posts: 6
Registered: ‎10-14-2013
Message 17 of 27 (17,140 Views)

Re: Test Plan export from QC to Excel?

Try this one

Occasional Visitor
Dlandis
Posts: 2
Registered: ‎10-29-2013
Message 18 of 27 (16,734 Views)

Re: Test Plan export from QC to Excel?

I just tried your Excel SQL solution. It definitely grabbed all the test cases with test steps.  But, is there a modification I can make to grab test cases with and without test steps?

Trusted Contributor
RajuThomas
Posts: 216
Registered: ‎07-04-2011
Message 19 of 27 (16,540 Views)

Re: Test Plan export from QC to Excel?

Are you using the tool or query. If query you can change the conditions TS_TEST_ID<>DS_TEST_ID for cases not in DesignSteps table. You probably can use a UNION statement combining queries with WHERE conditions which pulls Test Cases with Steps (TESTID=DESIGN TEST ID) and without out
Occasional Visitor
Dlandis
Posts: 2
Registered: ‎10-29-2013
Message 20 of 27 (16,386 Views)

Re: Test Plan export from QC to Excel?

Thanks! That worked great. One more question. I tried adding T.TS_SUBJECT to get the folder structure. But the values being returned are numbers like 132,133. Is there something else I should be using to get the sorrect folder values returned?
Honored Contributor
Massimo De Rosa
Posts: 656
Registered: ‎03-02-2009
Message 21 of 27 (16,344 Views)

Re: Test Plan export from QC to Excel?

Hi,

 

here it is a link on how to get the export as you need: http://motu4qc-en.jimdo.com/how-to-tips-tricks/excel-reports/test-case-steps/

 

 

For info mailto:info@motu4qc.it

 

IT Site: http://www.motu4qc.it

EN Site: http://motu4qc-en.jimdo.com/

 

Ciao,

Massimo.

Occasional Visitor
Hendry
Posts: 1
Registered: ‎01-07-2014
Message 22 of 27 (13,735 Views)

Re: Test Plan export from QC to Excel?

Hi.. I am getting the below error after giving username, pwd, QC URL.

 

'OTA Version not compatible with the ALM server' (PFA for more details)..

 

Please help here..

PMJ
Occasional Visitor
PMJ
Posts: 2
Registered: ‎01-15-2014
Message 23 of 27 (13,155 Views)

Re: Test Plan export from QC to Excel?

small functionality with respect to end user requirement.Currently this tool is proving the functionality of exporting manual test cases(Bulk export) from Quality center to predefined excel file and download qtp result from QC to local drive

https://sites.google.com/site/quickinfopocket/qtp-probs-solve/tools

Occasional Visitor
Sowmya-S
Posts: 1
Registered: ‎01-24-2014
Message 24 of 27 (12,631 Views)

Re: Test Plan export from QC to Excel?

Thank you...

Occasional Visitor
mohammedali
Posts: 1
Registered: ‎02-27-2014
Message 25 of 27 (10,662 Views)

Re: Test Plan export from QC to Excel?

Excellent work Sudhakar
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.