Test Plan export from QC to Excel?

[emmad]

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.

[Sud_3]

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

[KyleTF]

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.

[b-thier]

I agree with Kyle TF, i've been asked to do this many times and hthis sollution seems to be the best.

[sindu]

Hey Sudhakar ,

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

[mufaddal_1985]

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

[ShrikantK]

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?

[GoodTester]

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!

[Rajesh_Nv]

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.

[Trudy Claspill]

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.

[AMahmood]

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

[satmaurya]

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...