Monday, July 18, 2016

How to generate html report from jmeter output? ie., JTL -> HTML


How to generate html report from jmeter output? ie., JTL -> HTML


Steps
1) Find and replace the special characters in the jtl file.

Making use of vim find and replace commands will replace all special characters like &#xw;, &#xww;, &#xwww;, &#xwwww; and &#x12123 with empty space. This step have to be done because xsltproc will not work if these characters present.

vim -c ":%s/&#x\w;//g" -c ":wq" log.jtl
vim -c ":%s/&#x\w\w;//g" -c ":wq" log.jtl
vim -c ":%s/&#x\w\w\w;//g" -c ":wq" log.jtl
vim -c ":%s/&#x\w\w\w\w;//g" -c ":wq" log.jtl
vim -c ":%s/&#x0//g" -c ":wq" log.jtl
vim -c ":%s/&#x\d+//g" -c ":wq" log.jtl

2) Execute xsltproc command using the attached style sheet Jmeter-Results-Details.xsl.

xsltproc Jmeter-Results-Details.xsl log.jtl  > output/result.html

Here log.jtl is the jmeter result file. The result.html is the converted html file we want.

Note:

A) The steps are for linux machine. If you have a windows machine the utility xsltproc can be installed separately and find and replace can be done using any document editing software.

B) Style sheet used - XSLT Style Sheet for JTL to HTML