SPONSORS:






User Tag List

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

    Data Generator Tool

    User mw_yohaa (martin_wright@hotmail.com.nospam) posted:


    Is there an application available that can auto generate large sets
    of parameterised data?

    For example, if I want to create data with the following parameters:
    Eye Colour - Blue, Brown, Green
    Age - 16-85
    Sex - Male, Female

    I would like to create 200 records with random data using the above
    parameters into an Excel spreadsheet so that I can then extract the
    data for a Data Driven test.

    I am sure that an application of this sort was available from Mercury
    with WinRunner version 5?

    Thanks



  2. #2
    SQA Council
    Join Date
    Mar 2001
    Posts
    8,591
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Data Generator Tool

    User Shivaprakash GK (GK.Shivaprakash@blr.spcnl.co.in.nospam) posted:

    ------_=_NextPart_001_01C1EC3C.71C2CFB0
    Content-Type: text/plain;
    charset="iso-8859-1"

    use rand() and srand(x) functions available in winrunner, this might help
    you..
    like rand()& "Blue";

    Rgds,
    Shiva


  3. #3
    Moderator Joe Strazzere's Avatar
    Join Date
    May 2000
    Location
    USA
    Posts
    13,170
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    Total Downloaded
    0

    Re: Data Generator Tool

    <BLOCKQUOTE><font size="1" face="Verdana, Arial, Helvetica">quote:</font><HR>Originally posted by martin_wright:
    User mw_yohaa (martin_wright@hotmail.com.nospam) posted:


    Is there an application available that can auto generate large sets
    of parameterised data?

    For example, if I want to create data with the following parameters:
    Eye Colour - Blue, Brown, Green
    Age - 16-85
    Sex - Male, Female

    I would like to create 200 records with random data using the above
    parameters into an Excel spreadsheet so that I can then extract the
    data for a Data Driven test.

    I am sure that an application of this sort was available from Mercury
    with WinRunner version 5?

    Thanks

    <HR></BLOCKQUOTE>

    If you only want to create 200 records, I'm guessing you are better off just using Excel itself to create the records - either manually or using the Excel Rand() and RandBetween() functions.

    Certainly WinRunner can create the data using Rand() as well.

    ------------------
    - Joe (strazzerj@aol.com)
    Joe Strazzere
    Visit my website: AllThingsQuality.com to learn more about quality, testing, and QA!

  4. #4
    SQA Council
    Join Date
    Mar 2001
    Posts
    8,591
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Data Generator Tool

    User Stephanie (ssylve1445@mindspring.com.nospam) posted:

    not available anymore.

    Stephanie
    Initiatives

    Is there an application available that can auto generate large sets

    of parameterised data?

    For example, if I want to create data with the following parameters:

    Eye Colour - Blue, Brown, Green

    Age - 16-85

    Sex - Male, Female

    I would like to create 200 records with random data using the above

    parameters into an Excel spreadsheet so that I can then extract the

    data for a Data Driven test.

    I am sure that an application of this sort was available from Mercury

    with WinRunner version 5?
    IMPORTANT EMAIL ADDRESSES:

    Post message: winrunner@yahoogroups.com

    Subscribe: winrunner-subscribe@yahoogroups.com

    Unsubscribe: winrunner-unsubscribe@yahoogroups.com

    ***To unsubscribe via email: From your email program, send a blank message to winrunner-unsubscribe@yahoogroups.com.

    *To reply to the entire list, use the Reply button in your email program

    *To respond offline to an individual, locate the sender's email address in the email message

    *To view archives go to groups.yahoo.com

    Direct any questions, comments, or issues about this list to...

    Eric Marx
    < !-- |**|begin egp html banner|**| -->


  5. #5
    SQA Council
    Join Date
    Mar 2001
    Posts
    8,591
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Data Generator Tool

    User Decker, Jay (Jay.Decker@nordstrom.com.nospam) posted:

    ------_=_NextPart_001_01C1EC97.DA64A153
    Content-Type: text/plain

    Try http://www.satisfice.com/tools/pairs.zip <http://www.satisfice.com/tools/pairs.zip> . It may work for you. I have no connection with the company, just like a lot of what James Bach has to say.


  6. #6
    SQA Council
    Join Date
    Mar 2001
    Posts
    8,591
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Data Generator Tool

    User WinRunner (ssylve1445@mindspring.com.nospam) posted:

    not available anymore.

    Stephanie
    Initiatives

    Is there an application available that can auto generate large sets

    of parameterised data?

    For example, if I want to create data with the following parameters:

    Eye Colour - Blue, Brown, Green

    Age - 16-85

    Sex - Male, Female

    I would like to create 200 records with random data using the above

    parameters into an Excel spreadsheet so that I can then extract the

    data for a Data Driven test.

    I am sure that an application of this sort was available from Mercury

    with WinRunner version 5?
    IMPORTANT EMAIL ADDRESSES:

    Post message: winrunner@yahoogroups.com

    Subscribe: winrunner-subscribe@yahoogroups.com

    Unsubscribe: winrunner-unsubscribe@yahoogroups.com

    ***To unsubscribe via email: From your email program, send a blank message to winrunner-unsubscribe@yahoogroups.com.

    *To reply to the entire list, use the Reply button in your email program

    *To respond offline to an individual, locate the sender's email address in the email message

    *To view archives go to groups.yahoo.com

    Direct any questions, comments, or issues about this list to...

    Eric Marx
    < !-- |**|begin egp html banner|**| -->


  7. #7
    Junior Member
    Join Date
    Aug 2000
    Location
    Burlington, NJ, USA
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Data Generator Tool

    User Al Goerig (agoerig@coat.com.nospam) posted:

    Why not just a write a test to do this?

    Al Goerig
    Burlington Coat Factory http://www.coat.com


  8. #8
    SQA Council
    Join Date
    Mar 2001
    Posts
    8,591
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Data Generator Tool

    User (tyale@transcentive.com.nospam) posted:

    ------_=_NextPart_001_01C1EC9A.0679F860
    Content-Type: text/plain

    not available anymore. Stephanie Initiatives
    On Thu, 25 Apr 2002 09:25:07 -0000 mw_yohaa wrote:
    You can check out 'DataFactory' from Quest. We just purchased it to help
    load our databases with data.



    <http://www.quest.com/> http://www.quest.com/datafactory/



    You can load an access database and then insert the data into Excel.



    Tom



    Tom Yale

    Transcentive




  9. #9
    Member
    Join Date
    Jan 2001
    Location
    sacramento California
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Data Generator Tool

    Try datatect "the test data generation tool"

    wwww.datatect.com

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

  10. #10
    Senior Member
    Join Date
    Jul 2001
    Posts
    216
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Data Generator Tool

    User mm_ke (mm_ke@yahoo.com.nospam) posted:

    If you don't care about distribution of data set, or coverage of
    combinations, you could put a formula in the spreadsheet column
    something like:

    =INDEX({"Blue","Brown","Green"},1+3*RAND())

    copy this for as many rows as you like, and the other columns can
    have something similar for your other data.

    Alternatively put the values on a sheet and reference them instead
    of hard coding an array, eg. =INDEX($A$1:$A$3,1+3*RAND())

    kind regards,
    Misha

    --- In winrunner@y..., "mw_yohaa" <martin_wright@h...> wrote:
    Mercury



 

 

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.00%
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 04:35 AM.

Copyright BetaSoft Inc.