Forum Discussion

jshu's avatar
jshu
Occasional Contributor
9 years ago

data export

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

5 Replies

Sort By
  • nmrao's avatar
    nmrao
    Champion Level 3
    9 years ago
    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's avatar
      jshu
      Occasional Contributor
      9 years ago

      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's avatar
    tvåljuaj
    New Contributor
    8 years ago

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

      • prashobkt's avatar
        prashobkt
        Contributor
        8 years ago

        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.