Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

How do I output traffic response from data-driven test into an excel file?

kseniia
kseniia Posts: 13 ✭
in SOAtest

I have a test that is setup to use excel data source. There are 15 rows in the input datasource, so the tests is being executed 15 times, and I have 15 test results. Now I added "Response Traffic/Write File" tool to my test to save the response into %b.xls file. It does the job, but it appends all 15 responses into a single cell in my output xls file. I have "Append" option checked. I need each response to be in a separate cell. How do I do that?

Best Answer

  • benken_parasoft
    benken_parasoft Posts: 1,388 ✭✭✭
    Answer ✓

    For reporting, SOAtest generates reports in XML and HTML format. Traffic is included for failing test cases but you can optionally enable traffic for passing test cases as well. In the test configuration, look for "Report traffic for all tests".

Answers

  • benken_parasoft
    benken_parasoft Posts: 1,388 ✭✭✭

    The "Write File" tool writes directly to the file you specify. It writes whatever input it is given directly to the target file and that's it. There is no built-in tool that knows how to update or modify cells in an Excel spreadsheet. You could very well corrupt your XLS file by appending arbitrary bytes to the end of the raw file.

    Why are you trying to save traffic into the XLS file in the first place? Are you attempting to do this as a means of reporting or as an attempt to pass data between test cases? If you can elaborate then I may be able to suggest a better way to achieve your end goal.

  • kseniia
    kseniia Posts: 13 ✭

    our stakeholders would like to see the response alongside with input parameters in excel file. So I'd say it's for reporting mainly

Categories