SPONSORS:






User Tag List

Results 1 to 10 of 10
  1. #1
    Junior Member
    Join Date
    Feb 2002
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Reports to Excel

    Is there a way to export the reports to Excel?
    If not, has anyone written a third party convertor to do the same?

    Thanks in advance.

    ------------------

  2. #2
    Senior Member
    Join Date
    Feb 2000
    Posts
    1,497
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Reports to Excel

    <BLOCKQUOTE><font size="1" face="Verdana, Arial, Helvetica">quote:</font><HR>Originally posted by qafbud:
    Is there a way to export the reports to Excel?
    <HR></BLOCKQUOTE>
    Silk supports CSV export which Excel can readily import. How you tried that? Add a custom macro to Excel and you should be able to churn the text any way you want.


    John


    ------------------

  3. #3
    Junior Member
    Join Date
    Feb 2002
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Reports to Excel

    Thanks very much. It works!

    ------------------

  4. #4
    Senior Member
    Join Date
    Nov 2001
    Posts
    375
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Reports to Excel

    Silktest also has a feature called Silktest Repository. You could try out that too...from what i remember it had a pretty good web interface which will surely impress ur peers

    Cheers!
    Aatish

    ------------------

  5. #5
    Junior Member
    Join Date
    Feb 2002
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Reports to Excel

    Results repositary is an excellent results management tool. The web interface is cool.
    Thanks for letting me know.
    Unfortunately the results as given aren't manager friendly because data needs to be tweaked. It is 'Build 1' everywhere and I need to update that with MY build number.
    To do that I think I need SQL Server (don't have this) to tweak the schema, etc.
    Well, I will keep this in mind for future use.

    Thanks
    Bud

    ------------------


    [This message has been edited by qafbud (edited 04-04-2003).]

    [This message has been edited by qafbud (edited 04-04-2003).]

  6. #6
    Senior Member
    Join Date
    Nov 1999
    Location
    Eagle, ID,USA
    Posts
    1,035
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Reports to Excel

    The build number is defined as a constant in SilkTestRepository.inc. The best way is to make this a global variable that can be set by the user in a .ini file. You can then read that value in ScriptEnter() defined in LogResults.inc.

    ------------------
    Have you ever noticed? Anybody going slower than you is an idiot, and anyone going faster than you is a maniac.

  7. #7
    Junior Member
    Join Date
    Feb 2002
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Reports to Excel

    That works!
    One more question and I am all set.
    How do I get rid of old Build results?

    I appreciate all the help here.

    ------------------

  8. #8
    Member
    Join Date
    Sep 2001
    Posts
    69
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Reports to Excel

    To get rid of old results just look at the run_id column in the runs and test tables and delete the desired run_id. I dont have SQL Server but Access works. Oh I think you have to get rid of the primary key setting on one of those tables. I customized the database a bit to handle this.

    As for build numbers I get it straight from the app. We have the build number displayed in a small font on the main login page. If your application has a place where you can get build info then try automating getting the build info and put it in ScriptEnter() as the post above mentioned.




    ------------------

  9. #9
    Senior Member
    Join Date
    Nov 1999
    Location
    Eagle, ID,USA
    Posts
    1,035
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Reports to Excel

    If you just want to clear the database now and start over, there is a SilkTestRepository.t file that has some tests already defined to do that. Otherwise, you'll have to delete from the BuildID, Runs, and Tests tables using DB functions supplied with SilkTest. You will have to key off of the RunID to delete what is in the Tests table for that particular build.

    ------------------
    Have you ever noticed? Anybody going slower than you is an idiot, and anyone going faster than you is a maniac.

  10. #10
    Junior Member
    Join Date
    Feb 2002
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Reports to Excel

    The testcases in SilkTestRepository.t helped me clear out the old results.

    Thanks everyone!

    ------------------

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin 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 03:46 AM.

Copyright BetaSoft Inc.