SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 4 of 4
  1. #1
    Senior Member
    Join Date
    May 2010
    Location
    TN , IND
    Posts
    157
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Active Data Wizard - Read from Excel ( Rows Prob)

    Using Active Data i am reading values from excel .But i noticed some problem , i want to if its a product feature .

    Initially i read values from 10 rows of data , Tp went through 10 iterations .Then i modified it as 2 rows ,but i find that Tp takes values for 2 rows but , but goes for extra 8 iterations without any value .

    Can we avoid this ?

  2. #2
    Senior Member
    Join Date
    Jul 2001
    Location
    USA
    Posts
    104
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Active Data Wizard - Read from Excel ( Rows Prob)

    In your LoadActiveData command, after you specify the active data asset to load, you can specify which row to start on and which row to end on. The following statement will load rows 1-10 of my active data:
    Set adDataList = LoadActiveData("RandomDOBs",1,10)
    There's also a parameter called RandomCount which will load the data in a random order and a ReadOnly parameter. For more details, search the help.
    TP 6.3
    AUT: Web app - Java/SQL
    Using TestPartner since 2008
    Using QTP since 2002

  3. #3
    Senior Member
    Join Date
    Jan 2008
    Location
    North Carolina
    Posts
    131
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Active Data Wizard - Read from Excel ( Rows Prob)

    You can add a column to your excel sheet to flag wheather to use the row or not. If the Use column value is 'Yes' use the row, if not do not use the data and/or exit the active data loop. don
    don, CSTP, QAD/TP user since 06
    Test Partner 6.3; QAD 6.1; QADLoad 5.9

  4. #4
    Member
    Join Date
    May 2010
    Posts
    43
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Active Data Wizard - Read from Excel ( Rows Prob)

    Very thanks ya....

 

 

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 09:42 AM.

Copyright BetaSoft Inc.