How to update execution result in QC-test lab using OTA

[JOHN MATHEW]

I have my test result updated in an excel sheet. I want to update QC test lab execution status based on excel sheet pass/fail result.

Help me to resolve this issue.

With Best Regards
John Mathew
Mobile : + 91 9447915392

[Ganesh muralidharan]

I think Reporter.ReportEvent can be used to send Failed or Passed
status to a QC Test run. If you want to pass detailed design steps
from QTP to QC, it can be done via OTA QCUtil. Please refer to the OTA
reference material.

> --
> You received this message because you are subscribed to the Google
> "QTP - HP Quick Test Professional - Automated Software Testing"
> group.
> To post to this group, send email to Mercu...@googlegroups.com
> To unsubscribe from this group, send email to
> MercuryQTP+...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/MercuryQTP?hl=en

--
Regards,

Ganesh Muralidharan
'God Never Forgets'

[JOHN MATHEW]

We tried the below code. we are able to get the test case design step values, but we are not able to do the updation to the status columns.

Could you please provide some suggestions..


TestId="131447"
   Set qtpapp = CreateObject("QuickTest.Application")
   Set tdconnection = CreateObject("TDApiOle80.TDConnection.1")
   Set testSetFolderF = qtpapp.tdconnection.TDOTA.TestSetTreeManager
   Set tstSetFolder = testSetFolderF.NodeByPath("Root\Trash")
   Set TestSetsList = tstSetFolder.TestSetFactory.NewList("")


For each Testset in TestSetsList   
       Set TestCollection = Testset.TSTestFactory.NewList("")      
       For each Test in TestCollection
       TestId = Test.TestID
       Set myTest = QCUtil.QCConnection.TestFactory.NewList("SELECT * FROM TEST WHERE TS_TEST_ID ="&TestId)
       Set StepsCollection = myTest(1).DesignStepFactory.NewList("")
       Print StepsCollection.Count
     'Print StepsCollection.Value
       For Each test2 In StepsCollection
           MsgBox test2.Field("DS_STEP_NAME")   

                      MsgBox test2.Field("DS_DESCRIPTION")  
                                          MsgBox test2.Field("DS_EXPECTED")
                  Next
        Next
Next

       Set StepsCollection = Nothing
       Set myTest = Nothing
       Set TestCollection = Nothing
       Set TestSetCollection = Nothing

With Best Regards
John Mathew
Mobile : + 91 9447915392

[Ganesh muralidharan]

dim objSfact
dim objOrun
dim mystep

Set objOrun = QCutil.CurrentRun

Set objSfact = objOrun.StepFactory
Set att = objSfact.AddItem(null)
att.name = aStepname
att.post

Set steplist = objSfact.NewList("SELECT * FROM Step WHERE
ST_STEP_NAME='" & aStepname & "'")
For each mystep in steplist
mystep.Status = aStatus
myStep.Field("ST_DESCRIPTION") = aDesc
myStep.Field("ST_EXPECTED") = aExpected
mystep.Field("ST_ACTUAL") = aActual

If mystep.Status = "Failed" then
objOrun.Status = "Failed"
end if

mystep.Post
Next

Set objSfact = Nothing
Set objOrun = Nothing

[JOHN MATHEW]

Thanks Ganesh.. This code is working for us..

With Best Regards
John Mathew
Mobile : + 91 9447915392

[NEERJA nawani]

Hi, 

   I want to execute all test cases available in specified testset in test lab. Using currentrun object I can update only current running test. Is there any method which I can use to execute all test cases? Please help me.

Thanks,

Neerja

---

Thanks and Regards

Neerja Nawani

+91 99210 82318

[Ganesh muralidharan]

Pls see if below solution works :

http://www.learnqtp.com/forums/Thread-How-to-Execute-a-testset-from-QC-using-OTA-framework 

[NEERJA nawani]

Hi,

  Thanks for the reply, but first I want to read the steps, description after that want to update the status.

Can i do it with runfactory?

Regards,

Neerja

[Ganesh muralidharan]

You can try that.

[NEERJA nawani]

Yes I am trying, can you pls tell me how to read steps?

[Chandan Kumar]

Hi,

I am also facing the same issue. Kindly do mail me or call me if the issue you got resolved.

Mail id- chandan...@gmail.com

Mob: 9971971122

Thanks,

Chandan

[gokul krishna]

neeraj 

why do you want to read the steps of the test before exeuction ?

Regards,

Gokul.

--

--
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to Mercu...@googlegroups.com
To unsubscribe from this group, send email to
MercuryQTP+...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en

---
You received this message because you are subscribed to the Google Groups "QTP - HP Quick Test Professional - Automated Software Testing" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mercuryqtp+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Thanks,
Gokul Krishna.