Service Virtualization

Expand all | Collapse all

Use of excel spread sheet in Virtual Services in DevTest 9.1 (portal is not available)

  • 1.  Use of excel spread sheet in Virtual Services in DevTest 9.1 (portal is not available)

    Posted Sep 27, 2016 08:28 AM

    We are using DevTest 9.1 Service Virtualization.  We have a need to use a spread sheet or other data file to fill in response values to which are not contained in the .vsi.  At this time the DevTest portal has not been made available to our development team.  This rules out the use of using a proper Data Driven Virtual Service for now.  We are looking for a short term solution until the data driven option is available. 



  • 2.  Re: Use of excel spread sheet in Virtual Services in DevTest 9.1 (portal is not available)
    Best Answer

    Posted Sep 27, 2016 08:36 AM

    In the workstation within the .vsm add a one time step before the http listener to load excel data, then look up a store the response as a variable, reference the variable on your response  before your response is returned.  This will achieve ddvs.  You can also do so in the Match Script section.  If ourse the portal is easier to achieve this but the alternative is to code it yourself vs the easy point and click from the pivotal ddvs 



  • 3.  Re: Use of excel spread sheet in Virtual Services in DevTest 9.1 (portal is not available)

    Posted Nov 10, 2016 08:26 PM

    Is the loading of excel data step a customized extension?