Export Test scripts from QC to Excel in Bulk

[Rati Saxena]

The script given to export the testcases and test scenario from QC to Excel doesn't work. Can anyone provide the updated script and let me know how to Export the data from QC to Excel????

[Harnarinder Sin]

I am trying to download all the test cases. When I run the .vbs file, all I could see is command prompt for few seconds and then nothing. Does it have to do with excel version I am using or QC version I am using? No excel file is created at root. I a using Office 2007 & QC 10. Please guide..Thanks

[JonPaulPatriot]

thanks for info

[Vinod Prabhakar]

Hi Percy ,

This is a good utility , but how can we make it user interactive . Can you let me know the part of the code which ask the user to input their username and password and also be able to input the subject folder . Is this possible if so could you please send me that part of the code.

Regards

Vinod

[Percy Bell]

Vinod,

If you look at the code that I posted above you will see lines that have a comment "'<-- Change me" in them. Those are the prompts that are asking for info. The values that are defined are the default values. Just put in what you want there.

[Vinod Prabhakar]

Hi Percy ,

Yes I have changed the values mentioned against the change me sign and the utility works perfectly for me . However these values are hardcoded , if I pass on this utility to a user , the user would like to enter his credentials. Hence in order to incorporate this feature could you suggest what modifications need to be done to the code. When the user double clicks on the vbs file it should prompt him for a user name and password and the project name and Domain name and also the subject name, so that this is user interactive.

Regards

Vinod

[Percy Bell]

Vinod,

Just input boxes for each of the fields that requires input.

i.e.
sUserName = InputBox("QC Username:", "Enter Username", "qc_alex")

[Vinod Prabhakar]

Thank you Percy ,for the input code , I tried this and it worked fine for the username password and for Domain and Project . However I was not successful in implementing it for the subject path

Call ExportTestCases("Subject\")

as this is also hardcoded how would I be able to ask the user to input this value as well .


Regards

Vinod

[Percy Bell]

Vinod,

Make the following changes:

Dim strSubjectPath
strSubjectPath = InputBox("Subject Path", "Enter Subject Path", "Subject\")


Call ExportTestCases(strSubjectPath)

[Vinod Prabhakar]

Hi Percy ,

Thank you for the suggestion , the logic is perfect but when I tried executing the utility after entering the Subject path it gives me an error message " The instruction at "0x1008bfa6" referenced memory at "0x016125bc". The memory could not be "read". Were you able to execute the utility without any issues. Any suggestions.

Regards

Vinod

[Percy Bell]

Vinod,

Not sure were you went wrong. My script works. It's been heavily modified since I've posted it here but it's essentially the same. Make sure that the inputs are correct. If it previously worked with hard coded values, make those hard coded values the default. This version doesn't have any checks to determine if the inputs are valid so you could be encountering an error from invalid input.

[Sunil Testing]

HI ,

HI,

I want to down load the test result of all the test set from a folder.

Eg:
Folder 1
Sub folder 1
Child Sub folder 1
Test Set 1 - some test case count
Test Set 2- some test case count
Test Set 3 - some test case count
Sub folder 2
Test Set 1 - - some test case count
Test Set 4 - some test case count

Could any one please help in extracting the test results

[Sunil Testing]

HI Percy ,

Please help in exporting the test case result with the test case Name

Thanks
Sunilkumar.R