I'm trying to automate reporting from QC by using QTP to export/save an excel file of the status of the tests on QC. I'm trying to use QTP's object manager to perform each task, but I am running into two problems. The first problem that I am encountering is getting QTP to recognize the different objects in QC. The second problem comes when I try to run the scrip to login. I keep receiving this error:
Following client components were not downloaded successfully:
1 . CompStrgHelper.dll :
(Error 32) The process cannot access the file because it is being used by another process. Failed to open file for writing
2 . CompStrgHelper.dll :
Cannot load type library
3 . CompStrgHelper.dll :
Cannot register type library
Close all connections to Server and try again.
If anyone knows how to fix this, or just another way to do it, please let me know.
Best way to get the reports from QC in an automated format is to use VBscript or any scripting language and fire SQL queries to backend of QC. You can refer more on "how to create queries for test cases etc" from the blog QTP Blog
In VBscript or excel, you can use ADODB connection and recordset to connect to QC backend database