How to export test cases from test plan in QC

Question

We use QC for test management tool in our project. Usually we write test cases & test steps in spreadsheets and load into QC using 'Export to QC' excel add-in. We have a set of test cases already present in QC and they need to be updated.

Is there a way I can export the test cases (along with test steps for each test case) from QC back to excel so that I can update them to load it back to QC??

Answer 1

This is how I do it:

1. Login to Quality Center.
2. Click Test Lab/Test Plan/Wherever you keep your test cases.
3. After creating the test set, configure the columns to display in the desired order.
4. Right click within the Test Set list and select Export > All.
5. Name the Export file and click save.

Exporting a test set is a lot easier than exporting from the test plan section, I've found. So if possible, consider bundling the tests, then exporting.

However if you really want to export from the Test Plan, click View > Test Grid. Then use a column to filter the displayed tests and export as explained above.

The third option is to export using SQL within Quality Center, but I've never explored that option too much as I've always had success with the first two methods.

Answer 2

there's a sample .vbs (but it was uploaded as .txt) in this forum -> http://h30499.www3.hp.com/t5/Quality-Center-Support-and-News/Test-Plan-export-from-QC-to-Excel/td-p/4807563

I haven't tried it myself though, but I do hope it helps you.