Upload Test Cases From Excel To Qc Using Vbscript

by
Upload Test Cases From Excel To Qc Using Vbscript Rating: 9,4/10 30reviews
Upload Test Cases From Excel To Qc Using Vbscript

Hi Ravi, Explaining you from the start, we have manual test cases in QC ALM where u add “parameters” in Test Plan say Login function – userid and password. You can login to the system with various different userid’s and passwords. Now we transfer all these parameters from Test Plan to Test Lab. Here in the Test Instance properties under the Execution Settings, when u run our test, it asks us to add “Actual Values” at Run time. The name of the window is “Parameters of Test_Run” in Test Lab in QC which pops up everytime we input our “Actual Values”.

Using VBScript Code In QTP. DataTable. Fafi Dream Guide Software here. AddSheet oSheet.Name End If 'Import the sheet DataTable.ImportSheet FileName, oSheet.Name,oSheet.Name Next Set oBook = Nothing 'Quit Excel oExcel.Quit. In case the action in present in some other test case then a read only copy of action is inserted. I wanted to update my test case status in Test Lab in Qc from. Updating Test case status in Test Lab(qc) from Excel. Access the Test Cases inside the Test. Every time the user will NOT be in a position to create test cases manually. Hence HP has come up with an Excel Addin with which the user can upload from excel. Aug 19, 2011 - You can use just vbscript using OTA. I need to search for a particular attached file name in test plan module.how to get the test case name with which the file attached. QTP script to write a sql query result into an excel sheet and then upload this into the test lab folder as attachment in QC.

So what we have to do is to input these “Actual Values” in each step of our TC’s and then finally Pass the TC. This has to be accomplished for every TC and the parameter values change for every TC. The scripts have to be written in QTP and then the values have to be inputted in QC for every step. Can u tell how this can be accomplished. I have QTP 11 and QC ALM.