Linking Req & TC via OTA API
does anyone have a VB script that they may have created that can take test case names and link them to Req names based on am excel spreadsheet.
Sheet would be like
Thank you in advance for sharing.
Re: Linking Req & TC via OTA API
'you will need to list the requirement _id and the test_id in the data sheet
Public function QC_create_test_to_requirement_coverage2(requiremen t_id,test_id,byref TDC )
Set reqF = TDC.reqFactory
Set req = reqF.Item(requirement_id) ' <=====
Set coverable = req
coverable.AddTestToCoverage test_id ' <=======
Set coverable = Nothing
Set reqF = Nothing
Set req = Nothing
Set TDC = CreateObject("tdapiole80.tdconnection") 'TD 8.0 'Connect to the TD Server
TDC.InitConnectionEx "http://xxx/qcbin" ' Connect to the Project
TDC.ConnectProjectEx "xxx", "xxx","xxx", "xx"
rowcount = DataTable.GetSheet(dtGlobalSheet).GetRowCount
For i =1 to rowcount
rc=QC_create_test_to_requirement_coverage2(DataTab le("RQ_REQ_ID", dtGlobalSheet), DataTable("TS_TEST_ID", dtGlobalSheet),TDC)
Reporter.ReportEvent 0,"row " & i,"row " & i