Forum Discussion

makn78's avatar
makn78
13 years ago

Usign DataSource to create test steps

Could someone please help me, I have a very large excel file that contains around 2000 postal addresses. We have an AV engine that need to be tested by running all them addresses. Now if I start to create a test step for each address it'll take me ages. I was hoping I can use the addresses in the excel file (they are all in one column on one sheet) to formulate test steps and also it'll be great if somehow I could also define assertions for each test step (maybe if I add another column containing the expected results).

I tried following the user guide and the webpage on Soap UI website that talks about how to use datasource. But that is a very bad guide, doesn't explain much, I'm not a very technical person, so need instructions in more layman terms. PLEASE HELP!!!

We have a WSDL defined that I have used for test previously, if that helps.

Thank you.

1 Reply

  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    13 years ago
    Have you watched the video and went fully through the article: http://www.soapui.org/Data-Driven-Testi ... tests.html ?

    You can see that you:
    - first configure a DataSource step to your Excel file
    - setup 1 request and point to DataSource properties by right-clicking in the request
    - add and configure a "DataSource Loop" step

    If you have particular sections of the guide that you think can be improved, let me know. I can certainly expand on anything in the article and change that page if need be.

    Thanks,
    Michael Giller
    SmartBear Software