Thursday, September 17, 2015

How to view the .jtl file from excel



Want to open the .jtl file  in the MS excel.  We need to do:


  •     Open the .jtl file from a wordpad or notepad 






  •    Insert the following line:

<?xml-stylesheet type="text/xsl" href="C:\apps\apache-jmeter-2.12\extras\jmeter-results-report_21.xsl"?>

This line is giving the location of  the style sheet file, it is located in the installed JMeter  extras folder. And it should be put in here:

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="C:\apps\apache-jmeter-2.12\extras\jmeter-results-report_21.xsl"?>
<testResults version="1.2">







  • Save the .jtl file after insert xml line 
  • Open the MS Excel worksheet, and drag and drop this .jtl file into it.   

In the excel file the column title are such as "by","dt", "lb" etc. What do they mean? the following list is the meaning of them:

AttributeContent
byBytes
deData encoding
dtData type
ecError count (0 or 1, unless multiple samples are aggregated)
hnHostname where the sample was generated
itIdle Time = time not spent sampling (milliseconds) (generally 0)
lbLabel
ltLatency = time to initial response (milliseconds) - not all samplers support this
ctConnect Time = time to establish the connection (milliseconds) - not all samplers support this
naNumber of active threads for all thread groups
ngNumber of active threads in this group
rcResponse Code (e.g. 200)
rmResponse Message (e.g. OK)
sSuccess flag (true/false)
scSample count (1, unless multiple samples are aggregated)
tElapsed time (milliseconds)
tnThread Name
tstimeStamp (milliseconds since midnight Jan 1, 1970 UTC)
varnameValue of the named variable (versions of JMeter after 2.3.1)



 





 


No comments:

Post a Comment