# Tools to automatically record test metrics **URL:** \ **Category:** Archive\ **Tags:** automation\ **Created:** [5 January 2018 14:34 UTC](https://club.ministryoftesting.com/t/tools-to-automatically-record-test-metrics/12447 "2018-01-05T14:34:25Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![becky.munn](https://avatars.discourse-cdn.com/v4/letter/b/eb8c5e/32.png) [@becky.munn](https://club.ministryoftesting.com/u/becky.munn)\ **Post date:** [5 January 2018 14:34 UTC](https://club.ministryoftesting.com/t/tools-to-automatically-record-test-metrics/12447/1 "2018-01-05T14:34:25Z")
Hi guys, I am a new automation tester at a small firm using the following tools Robot Framework Pycharm Jira Confluence There is also talk of ingratiating Jenkins Currently after every run of our test suit (triggered using a .bat file) we manually view the results file generated by Robot framework and update the following information into a spreadsheet. Number of tests run Number of tests Passed/Failed A note as to why any tests may have failed. Why the tests where run i.e. Smoke/daily run A link to the local file that stores the report.html This cannot be a good way of recording this information. My question is this. What tools do you use to store test result metrics? is there any way to automate this process, ideally with open source software or Microsoft office? I have thought about creating some sort of .bat file that grabs the results data and updates the spreadsheet, has anyone done this? Thanks guys ---
**Author:** ![ddocherty](https://avatars.discourse-cdn.com/v4/letter/d/bc79bd/32.png) [@ddocherty](https://club.ministryoftesting.com/u/ddocherty)\ **Post date:** [5 January 2018 15:15 UTC](https://club.ministryoftesting.com/t/tools-to-automatically-record-test-metrics/12447/2 "2018-01-05T15:15:52Z")
If you are going to integrate Jenkins this may be of use (I’m not too familiar with Robot Framework/Jenkins so sorry if going down the wrong path!): [https://wiki.jenkins.io/display/JENKINS/Robot+Framework+Plugin](https://wiki.jenkins.io/display/JENKINS/Robot+Framework+Plugin) Also seems there is this app in the Atlasian Marketplace, not sure if any use for your needs? > **[RobotTest](https://marketplace.atlassian.com/apps/1216501/robottest?hosting=server&tab=overview)** > > Run Robot Framework Tests and view results from within Bamboo ---
**Author:** ![burdettelamar](https://sea2.discourse-cdn.com/flex020/user_avatar/club.ministryoftesting.com/burdettelamar/32/2536_2.png) [@burdettelamar](https://club.ministryoftesting.com/u/burdettelamar)\ **Post date:** [28 January 2018 17:50 UTC](https://club.ministryoftesting.com/t/tools-to-automatically-record-test-metrics/12447/3 "2018-01-28T17:50:54Z")
In a recent gig, I used Ruby to read the log files and update a History Report (Excel spreadsheet). In previous gigs, I have done the same in Python (also downloading log files from Jenkins). In Ruby, I used REXML to read the log files and WIN32OLE to update the report. At the left of the report are the verdict IDs, log file paths, etc.; a the top are the dates, build IDs, counts, etc. There’s a column for each test run, giving the verdict outcome (passed/failed/blocked). The update inserts a new column for the new test run, pushing the previous data to the right, so the history for each verdict reads left-to-right present-to-past. In my GitHub project, RubyTest, I have already built code to generate the [Changes Report](https://github.com/BurdetteLamar/RubyTest/blob/master/examples/changes_report/ChangesReport.md#changes-report), but have not yet built code to build/update a History Report. Should that be a priority? ---
**Author:** ![shivaadirala](https://avatars.discourse-cdn.com/v4/letter/s/dec6dc/32.png) [@shivaadirala](https://club.ministryoftesting.com/u/shivaadirala)\ **Post date:** [23 October 2018 12:57 UTC](https://club.ministryoftesting.com/t/tools-to-automatically-record-test-metrics/12447/4 "2018-10-23T12:57:49Z")
[Robotframework-metrics](https://github.com/adiralashiva8/robotframework-metrics/) report has export functionality where we can export suite, test, keyword metrics in different formats (pdf, excel,csv). [Sample Report](https://robotframework-metrics-report.netlify.com/#) ---
**Author:** ![invertednz](https://sea2.discourse-cdn.com/flex020/user_avatar/club.ministryoftesting.com/invertednz/32/4485_2.png) [@invertednz](https://club.ministryoftesting.com/u/invertednz)\ **Post date:** [8 February 2019 11:38 UTC](https://club.ministryoftesting.com/t/tools-to-automatically-record-test-metrics/12447/5 "2019-02-08T11:38:12Z")
We use Appsurify 😛 but it is my company! ---
**Author:** ![ahsansubhani677](https://avatars.discourse-cdn.com/v4/letter/a/858c86/32.png) [@ahsansubhani677](https://club.ministryoftesting.com/u/ahsansubhani677)\ **Post date:** [21 March 2022 14:19 UTC](https://club.ministryoftesting.com/t/tools-to-automatically-record-test-metrics/12447/7 "2022-03-21T14:19:14Z")
Hi I use **TEST GEAR** use to store test result metrics. Through **TEST GEAR** , I have done testing of created .bat file that grabs the results data and updates the spreadsheet. It is best tool for this purpose.