Databases
StackOverflow2013
Postsdbo
POPrinting variable value from CSV data file to JMeter console
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPrinting variable value from CSV data file to JMeter console
    primarykey
    data
    text
    <p>I am using JMeter to performance test an address validation service that finds valid addresses for an insurance quoting application. I am testing this from the back end using soap requests and I have a csv data config file with a large number of search strings.</p> <p>In order to get a true idea of the performance of this service, I need to test with a large number of addresses i.e. over 30000 so that the server caching doesn't affect my performance results. I have a list of addresses in a csv spreadsheet but some of them cause failures for whatever reason (e.g. the address no longer exists, I have verified this when just submitting one request with the address in question). I want to remove all addresses that fail from my csv file.<br> So I wanted to use JMeter to print the search address to the console if the request with this particular search address fails. I tried to use an IF controller with this as the condition <code>"${JMeterThread.last_sample_ok}" == "false"</code> and the following in the name section so that it prints the address to the JMeter console. The parameter <code>searchAddress</code> comes from my CSV input file. When I try and run this it just prints <code>${searchAddress}</code> to the console. So the if statement works but it doesn't recognise <code>searchAddress</code> as a variable. </p> <p>If I can get this to work I would copy all the search strings to excel and use a formula to remove them from my list of addresses to be used by my JMeter thread.</p> <p>Sorry for the lengthy question, but hope I have explained my issue clearly.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAliaksandr Belik
    1. USchucknor
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POPrinting variable value from CSV data file to JMeter console
      1. USShurupuS
      1. VTFavorite
    1. COTo try and state this simply. I need to print the value of a variable being read from a csv input file to the console if the value causes the soap request to fail.
      singulars
      1. POPrinting variable value from CSV data file to JMeter console
      1. USchucknor
    2. COLooks like you've incorrectly set up your CSV Data Set Config. What's in jmeter.log / Options > Log Viewer? Are the values correctly extracted from csv-file? Can you get the extracted values from ${searchAddress} via e.g. [Debug Sampler](http://jmeter.apache.org/usermanual/component_reference.html#Debug_Sampler)? Is csv-file accessible for CSV Data Set Config (is the path to the file set correctly)?
      singulars
      1. POPrinting variable value from CSV data file to JMeter console
      1. USAliaksandr Belik
    3. COHi Alies. Thanks for that. Yep the values are available using a Debug sampler. I just added a Debug sampler under my IF controller with this in the name section 'vp - ${__time(HH:mm:ss)} ${__time(HH:mm:ss)} ${__logn(${searchAddress},OUT)}${__logn(${searchAddress},INFO)}'. Question answered. Thanks a lot.
      singulars
      1. POPrinting variable value from CSV data file to JMeter console
      1. USchucknor
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload