uploading test cases with the excel add in and linking the requirements
Question ID: 106530

I am using the Test Case Import Spreadsheet with the Excel Add in
Is there a way I can include the Requirement ID (which field) so that when I import it links the test case to the requirement?

Marked as spam
Posted by (Questions: 1, Answers: 0)
Asked on December 2, 2015 7:57 pm
Answers (1)
Private answer


The Excel Add-In uploads data specific to the fields of the selected entity (i.e. - The TEST fields) and does not cross entities.

The Test cases are linked to Requirements via the REQ_COVER database table. Therefore, there is not a specific Test field that determines Requirement linkage.

Unfortunately, this means you would not be able to add a specific column to your wotksheet and have the Excel Add-in utilize it for Requirement linkage.

An alternative approach may be to use the ALM/QC API inside of an Excel worksheet (think VBA and macros) to mimic the functionality of the Excel add-in while building additional functionality for Requirement linkage.

Marked as spam
Posted by (Questions: 3, Answers: 168)
Answered on December 3, 2015 3:56 am

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top