Question asked by Visitor Abhijeet

hi,
I want to export 'All testcases at a time' from Mercury Quality Center 9.0 to Excel.
I have gone through all questions previously asked regarding this issue, but didnt found the answer.
Could you please let me know, whether it is possible to export "All testCases at a time" from QC? and how?

Regards,
Abhijeet

We can’t export to excel rather we can export all at a time to Word, which was a recent issue for me :-(

Hi guys i would like to know how do we export all test cases in test plan tab of quality center in word at a time. Anyways, i would like to differ that we cannot export all test cases at once in excel. Hers is how to do it - if you see the site admin tool in qc, you can see the qc db structure. You will see the tables that store the test cases (i think it is the 'steps' table that stores the test cases steps). In case you have ms sql server 2005 as the backend db, open up query analyzer/ management studio dependent on the version, 'use db' the qc database, then query the qc db to create a table with the attributes you want to. You can then export these files in excel through sql server.

Hi Abhijeet,
We can't export all Testcases from QC to excel sheet.If you want then we can export all sub steps under a Testcase at once to excel.If you want all Testcases from a folder then its not possible.If you want to use these Testcases as a reference purpose then you can generate a documnet by using Document Generation Option rather than exporting to excel sheet(ofcourse not possible).

Thanks
Deepika.P

Hi Deepika,

can u tell us in steps of how we will export Test Cases -sub sets at a time to excel.

thanks in advance
Pavani

Hi,
My name is krishna i want to download the excel files from the quality center but the main problem is the files size are huge and it take a lot of time is there any way to download or export the excel files in a quick way.

Hi, I am Pushpendra regarding question 'export testcases from QC to excel' is possible
by using a tool name Juvander.
U need to install this tool in ur machine but that u can use only for 15 days as this is a trial version.Cheers

Hi Everyone,

First thanks for ur above reply,however i founded out a procdure to download excel attachment and contingency plans with a single click.
i would like to explain everyone about how to export contingency test plans and excel attachments from the selected test set or folder.

I mean we can download excel run attachment and contingency test plans from DOCUMENT GENERATOR from QC.
If any one require the work flow mail me ur questions in this form.

Thanks,
Chaitu

hi chaitu,

I want the workflow of how to download excel attachment and contingency plans with a single click.


Thanks
Arandkar

Hi Arandkar,

Well this is as simple as it is.
1.Open your QC (QualityCenter) and in the right side of the page u will find tools option click on it and u will see a option called document generator.
2. The Document Generator window will appear from this window we can generate contingency test plans into a word document.
3. If u want to download contingency test plans select test lab folder and select the respective options as per ur requirement, and finally click on Full Document button the QC will progress all the folders which u have selected and will export the contingency test plans into a word document.

If u still are not aware on how to do this u can find the help icon in the top right side corner if u click a new window will open where u can find about each and every option in details and how it works.

Well i tried my level best of write the flow of it but i dont have QC in my home so i cannot tell u excatly sorry about it.But dont worry its so simple just go through the help option and try generating some documents then u will get the result okay ENJOY.
Regards,
Chaitu

you need to create one macro to consolidate all test cases at one sheet. then make sure that Excel -addins are available...then highlite all test cases which are in consolidated Excel sheet and go to excel menu--tools--export to quality Center--provide qc credentials--select test (since you are going to upload test cases)-- map the excel columns with QC fields--finish.

that's it....