Hp-QC - Upload Tests

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 directly. Let us understand the step-by-step procedure to upload test cases into QC from Excel.

Step 1 − Navigate to ALM home page and click on "Tools" from the list of links.

upload Test Case 1

Step 2 − Click on "More HP ALM Addins" Link from the addins page as shown below.

upload Test Case 2

Step 3 − In the Addins page, select "Addins for Microsoft applications" and choose "Microsoft Excel"

upload Test Case 3

Step 4 − Upon selecting "Microsoft Excel" and choosing ALM 11.5 Excel addin, the exe file will be downloaded. Please also take a note of the supported MS Office Editions as shown in the below screenshot.

upload Test Case 4

Step 5 − Once the Addin is installed, upon opening the Excel file, one can see "Export to ALM" button under Addins tab.

upload Test Case 5

Step 6 − Select the Records that one would like to upload into ALM and click on "Export to ALM Button". The HP ALM Export Wizard opens as shown below. Enter the Quality Center URL.

upload Tests 6

Step 7 − Enter the Quality Center credentials to successfully establish a connection.

upload tests 7

Step 8 − Select the Domain and Project as shown below and click "Next".

upload tests 8

Step 9 − Select the Type of data that the user wishes to upload. In this case it is "Tests".

upload tests 9

Step 10 − Enter a New map name. Upon creating once, we can reuse it any number of times for uploading tests.

upload tests 10

Step 11 − The Field Mapping Dialog opens. Here the user has to map the field in Quality Center against the column ID in Excel.

upload tests 11

Step 12 − Once the Field mapping is done, click Next.

upload tests 12

Step 13 : Hp ALM will start uploading the tests into Quality Center and shows the progress as shown below.

upload tests 9

Step 14 − If the upload is successful, the HP-ALM Export Wizard would show the message that it got successfully uploaded.

upload tests 10

Step 15 − Upon successful upload, the uploaded Test cases can be seen in HP-ALM directly.

upload tests 10
Kickstart Your Career

Get certified by completing the course

Get Started