data export

[jshu]

Sorry to bother, I was following your web tutorial on data export (http://www.soapui.org/reporting/exporting-data.html) for "TestSuite TestCases" and found the generated CSV file was almost empty, it only showed the test case name. Below is an example xml I got from the web

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:web="http://www.webserviceX.NET">
   <soapenv:Header/>
   <soapenv:Body>
      <web:GetAtomicNumber>
         <web:ElementName>Carbon</web:ElementName>
      </web:GetAtomicNumber>
   </soapenv:Body>
</soapenv:Envelope>

I was expecting the generated CVS file would have at least "Carbon"

I then tried API Ready and I got the same result. To what extent can "data export" do to export test case data please?

We use xml files to do functional test in SoapUI Pro, we'd like to manage our xml test cases and decide to "export" them into CSV files and then use Oracle SQL*Loader to load into our database, so in the future we'd like to use data driven through Oracle JDBC connection for regression test, is there any practical way to convert our xml test cases into CSV file please?

Thank you very much

Jerry

[nmrao]

Looking at very first time, not sure I really got your question, so be patient.

Did you try to use this data export feature after running the tests?

[jshu]

Yes, I ran the whole test case and made sure each step had the correct response, but when I ran data export at test case level, all I got was each step's name

[tvåljuaj]

Why is this marked as solved while there are no solution?!

[nmrao]

No more a solution.

[prashobkt]

@tvåljuaj

If you are stuck in this problem follow below steps.

1) Store each result as you want in a custom property

2) write it in to a CSV file as you need using groovy

3) Reset all the values of custom property to null

note:- Above stated is a suggestion.