Forum Discussion

lc1987's avatar
lc1987
13 years ago

loop over Excel and Database

Hi,

I'm a newbie on SoapUI.
I created a SoapUi project in which I read data from a DB and from an Excel file; the excel file has the same columns of the DB's table.
I would compare the records stored in a column of my excel file with the ones of the same DB column to detect potential different values.
The procedure previously described goes through the following steps:

- Read Excel
- Read DB
- Groovy Script(where I compare every field of the Excel with the Db ones)
- Loop (Datasource: Excel file, TargetStep: DB)

The problem is that when I launch the program the loop cycle compares all the values stored in the Excel's column with only the first record of the same column stored in the DB. I'd like to know if someone can help me to figure out how to fix my problem!
Many many thanks to everybody!
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    13 years ago
    Hi!

    Since you're using soapUI Pro, you're entitled to support in the Pro forum (and via our support form) -- however, this in the General forum for all users. Please see the e-mail that you received with your license file.

    Thanks

    Henrik
    SmartBear Software
  • richa's avatar
    richa
    12 years ago
    I want to do the similar stuff in soap 4.0.1 but it throws error while doing property transfer from groovy where i am reading an excel and transferring property from there to stored procedure in oracle. Stored procedure doesnt recognize this as correct parameter and starts complaining about the error. Can someone please provide an insight on this.