soapUI Pro to read from an excel spreadsheet
hI, I was wondering if any of you guys had used the data source test step in SOAPUI Pro to read from an excel spreadheet whilst Load Testing Using LOADUI.
At the moment I have it all set up but for some reason there are a few problems.
1. When reading in data from the excel spreadheet, the load test seems unable to progress through the rows of the data sheet, causing everything but the 1st request to fail. (I need to submit different data per request). This is despite having the setting to share the data set with running theads. I've tried the same test but using a grid of a few values that I entered, and this works fine, it just seems to have a problem with reading the data from a spreadsheet.
2. I don't appear to be able to output the actual response from the request on any of the table logs. All I can get hold of are the failures. Hence I can't prove anything has actually passed a test.
Any help with this would be appreciated.
From Andrew
At the moment I have it all set up but for some reason there are a few problems.
1. When reading in data from the excel spreadheet, the load test seems unable to progress through the rows of the data sheet, causing everything but the 1st request to fail. (I need to submit different data per request). This is despite having the setting to share the data set with running theads. I've tried the same test but using a grid of a few values that I entered, and this works fine, it just seems to have a problem with reading the data from a spreadsheet.
2. I don't appear to be able to output the actual response from the request on any of the table logs. All I can get hold of are the failures. Hence I can't prove anything has actually passed a test.
Any help with this would be appreciated.
From Andrew
