Forum Discussion

DCat1223's avatar
DCat1223
Frequent Contributor
9 years ago
Solved

Test Complete only reading first record of Excel data file.

Hi. I'm new to Test Complete and this forum.   I am testing a web based application that allows employees to sign up for Health Care and Dental. I am using Key Word tests, as I am not very experien...
  • dmiscannon's avatar
    dmiscannon
    9 years ago

    If I'm reading your tests correctly, you first run the login test then call the DCRA keyword test. Then the DCRA keyword test recalls the login test?? This, in essence, restarts the DDT.

     

    On the login test, all of the steps for the Data Driven loop should be indented to make them part of the loop. Currently, they are at the same level as the DD loop, so you really don't have a loop. Then for the DCRA test, remove the call to the login test. If all of the steps under the DD loop in the login test are indented to be part of the DD loop, when the DCRA test completes it will go back to the DD loop and use the next record for the DCRA test.

     

    Review the following to get an overview of Data Driven testing with TestComplete: https://support.smartbear.com/articles/testcomplete/data-driven-testing/?utm_source=site-search&utm_medium=search-results&utm_campaign=site-search-c&utm_term=data+driven+tests.

DCat1223's avatar
DCat1223
Frequent Contributor

It's set to Local.  Should it be set to Project?

dmiscannon's avatar
dmiscannon
Frequent Contributor
9 years ago

Either Project or ProjectSuite. Your choice. Personally, I use ProjectSuite.

  • DCat1223's avatar
    DCat1223
    Frequent Contributor
    9 years ago

    Thank you so much for the tip.  I was able to create the Project Level variable, but am still having the same issue.  I have a feeling the problem is with the data loop.  In the keyword test, it only seems to let me use a dataloop on a single test - or in other words, there doesn't seem to be a way to start the loop on one test and continue it on to another. 

     

    When I merge the two seperate tests on to one test, it works like a champ.  I really want to avoid this because: A) it will be a really long test and  B) it will be harder to maintain as the application changes over time. 

     

    This is really just a "prof of concept" set up for me trying to get my desired result.  It's pretty simple but once I figure out how to get this data loop thing working I can build out the actual test.  I only have about 40 hours of road time in on this program and have much to learn still. 

     

    I have included an attachment showing a few screenshots of what I have going on.  Maybe you'll see where I'm dropping the ball here. 

     

    Again, thank you so much for your time and assistance.

    • dmiscannon's avatar
      dmiscannon
      Frequent Contributor
      9 years ago

      If I'm reading your tests correctly, you first run the login test then call the DCRA keyword test. Then the DCRA keyword test recalls the login test?? This, in essence, restarts the DDT.

       

      On the login test, all of the steps for the Data Driven loop should be indented to make them part of the loop. Currently, they are at the same level as the DD loop, so you really don't have a loop. Then for the DCRA test, remove the call to the login test. If all of the steps under the DD loop in the login test are indented to be part of the DD loop, when the DCRA test completes it will go back to the DD loop and use the next record for the DCRA test.

       

      Review the following to get an overview of Data Driven testing with TestComplete: https://support.smartbear.com/articles/testcomplete/data-driven-testing/?utm_source=site-search&utm_medium=search-results&utm_campaign=site-search-c&utm_term=data+driven+tests.

      • DCat1223's avatar
        DCat1223
        Frequent Contributor
        9 years ago

        That did it!  Thank you.  I ended up moving the dataloop to the very beginning because I need the browser to close and restart.  Indenting everything after the loop was the difference maker.  Thank you again!