Exporting Statistics?


Daniel Brown
 

Dave --

Is there any way to pull spot collector's (and/or any other)
statistics into other applications? Ideal would be something like
exposing them for collection by something along the lines of a
Prometheus exporter.

see:

https://prometheus.io/
https://prometheus.io/docs/instrumenting/exporters/


--
Dan Brown
brown@...


Dave AA6YQ
 

+ AA6YQ comments below
Is there any way to pull spot collector's (and/or any other)
statistics into other applications? Ideal would be something like
exposing them for collection by something along the lines of a
Prometheus exporter.

+ You can make a copy of SpotCollector's Spot Database, and then direct Microsoft Excel to open the Spots table in that copy. That will give you access to the entire contents of the Spot Database.

+ By creating and opening a copy, inadvertent changes to the schema won't prevent SpotCollector from subsequently being unable to open the original database.

+ The same action is possible with the tables in your log database, which will provide access to your QSOs as well as your progress towards the DXCC, IOTA, Marathon, VUCC, WAS, WAZ, and WPX awards.

+ If you have questions about the structure of any of these tables, don't hesitate to post them here.

       73,

               Dave, AA6YQ


Daniel Brown
 

On Jun 23, 2022, at 12:47 PM, Dave AA6YQ <aa6yq@...> wrote:

+ AA6YQ comments below
Is there any way to pull spot collector's (and/or any other)
statistics into other applications? Ideal would be something like
exposing them for collection by something along the lines of a
Prometheus exporter.
+ You can make a copy of SpotCollector's Spot Database, and then direct Microsoft Excel to open the Spots table in that copy. That will give you access to the entire contents of the Spot Database.

+ By creating and opening a copy, inadvertent changes to the schema won't prevent SpotCollector from subsequently being unable to open the original database.

+ The same action is possible with the tables in your log database, which will provide access to your QSOs as well as your progress towards the DXCC, IOTA, Marathon, VUCC, WAS, WAZ, and WPX awards.

+ If you have questions about the structure of any of these tables, don't hesitate to post them here.



Thanks for the response — guess I could/should have been more clear - I was hoping for more “near real time” stats or metrics, which could be exported and accumulated into a time-series database, such as Prometheus, to allow graphing / analysis using external tools like Grafana, What you suggest sounds reasonable, but seems like more of a “post processing” kind of analysis.




--
Daniel Brown
daniel.h.brown@...


Dave AA6YQ
 

+ AA6YQ comments below
Thanks for the response — guess I could/should have been more clear - I was hoping for more “near real time” stats or metrics, which could be exported and accumulated into a time-series database, such as Prometheus, to allow graphing / analysis using external tools like Grafana,

+ Which realtime analytics are you seeking? Are you aware of those provided when you click the Main window's "Stats" button?

      73,

             Dave, AA6YQ


Michael (N1EN)
 

For something like this, you might consider looking into running a cluster node, and working with the log files.

Michael / N1EN