Forum Discussion

mohan1's avatar
mohan1
Occasional Contributor
10 years ago

Only Last Row From DataSource Is Being Read.

Hi!

 

I am using SOAPUI NG PRO, Am able to read data from excel sheet, but only last row is read into testcase. I have added DataLoop.

 

Please help. Thanks in advance.

 

Regards

Mohan

9 Replies

  • Please be sure that you have properties added to your DataSource for each column of data and that the format of your Excel spreadsheet is plain text, with the data separated by column.

     

    From the DataSource itself, press the green 'play' arrow at the top of the screen to ensure that your data is brought in from Excel as expected. Data should appear at the bottom of the screen.

    • mohan1's avatar
      mohan1
      Occasional Contributor

      Thanks for reply.

       

      When I play in the DataSource tab, I am able to retrive all the values. When running test case only last row is being read.

       

      Regards

      Mohan

      • Check the configuration of your DataSource Loop by double clicking the step. When the configuration window pops up, please ensure that the Target Step and Data Source Step are configured correctly for your project.

         

        Please also be sure that your test steps are in the correct sequential order. SoapUI Tests are executed in step order from top to bottom, so you will want to place your DataSource Loop test step after the step(s) where data is input.

    • mohan1's avatar
      mohan1
      Occasional Contributor

      Attached detailed screen shot.. Please help me.

       

      Regards

      Mohan