Submit and vote on feature ideas.

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.

CSV Message Responder issue

*Using Parasoft Virtualize 9.10.4**
Unable to extract column data from a CSV file if the incoming request CSV data has multiple word column headings (e.g. "System Name"). The problem is in the "Using Data Source Wizard".

The Parasoft tool is converting column headings with multiple words (e.g. "System Name") to "SystemName" ie. its removing the space between words resulting in an xpath match failure when attempting to extract data.

Are there any workarounds or specific configuration settings which can help modify this behaviour?

Comments

  • keegan_chan
    keegan_chan Posts: 59 ✭✭

    Is it possible for you to attach your .pva file? I don't quite understand how the CSV message responder is reading the incoming request CSV data as well as extracting column data from a CSV file. Thanks.

  • benken_parasoft
    benken_parasoft Posts: 1,228 ✭✭✭
    edited October 2018

    I don't quite understand how the CSV message responder is reading the incoming request CSV data as well as extracting column data from a CSV file

    The "Using Data Source Wizard" simplifies the process of creating an extraction and parameterizing a field. It saves you the time of otherwise having to manually setup a Data Bank and XPath for the extraction and then manually parameterizing a field in another tool against the column for the extraction. This works with XML, JSON, and other message formats including CSV.

    its removing the space between words resulting in an xpath match failure when attempting to extract data

    Probably someone needs to verify whether this is a product issue or something specific to your responder setup. Worse case, it sounds like you can simply open the Data Bank and correct the XPath after the fact.