Excel export of statistics
After the second/third processing of production statistics, we can say that, although they are very easy to generate, the processing of the screenshot export are slow and painful !
So I shifted priorities, and invested some time in Excel export :)
And now, all statistics information can be exported to an Excel spreadsheet in one click. They include:
- Stats metadata
- Main statistics with inclusion of Spider generated graphics as is
- Source data of the previous graphics (heatmap, distribution, evolution)
- And the most interesting: Pivot table with the grouped statistics
- With the same color scale as on the website
Thanks https://github.com/guyonroche/exceljs for the very nice library!
Examples
Response time statistics of GET parks/areas
Excel export: Spider stats - Duration
Response time statistics on SIT1 by service, url, verb and status (truncated)
Excel export: Spider stats - Duration, group by Server (merged), URL templates, Verb, Status
Enjoy! Thibaut
Quick filter on Correlation Ids
Special dedicace to Bertrand R.! :)
I added a new column 'links' in HTTP grid. For now, it tells you if Correlation Ids has been found on a communication, and, if yes, allow you to filter on them with one click, and even to open the related sequence diagram by clicking while holding shift.
Analysing Controls or Rights calls fan outs has never been simpler ;-)
Note: a new setting is needed to list Correlation Ids headers to watch. It is valued with Streetsmart correlation-token header by default in Streetsmart server configuration.
PS: Timeboxed in 3 hours ;)
Filters shortcuts on column headers
I love React. Reuse of components is just so easy!
I added 'shortcuts' to filters in the columns headers of the grid. That will fasten your work and I hope improve the User Experience :-)
Nicolas C. suggested it, and I had it in my roadmap... but I never actually thought how to do it. And after some thinking, I found an solution so easy and reusing existing ones that... here are they, a couple of hours later =)
Enjoy!
Filter for range
Search autocompletion - 1st step
Color syntaxing in search
Perform a diff between communication items in Spider :) !
You may now perform a diff between selected items in Spider :)
- Differences are marked in yellow background.
- When content is compared, new data is in green, removed data in red, striked through.
- You can compare as many items as you want, they are all compared to the first one selected.
- There is no circuit breaker yet (tests in progress)... Diff may take a very long time or fail on too big payloads.
- Library used for Diff: https://github.com/kpdecker/jsdiff
Enjoy, and leave a comment! Especially for any bugs... this is first release, and will surely improve ;-)
First, select communications to compare, and click Compare icon:
Global tab show metadata from communications, yellow cells mark differences.
Headers tab shows diff in headers.
And Request bodies and Response bodies tabs show differences in formatted content.
Cheers, Thibaut
Grid selection is out there!
For next coming feature (comparison of items), I needed first to implement selection on grid.
Grid selection is now available:
- You can select records on grid
- Your selection is kept through time selection change, browser refresh, view change and so on.
- You can choose to see only your selection (specific filtering)
- And you can clear it.
More is coming, stay tuned
Added 'Unmatched URLs' category in aggregated stats table
Unmatched URLs category gives information on URLs that don't match any defined templates. This way, if you notice issues in statistics there, you know that you need to search and complete your templates ;-)
Those stats are on grey background. They are not taken into account on the color scale. Why? Because they are statistics you did not classify, which supposed to mean that you don't care much about.