Import automated test cases from Excel

Import automated test cases from Excel - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Others (https://www.learnqtp.com/forums/Forum-UFT-QTP-Others)
+--- Thread: Import automated test cases from Excel (/Thread-Import-automated-test-cases-from-Excel)

Import automated test cases from Excel - VladVin - 09-09-2009

Hi,
I tried to import automated test cases (for QTP 9.5) from Excel to HP QC 9.2.
I can get test case with Test Type - QUICKTEST_TEST but
Test Script tab for new created TC is empty and when I open new created TC I have an error:
"Cann't display test.Make sure the test exist in the database."
I tried to create OTA API script but have a problem to find all methods
for QCUtil=>TreeManager=>TestFactory....=>AddItem
Script:

Code:
Set oTest = QCUtil.QCConnection

   Set oTestMgr = oTest.TreeManager

   Set oTsttr = oTestMgr.NodeByPath(pPath)

   Set oTstFact = oTsttr.TestFactory

   Set oTstCase = oTstFact.AddItem(pTestName)

   oTstCase.Field("TS_DESCRIPTION") = pDescr

   oTstCase.Type  = "QUICKTEST_TEST"

Any idea how I can populate automated Test Script in new created TC (By code or by setting import process. What method of AddItem generated test script for Test Script tab in ???
Best regards, Vladimir