06-29-2011 02:05 PM
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.
06-29-2011 04:05 PM
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.
06-29-2011 04:06 PM
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.
07-13-2012 10:09 AM
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..
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]
07-17-2012 08:43 AM
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'
07-17-2012 11:19 AM
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.
(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.)
09-05-2012 02:47 AM - edited 09-05-2012 02:49 AM
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?
07-26-2013 04:28 AM
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.
10-29-2013 11:11 AM
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?
11-01-2013 10:01 AM
11-05-2013 12:48 PM
11-06-2013 01:37 AM
here it is a link on how to get the export as you need: http://motu4qc-en.jimdo.com/how-to-tips-tricks/exc
For info mailto:firstname.lastname@example.org
IT Site: http://www.motu4qc.it
EN Site: http://motu4qc-en.jimdo.com/
01-07-2014 02:04 AM
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..
01-15-2014 10:08 PM
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