Skip to main content

Excel export of statistics

· One min read

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

· One min read

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 ;-)

Result:

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

· One min read

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 items

Filter for range

Search autocompletion - 1st step

· One min read

First step autocompletion has been added to search inputs :) !! Now, you can type in the fields name much faster !

Next step... suggestion of values!

Perform a diff between communication items in Spider :) !

· One min read

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!

· One min read

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

· One min read

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.

New Spider loading screen

· One min read

I've changed the blank page launching screen to something more... relevent ;) Basically, it makes people feel the application loads faster, when in fact... it doesn't =)

But at least you know that loading is in progress much before!