Santana
Santana

Reputation: 399

how to generate Jmeter CSV report just with defined regular expression variables

Is it possible to get a CSV file report in JMeter just with only defined regular expression variables values from all the samplers? Because I have defined sample_variables in JMeter user.properties file. Thanks.

Upvotes: 0

Views: 277

Answers (1)

Dmitri T
Dmitri T

Reputation: 168092

  1. The easiest way is using Flexible File Writer
  2. A little bit harder - suppress all JMeter default result saving configuration via user.properties file like:

    jmeter.save.saveservice.output_format=csv
    jmeter.save.saveservice.assertion_results_failure_message=false
    jmeter.save.saveservice.assertion_results=none
    jmeter.save.saveservice.data_type=false
    jmeter.save.saveservice.label=false
    jmeter.save.saveservice.response_code=false
    jmeter.save.saveservice.response_data=false
    jmeter.save.saveservice.response_data.on_error=false
    jmeter.save.saveservice.response_message=false
    jmeter.save.saveservice.successful=false
    jmeter.save.saveservice.thread_name=false
    jmeter.save.saveservice.time=false
    jmeter.save.saveservice.subresults=false
    jmeter.save.saveservice.assertions=false
    jmeter.save.saveservice.latency=false
    jmeter.save.saveservice.connect_time=false
    jmeter.save.saveservice.samplerData=false
    jmeter.save.saveservice.responseHeaders=false
    jmeter.save.saveservice.requestHeaders=false
    jmeter.save.saveservice.encoding=false
    jmeter.save.saveservice.bytes=false
    jmeter.save.saveservice.url=false
    jmeter.save.saveservice.filename=false
    jmeter.save.saveservice.hostname=false
    jmeter.save.saveservice.thread_counts=false
    jmeter.save.saveservice.sample_count=false
    jmeter.save.saveservice.idle_time=false
    jmeter.save.saveservice.print_field_names=false
    
  3. Hardest: add i.e. Beanshell Listener to write variable value to a separate file. Example code is something like:

    import org.apache.commons.io.FileUtils;
    
    FileUtils.writeStringToFile(new File("target_file.csv",vars.get("your_variable_name")));
    

    See How to Use BeanShell: JMeter's Favorite Built-in Component guide for more information regarding bypassing JMeter limitations using scripting

Upvotes: 2

Related Questions