Graphing framework/application

Hi,

I like dataMine but want to move this out from Vera3 and therefore I publish monitored events to MQTT as JSON messages and then save them in a relational database (MySQL). One table for the devices/variables monitored and another table for measurements (temperature, watt,…). These messages pass through MuleESB since I am an integration guy :slight_smile:

I now would like to have a graphing solution on top of that, similar to dataMine with Highcharts etc but my frontend/UI skills isn’t on top so I wonder if you have seen some framework (or application to be modified) to get a quickstart building such a tool. I can fix the data to the "tool, no problem.

Any input?

Google Charts may be what you need… no need to load a code library explicitly, all rendering done in the browser.
[url=https://developers.google.com/chart/]https://developers.google.com/chart/[/url]
I use it for my DataYours app, which has some of the same functionality as dataMine.

[quote=“akbooer, post:2, topic:184286”]Google Charts may be what you need… no need to load a code library explicitly, all rendering done in the browser.
[url=https://developers.google.com/chart/]https://developers.google.com/chart/[/url]
I use it for my DataYours app, which has some of the same functionality as dataMine.[/quote]

Hi akbooer,

are you still using Google Chart to access Datayours data ? In positive case can you give me some more info ?

tnks

donato

Yes, it’s the graphics engine for all the [tt]DataYours[/tt] displays, tables, and charts.

I learnt all I know from that link… what were you after in particular?

[quote=“akbooer, post:4, topic:184286”]Yes, it’s the graphics engine for all the [tt]DataYours[/tt] displays, tables, and charts.

I learnt all I know from that link… what were you after in particular?[/quote]

Hi akbooer,

I’m looking for a tool/app that can be used to design custom dashboard based on data archived (possibly through widgets). I’ve looked around graphite tools but I didn’t find anything of this type.

tnks

donato

So something like this, then? [url=http://thomasvm.github.io/blog/2012/11/19/bling-dashboards-using-graphite-and-dashing/]http://thomasvm.github.io/blog/2012/11/19/bling-dashboards-using-graphite-and-dashing/[/url]

…with a rather fine live demo here: [tt]http://dashingdemo.herokuapp.com/sample[/tt]

So something like this, then? [url=http://thomasvm.github.io/blog/2012/11/19/bling-dashboards-using-graphite-and-dashing/]http://thomasvm.github.io/blog/2012/11/19/bling-dashboards-using-graphite-and-dashing/[/url]

…with a rather fine live demo here: [tt]http://dashingdemo.herokuapp.com/sample[/tt][/quote]

Yesss just like this. Is it necessary to write some code ?

tnks

donato

Instructions here… [url=http://shopify.github.io/dashing/]http://shopify.github.io/dashing/[/url]

Instructions here… [url=http://shopify.github.io/dashing/]http://shopify.github.io/dashing/[/url][/quote]

tnks akbooer . I’ll see the instructions at link.

donato

If you need help setting up Dashing with Highcharts, please let me know. I am working on something similar.
Example: [url=https://dl.dropboxusercontent.com/u/4811041/Dashing.png]https://dl.dropboxusercontent.com/u/4811041/Dashing.png[/url]

[quote=“tvdnagel, post:10, topic:184286”]If you need help setting up Dashing with Highcharts, please let me know. I am working on something similar.
Example: [url=https://dl.dropboxusercontent.com/u/4811041/Dashing.png]https://dl.dropboxusercontent.com/u/4811041/Dashing.png[/url][/quote]

Hi tvdnagel,

I’d like to use in a dashboard data captured and stored by Datayours. At the moment the data and the daemons are on a Rpi connected to a VeraEdge. Only the Watcher daemon is on VeraEdge.

tnks donato

Currently I’m still using DataMine. If the HTTP request and JSON respone are the same for DataMine and DataYours my code should work.
Otherwise it can be adapted of course.

I might experiment with DataYours sometime soon to see if my app still works.

It’s not the same protocol… [tt]DataYours[/tt] uses as subset of the Carbon Graphite “Render URL API” protocol described here [tt]http://graphite.readthedocs.org/en/latest/render_api.html[/tt].

I’ve managed to adapt my app to use dataYours data. I’ll need to cleanup some things before I share it if somebody is interested.

Yes, please. Would be very interesting.

Here’s the link to the project’s Github page:
[url=https://github.com/TimmermanTim/VeraDashboard]https://github.com/TimmermanTim/VeraDashboard[/url]

You’ll need to have a Linux machine to use it.
My VeraDashboard is based on Dashing.
For a tutorial how to set up Dashing under Ubuntu, see: [url=http://www.pixelite.co.nz/article/how-create-dashboard-dashing-and-integrate-drupal-data/]http://www.pixelite.co.nz/article/how-create-dashboard-dashing-and-integrate-drupal-data/[/url]

I am no Ruby developer, so my code might not be as tidy and optimized as it can be, but it works :slight_smile:

This looks terrific. I was hoping somebody would rise to the challenge. I’ll give it a go when I have a bit more time. Thanks for sharing this.

Is this easy to integrate? I didn’t see any instructions?

Any idea if we can run this on a Synology NAS? Maybe make a docker package so it is a simple install on the newer DSM versions?

Is there any way this dashboard could be used to turn on/off ligths? Would be perfect for a wallmounted tablet!