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: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
