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
    Dec 2010
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Executing the test cases bases on Excel inputs

    Hi,

    We are working in automation project we need to execute the test cases based on excel sheet yes or no criteria. If yes is mentioned qtp need to pick those test cases and need to execute those only
    Need detailed steps information for this requirement

    Regards,
    Rajkumar

  2. #2
    Super Member
    Join Date
    Dec 2005
    Location
    USA
    Posts
    1,407
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    Total Downloaded
    0

    Re: Executing the test cases bases on Excel inputs

    you are looking for a controller sheet.

    use the below field Testcase id,testcase name &execution field in sheet1 and use the testcase id in sub sequent sheets.

    build the logic in your driver script.
    ------------
    Chikki
    when things gets harder ,the harder gets going

  3. #3
    Super Member QAGanesh's Avatar
    Join Date
    Sep 2010
    Posts
    1,898
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Executing the test cases bases on Excel inputs

    yes,

    as chikki mentioned u need to have two sheets to implement the same.

    What framework are u working with..
    Thanks,
    Ganesh Iyer
    Winds of Change

  4. #4
    Advanced Member
    Join Date
    Aug 2006
    Location
    Other side of the Computer
    Posts
    598
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Executing the test cases bases on Excel inputs

    switch to Access database or some other database. so no need to check yes/no because you will be pulling only YES. also more flexible..
    ===========================================

  5. #5
    Super Member QAGanesh's Avatar
    Join Date
    Sep 2010
    Posts
    1,898
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Executing the test cases bases on Excel inputs

    Eagles,

    even in an excel we can implement the logic u have mentioned but access is much faster.
    Thanks,
    Ganesh Iyer
    Winds of Change

  6. #6
    Junior Member
    Join Date
    Dec 2010
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Executing the test cases bases on Excel inputs

    Hi,

    As you mentioned people I prepared excel sheet with the fields Testcase id, testcase name &execution field and filled the required information.

    We are using hybrid frame work but need to use excel sheet for the execution of test cases.

    As you mentioned that I need to build the logic in driver script

    Please mention the logic that I need to follow for building the driver script

    Please find the attached excels sheet also.

    Thanks,
    Rajkumar
    Attached Files Attached Files

  7. #7
    Super Member
    Join Date
    Dec 2005
    Location
    USA
    Posts
    1,407
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    Total Downloaded
    0

    Re: Executing the test cases bases on Excel inputs

    Raj,

    you want us to create a driver script for you.
    ------------
    Chikki
    when things gets harder ,the harder gets going

  8. #8
    Junior Member
    Join Date
    Dec 2010
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Executing the test cases bases on Excel inputs

    Hi,

    Not able to move further .. If you provide any help it will be appreciated lot for building the the driver script

    Thanks,
    Rajkumar

  9. #9
    Super Member QAGanesh's Avatar
    Join Date
    Sep 2010
    Posts
    1,898
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Executing the test cases bases on Excel inputs

    Raj,

    U can write a driver script that reads data from the execution excel sheet. Check for Yes or No and then execute the test case on the next sheet i.e. test case steps.
    Thanks,
    Ganesh Iyer
    Winds of Change

  10. #10
    Super Member QAGanesh's Avatar
    Join Date
    Sep 2010
    Posts
    1,898
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Executing the test cases bases on Excel inputs

    u can write a test/action for each workflow. Try to write actions for common workflows like login etc, which can be called from various tests/actions.
    Thanks,
    Ganesh Iyer
    Winds of Change

 

 

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 9.68%
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:26 AM.

Copyright BetaSoft Inc.