Hp-QC - Upload Requirements


Every time the user will NOT be in a position to create requirements 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 requirements into QC from Excel.

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

upload Requirements 1

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

upload Requirements 2

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

upload Requirements 3

Step 4 − Upon selecting "Microsoft Excel", choose 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 following screenshot.

upload Requirements 4

Step 5 − Once the Addin is installed, you can open the Excel file and go to Addins tab to see the Export to ALM button.

upload Requirements 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 Requirements 6

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

upload Requirements 7

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

upload Requirements 8

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

upload Requirements 9

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

upload Requirements 10

Step 11 − Select the "Requirement Type" column that we are going to upload. This should match as that of the Excel that we wish to upload.

upload Requirements 11

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

upload Requirements 12

Step 13 − Select the HP ALM field and click the Arrow button. Map Field with Column Dialog opens. There, the column Name in Excel should be entered.

upload Requirements 13

Step 14 − Map all the relevant columns. The Column Name in Red are the mandatory fields. Now, click "Export".

upload Requirements 14

Step 15 − The Data would be uploaded and it displays the final output. If successful, it will upload completely and displays a message to the user with the "Finish" Button.

upload Requirements 15

Step 16 − Login to Quality Center and check if the requirements are uploaded correctly. The requirements will be uploaded as shown below.

upload Requirements 16