InventoryLocato
13 years agoContributor
Making DataSink write to excel immediately
SOAP UI VERSION PRO: 4.0.1
Hello,
I am screen-scrapping data (xml data). I've setup my datasource, requests, property transfer, datasink, dataloop correctly (and in that order).
I've checked this that every works the way I want it to work with just a set of 10 items (if you want to know, i provide the zipcode and it gets back the weather conditions for saturday).
The data is written to my excel file and I'm happy.
Now I unleash the beast and let it go with 600,000 items (this case, zip codes). I check every now and then on the job and sees the excel file is still the same file size. When I copy and paste the excel file (the output file). It's still the same file.
I am suspecting that soapui writes to the excel file at the end of the testcase being completed. Is there a way for the datasink to be written after I made the request then loop? And yes, when I have task manager open, the soapui process is getting bigger (at least there's 4 gigs of ram). This job will be done in 10 hours so.. wish me luck. I am not using groovyscript, but if that's the way to do it, can someone supply me the groovyscript?
Thanks in advance.
Hello,
I am screen-scrapping data (xml data). I've setup my datasource, requests, property transfer, datasink, dataloop correctly (and in that order).
I've checked this that every works the way I want it to work with just a set of 10 items (if you want to know, i provide the zipcode and it gets back the weather conditions for saturday).
The data is written to my excel file and I'm happy.
Now I unleash the beast and let it go with 600,000 items (this case, zip codes). I check every now and then on the job and sees the excel file is still the same file size. When I copy and paste the excel file (the output file). It's still the same file.
I am suspecting that soapui writes to the excel file at the end of the testcase being completed. Is there a way for the datasink to be written after I made the request then loop? And yes, when I have task manager open, the soapui process is getting bigger (at least there's 4 gigs of ram). This job will be done in 10 hours so.. wish me luck. I am not using groovyscript, but if that's the way to do it, can someone supply me the groovyscript?
Thanks in advance.