Forum Discussion

rrubio's avatar
rrubio
Contributor
13 years ago

Is there a way of doing by code the manual 'Export to' at Project level?



Hi all,



I have seen some posts regarding this issue.

Anyway, in my case, automated testing is integrated in a daily build project. At the end of testing, it has to send a mail with the final result: OK, NOT OK and export testing results to a .mhtml file.



As this execution test is formed by several test items, with Log.SaveResultAs functions we only have the results for current item (at this point I could export it to a file)  (and so on with each test item).



However, this will generate as many export files as test items.



From TestComplete I can open the testlog and export all items execution files in a single .mhtml file



Is it possible to redo this by code? Or is it possible to load any single log file result, "pack them" in a single composed log and then export it?





Thanks for everything.



Raul

14 Replies

Sort By
  • svaze74_1's avatar
    svaze74_1
    Contributor
    13 years ago
    Hi Raul,



    Its an interesting question. Even i would like to know the possible solutions to the questions. Meanwhile I am trying to find solution to it as well.



    Thanks,

    Shrirang
  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    13 years ago
    I'm not sure why you're only getting the current test item in your export.  I have a test project that I run with multiple test items, the last of which is simply a Log.SaveResultsAs and it exports the entire log file up to that point.  That file can then be e-mailed, archived, etc.


  • yabing_yang's avatar
    yabing_yang
    Occasional Contributor
    13 years ago
    Hi Robert,



    I have a same question as Raul. I also cannot auto export project level log.

    How do you do that, can you explain.

    I write keyword tests, how should I put Log.SaveResultsAs?

    Right now I put this line in a keyword test which contains only Log.SaveResultsAs and then put it on the last test item for group run, is that right?



    Thanks,

    Yabing
  • yabing_yang's avatar
    yabing_yang
    Occasional Contributor
    13 years ago
    Hi Robert,



    My TestComplete Version: 8.20.538.7 Standard



    Yabing
  • yabing_yang's avatar
    yabing_yang
    Occasional Contributor
    13 years ago
    Hi Robert,



    I attached an attachment which is generated from Log.SaveResultsAs.



    I wrote a script as:

    function TestResults(path, name, fileFormat)

      FileName = path & name

      Call Log.SaveResultsAs (FileName, fileFormat)

    End function



    then run this script by using 'Run Script Routine' in a keyword test. In this keyword test, only includes this line.



    and then I put this keyword test on the last test item in 'Test Items' page.



    Thanks,

    Yabing
  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    13 years ago
    Okay, perhaps I'm not understanding your problem because when I add that log back into TestComplete, I see it from a Project Suite level and I can drill down to individual Test Items and their specific logs



    Can you describe your problem?  Is it that you want this compressed to a single file or is there something else going on here that I'm not seeing?
  • yabing_yang's avatar
    yabing_yang
    Occasional Contributor
    13 years ago
    Hi Robert,



    It works fine for exporting HTML and MHTML formated file. But for me, I want to export a XML formatted file.

    I attached file by using:



    Sub TestResults()

      Call Log.SaveResultsAs("C:\Users\ybyang\Desktop\AutoExportTestResult\MyFinalResult.xml", lsXML)

    End Sub



    Thanks,

    Yabing
  • AlexeyK's avatar
    AlexeyK
    SmartBear Alumni (Retired)
    13 years ago

    Yabing,


    When exporting results in XML format, you get multiple files, not one file (multiple {GUID} files). Is that what confuses you?


    Each file corresponds to the test log of some test item. The MyFinalResult.xml file contains summary information for the run. It also stores a link to the RootLogData.dat file that corresponds to the topmost log node: 




    MyFinalResult.xml


    ...

    <Nodes version="1">

     <Node name="root">

        ...  

        <Prp name="root file name" type="S" value="RootLogData.dat"/>

        ...

     </Node>

    </Nodes>


    The RootLogData.dat file stores links to the results of top-level test items:




    RootLogData.dat


    <Nodes version="1">

      <Node name="root">

        <Node name="item 442">

          <Node name="children"/>

            ...

            <Prp name="filename" type="S" value="{BA65219D-7BAD-48ED-9CBF-808318A6242E}"/>

            ...

          </Node>

        <Node name="item 404">

          <Node name="children">

            ...

            <Prp name="filename" type="S" value="{F6769F16-93B0-435B-9C26-BB0E0186F8A2}"/>

            ...

          </Node>

    ...


    The {GUID} files that correspond to these test items store links to the results of the test items that reside on deeper levels. These file names are also {GUIDs}.


    The XML format of results is used in cases when you need to process results somehow at later time. If you need visual presentation, export in MHT or HTML formats.

  • yabing_yang's avatar
    yabing_yang
    Occasional Contributor
    13 years ago
    Hi Alex,



    Thank you for your explanation, very helpful.

    I still have a question. Why in the xml file, it does not inlcude
    information about how many tests run, how many pass, how many failed.

    I want to have a xml file which includes number of total tests, executed tests,
    passed and failed tests, which test passed, which test failed.



    Thank you,

    Yabing