Exporting data from jMeter

["Sosnowski, Andrew P [IT]" <an...@citigroup.com>]

Has anyone got a way to export the data for example in the Aggregate Report.
I would like to be able to create a CSV (i.e. comma separated text) file
with this kind of information.

Thanks in advance
Andy Sosnowski

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: Exporting data from jMeter

[Dies Koper <di...@hst.fujitsu.com>]

Hi Andrew,

> Has anyone got a way to export the data for example in the Aggregate Report.
> I would like to be able to create a CSV (i.e. comma separated text) file
> with this kind of information.

I posted a message last week with my problem how to get the data into
Excel to get similar graphs as JMeter shows. My problem was the order of
the data, so I wrote a little program to fix it.
Its output is a space separated file. You can easily change it to make
it output comma separated files like you want them.
Of course it would be great if JMeter could support the different
formats.

Regards,
Dies


/**
 * @(#)JMeterResultsToMatrix.java
 *
 * 	Explanation: converts JMeter's results file to space delimited ASCII
record file
 *
 */


import java.util.*;
import java.lang.String;
import java.io.IOException;
import java.io.FileWriter;

import javax.xml.parsers.*;
import org.xml.sax.*;
import org.xml.sax.helpers.*;


public class JMeterResultsToMatrix extends DefaultHandler {
	public String columnNames = "";
	public String time = "";
	public int maxColumns = 0;
	public int columnNo = 0;
	public FileWriter fileWriter = null;

	public void startElement(String uri, String localName, String qName,
Attributes attributes) {
		String category;

		if (qName.equals("sampleResult")) {
			if (maxColumns == 0) {
				category = attributes.getValue("label");

				if (columnNames.startsWith(category + " ")) {
					maxColumns = columnNo;

					// save line to file
					try {
						fileWriter.write(columnNames + "\n");
					} catch (IOException e) {
						System.out.println("Error writing category names to file");
					}
				} else {
					columnNames += category + " ";
				}
			}
			if (maxColumns != 0 && columnNo == maxColumns) {
				// save line to file
				try {
					fileWriter.write(time + "\n");
				} catch (IOException e) {
					System.out.println("Error writing data to file");
				}
				columnNo = 0;
				time = "";
			}
			columnNo++;
			time += attributes.getValue("time") + " ";
		}
	}

	public void endElement(String uri, String localName, String qName) {
	}

	public static void main(String args[]) throws Exception	{
		if (args.length != 1) {
			System.err.println("Supply infile as argument");
			return;
		}

		JMeterResultsToMatrix handler = new JMeterResultsToMatrix();
		SAXParserFactory factory = SAXParserFactory.newInstance();
		SAXParser saxParser = factory.newSAXParser();

		String outFilename = args[0].substring(0, args[0].lastIndexOf(".") +
1) + "txt";
		handler.fileWriter = new FileWriter(outFilename);

		saxParser.parse(args[0], handler);

		try {
			handler.fileWriter.write(handler.time + "\n");
		} catch (IOException e) {
			System.out.println("Error writing data to file");
		}
		handler.fileWriter.close();
		System.out.println("Finished parsing " + args[0] + ". Converted into "
+ outFilename);
	}

}

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>