10-27-2010 04:46 AM
i am lily i am new to QC, i have a question..How to export all test cases from QC to Excel with steps in one shot..
i did checked "Export test scripts from QC to Excel in bluk" thread, but i want the answer in easier way may be (from database side) instead of writting micros
please help me in getting this done..
Thanks in advance..
10-27-2010 05:37 AM
convert(varchar(10), getdate(), 101) as ts_creation_date,
from td.test a, td.dessteps b, td.Z_ALL_LISTS_HIERARCHY c
where a.ts_test_id = b.ds_test_id
and a.ts_subject = c.al_item_id
and a.ts_type = 'MANUAL'
and a.ts_subject in (@subject)
order by a.ts_subject, a.ts_name, a.ts_test_id, b.ds_step_order
10-27-2010 10:58 AM
From the Tools menu, select Excel Reports...
Click the + icon, to create a new Excel report
Select the 'Query' tab.
Enter the following on Sheet1:
from TEST, DESSTEPS
where TS_TEST_ID = DS_TEST_ID
order by DS_TEST_ID, DS_STEP_NAME
Then click 'Run Query'. When complete the results will display below.
From the Post-processing tab, make sure the checkbox is cleared for 'Run post-processing'.
On General tab, change Status to Ready.
At top of left window, click the hammer and wrench icon to Generate Excel Report.
This take approximately 15 minutes per 250 tests and their steps.
10-27-2010 12:13 PM
I tried the above query, but i am getting "Programmatic access to VB project is not trusted" error message
here i am attaching the scrrenshot..
please let me know how to fix it and proceed...