SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 3 of 3
  1. #1
    Junior Member
    Join Date
    Sep 2001
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Export results to files

    Hi,
    how can one extract the automation results in an excel or access?Is it possible to add counters and keep on updating all the result file which would mean having the record of all the runs in one files,that too not manually.Can we automate using Winrunnr like this.If yes,Can someone throw some information in this regard?

    Regards,
    Shalini Nahata

  2. #2
    Senior Member
    Join Date
    May 2001
    Location
    Ankh-Morpork
    Posts
    2,882
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Export results to files

    You could use the ddt_ functions for Excel or db_ functions for Access to write results. You would have to put the logic into your code to do so. (Hint: create a user-defined function that does this so all you have to do is call it from your script with the test ID, test step, results and perhaps a comment.)
    web site | [url=http://www.ebookworm.us/[/url]

    [i]...Sound trumpets! Every trumpet in the host! / Sixty thousand, on these words, sound, so high the mountains sound, and the valleys resound.</i] (The Song of Roland)

  3. #3
    Member
    Join Date
    Jul 2002
    Location
    Sheffield, Yorkshire England
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Export results to files

    something like the following would work
    # -----------------------------------------------
    # DESCRIPTION: connect to the db and
    # runs some sql
    #
    # PARAMETERS: in DSN, in query
    #
    # RETURN CODE: return E_OK
    #
    #------------------------------------------------
    public function Access_RunSql( in DSN, in query )
    {
    auto record_cnt;

    db_connect("TESTS TO RUN","DSN="& DSN);
    db_execute_query("TESTS TO RUN",
    query ,record_cnt);
    db_disconnect("TESTS TO RUN");

    return E_OK;

    }# Access_RunSql()
    # -----------------------------------------------
    # DESCRIPTION: Records the results in
    # access
    #
    # PARAMETERS: in result, in test_name,
    # in result_desc
    #
    # RETURN CODE: return E)OK
    #
    #------------------------------------------------
    function test_results( in result, in test_name, in result_desc )
    {
    auto insert;

    insert = "insert into [Test Results]
    VALUES ('" & result & "', '" & test_name
    & "', '" result_desc "')";
    sg_access_RunSql("SESSION", insert);

    return E_OK;

    }# test_results()

 

 

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 10.71%
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 12:09 AM.

Copyright BetaSoft Inc.