SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 7 of 7
  1. #1
    Junior Member
    Join Date
    Apr 2006
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Dashboard for QTP Automation Results

    Our team is looking into building our own web based dashboard to show our automation results. These are weekly runs and we would like our web based dashboard to have the results be automatically updated each week. We only have a license for QTP not the other tools that might have the capability to show execution results. Has anyone built their own custom dashboard to show results? Can you elaborate on the way to get this done?

    Thanks!
    -Cory

  2. #2
    Senior Member
    Join Date
    Dec 2004
    Location
    NY, USA
    Posts
    123
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Dashboard for QTP Automation Results

    Although we never attempted to develop any dashboard like that, but may be you would like to store/upload all the QTP results at a centralized location/server/machine everytime you run scripts on any machine. You may come-up with some automatic upload mechanism for this.
    And then develop a web-app to read the folders,subfolders and files in the QTP results folder on this centralized machine and display them in a tree-view on left side and the selected result file in the tree-view then appears in the right page.
    you may have to study the QTP results XML format and maybe develop your own xsl to display the results in some better format.

    otherwise QC is the best dashboard.

    -bharat

  3. #3
    Senior Member
    Join Date
    Jan 2006
    Location
    Stockholm, Sweden
    Posts
    371
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Dashboard for QTP Automation Results

    Hi,

    We have created a dashboard where we show QTP result in real-time.

    Our concept in brief:

    1. Use custom reporting functions to store result in xls-files using ADO and SQL during test execution.
    2. Use ADO and DOM to create web-based dashboard based on result from above (see attached example).

    You might consider using a real database like MS SQL Server instead of xls for better performance and ASP-pages to avoid client security issues.

    Regards
    Attached Images Attached Images

  4. #4
    Senior Member
    Join Date
    May 2006
    Location
    Israel
    Posts
    338
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Dashboard for QTP Automation Results

    The next version of ReporterManager will include a DB reporting engine.

    It should be released ~two weeks.

    http://www.sqaforums.com/showflat.ph...;Number=409680
    www.AdvancedQTP.com
    'coz we're programmers - not users

  5. #5
    Moderator
    Join Date
    Jul 2005
    Location
    Delhi
    Posts
    15,575
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    7 Thread(s)
    Total Downloaded
    0

    Re: Dashboard for QTP Automation Results

    Stefan, If possible can you share the code what wrote to do the same? Or may be some approach that you used

  6. #6
    Member
    Join Date
    Jun 2002
    Location
    North Oaks, MN, USA
    Posts
    36
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Dashboard for QTP Automation Results


    If you want to stay in the QTP 'comfort zone' look at the Quicktest Automation Model. With a little experimentation I was able to set up a little batch run utility. Looking back at the code I wrote I see that when I start a test from this script I have the ability to specify exactly where I want the test results stored. I imagine there is a property that gives you a test-level pass/fail. By storing the names of the tests that were run along with result in a file you have the foundation for gathering the data to feed to the web app.

  7. #7
    Senior Member
    Join Date
    Jan 2006
    Location
    Stockholm, Sweden
    Posts
    371
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Dashboard for QTP Automation Results

    Here are some examples below. I can post more examples/details later on if anybody is interested.

    My main concept is to store the final result for each test case in a separate result file (xls). I use SQL (insert/update) to do that. I also store result for each testarea and the entire test depending on the result from each test case. This is happening during test execution and the result is displayed on a web page (see attachment in previous post above). I use document.write() to generate table.

    Some issues regarding ADO/XLS though:

    1. Data type handling (data type for each column is determined based on the type used in upper rows).
    2. Handling multiple access are not 100%

    Function to generate table content (headings exluded)
    Function GetTestResult()
    'Data source fil
    strTestResultFile = "c:\myfile.xls"
    strTestResultSummarySheet = "Summary"
    strCustomer = "CustomerA"
    strSQL = "Select TestEnvironment, TestLevel, TestRunStatus, TestRunResult, TestRunVersion, TestRunStart, " &_
    "TestRunBy, TestArea1, TestArea2 from [" & strTestResultSummarySheet & "$] where Customer='" & strCustomer & "'"
    Set objCon = CreateObject("ADODB.Connection")
    Set objRec = CreateObject("ADODB.Recordset")
    objCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source=" & strTestResultFile &";" & _
    "Extended Properties=""Excel 8.0;HDR=Yes;"";"
    objRec.Open strSQL, objCon
    strTestEnvironment = objRec.fields("TestEnvironment")
    strTestLevel = objRec.fields("TestLevel")
    strTestRunStatus = objRec.fields("TestRunStatus")
    strTestRunResult = objRec.fields("TestRunResult")
    strTestRunVersion = objRec.fields("TestRunVersion")
    strTestRunStart = objRec.fields("TestRunStart")
    strTestRunBy = objRec.fields("TestRunBy")
    strTestArea1 = objRec.fields("TestArea1")
    strTestArea2 = objRec.fields("TestArea2")
    objRec.Close
    objCon.Close
    Set objCon = Nothing
    Set objRec = Nothing
    'Create Table
    strTestRunStatus = SetTestStatus(strTestRunStatus)
    strTestRunResult = SetTestStatus(strTestRunResult)
    strTestArea1 = SetTestStatus(strTestArea1)
    strTestArea2 = SetTestStatus(strTestArea2)
    strRow = strRow & "<TR><TD>" &_
    strCustomer & "</TD><TD>" &_
    strTestRunVersion & "</TD><TD>" &_
    Left(strTestRunStart,10) & "</TD><TD><CENTER>" &_
    strTestRunStatus & "</CENTER></TD><TD><CENTER>" &_
    strTestRunResult & "</CENTER></TD><TD><CENTER>" &_
    strTestLevel & "</CENTER></TD><TD><CENTER>" &_
    strTestEnvironment & "</CENTER></TD><TD><CENTER>" &_
    strTestArea1 & "</CENTER></TD><TD><CENTER>" &_
    strTestArea2 & "</CENTER></TD><TD><CENTER>" &_
    strTestRunBy & "</TD></CENTER></TR>"
    GetTestResult = strRow
    End Function

    Function to transform teststatus to image:
    Function SetTestStatus(strTestStatus)
    Select Case strTestStatus
    Case "No Run"
    SetTestStatus = strTestStatus
    Case "Passed"
    SetTestStatus = "<IMG SRC=""greenlight.png"">"
    Case "Complete"
    SetTestStatus = "<IMG SRC=""greenlight.png"">"
    Case "Failed"
    SetTestStatus = "<IMG SRC=""redlight.png"">"
    Case "Pending"
    SetTestStatus = "<IMG SRC=""yellowlight.png"">"
    Case "Warning"
    SetTestStatus = "<IMG SRC=""yellowlight.png"">"
    Case Else
    SetTestStatus = strTestStatus
    End Select
    End Function

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 9.09%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 07:54 AM.

Copyright BetaSoft Inc.