Status Board app

Community Playground General Discussions
1

I thought people might be interested in a dashboard i have got going from Vera using iOS Status Board app for the iPad.

I?ve taken a number of feeds from vera that are emailed out to Google Docs every 15 mins. A few equations in the sheet, and Status Board shows them up very nicely as a live feed.

High level:
Use VeraAlerts to email a gmail account with the time and variable from vera.
Use IFTTT to check the email account and add the email contents to a new spreadsheet in Google Docs.
Process, chop off the characters etc in the Google Sheet to create a clean and rolling updated 200 odd data point graph co-ordinates per variable.

Has anyone else done anything like this?

2

Very creative and quite attractive too.

There’s an awful lot of cloudy processing involved. Frankly, it seems a bit Rube Goldberg-ian, but it’s hard to argue with the results. I just wonder if DataYours could do this without having so many dependencies. Perhaps @Akbooer will weigh in.

3

It’s not the cleanest view, and i’m in the process of tidying it up, plus i’m monitoring 3 vera units.

I guess that’s why i was posting it up here really. It’s working this way, but i’m sure it’s not the slickest. Anyone got any suggestions on improvements?

I’ve posted another shot with just one property/vera and the other feeds that Status Board can do, e.g., twitter, weather etc.
(i’m not affiliated with Status Board or anyone else, other than i like the functionality)

4

Hi @thetwc

I thought I would have a go with Status Board and noticed your post, are you able to share more details - have you changed anything since your post ?

The online instructions (How to make your own graph) suggest if you could return a JSON file from Vera, that would work e.g. This coke example.

{ "graph" : { "title" : "Soft Drink Sales", "datasequences" : [ { "title" : "X-Cola", "datapoints" : [ { "title" : "2008", "value" : 22 }, { "title" : "2009", "value" : 24 }, { "title" : "2010", "value" : 25.5 }, { "title" : "2011", "value" : 27.9 }, { "title" : "2012", "value" : 31 }, ] }, { "title" : "Y-Cola", "datapoints" : [ { "title" : "2008", "value" : 18.4 }, { "title" : "2009", "value" : 20.1 }, { "title" : "2010", "value" : 24.8 }, { "title" : "2011", "value" : 26.1 }, { "title" : "2012", "value" : 29 }, ] } ] } }

5

That is almost exactly the same format as Graphite / DataYours uses: The Render URL API — Graphite 1.2.0 documentation

It would be but the work of a moment to make it so…

…alternatively, you could just get Vera to mail you the SVG of the graphs themselves.

6

Hey @akbooer

Yeah, I was thinking about how I could work DataYours data into it as well, as Status Board supports .csv files, hosted on Dropbox.

For a simple widget for e.g a temperature reading, or occupancy value - do you have any idea how to create one using the examples they give. They suggested viewing the source, which I did but can’t work out how they did it. I was thinking I could simply change it to call the value from Vera via a http request.

https://www.panic.com/statusboard/docs/spacepeople.html

Here’s one that someone modified to show a stock/share price

http://statusboard.maccast.com/appl_stock.php

The nice thing is that if you have the app, you can use a schemer to auto load the widgets e.g

panicboard://?url=http://statusboard.maccast.com/appl_stock.php&panel=diy&sourceDisplayName=Maccast

7

To be honest, i haven’t used it much. I was monitoring it for a week or so, then stopped.
You have given me a nudge to start using it more though. The gmail sheets must blocked up with he data by now.

8

I hope that’s a good thing ;D

I’m away at the moment, but have been researching it as much as I can, and so far I’ve found some really interesting stuff. - http://statusboardpanels.com

This one interests me the most, which I found on GitHub - GitHub - rknightuk/githubstatus: A widget for Panic's Status Board for iPad to show GitHub status (status.github.com) Because I think this could be something that could be reworked to extract data (e.g temp, status, etc) directly from Vera via JSON calls. (http://wiki.micasaverde.com/index.php/UI_Notes)

9

While the goal is still to integrate with Vera so there is a single focal point, here are some other interesting boards I’ve come across , (which I’ll need to find time to install/play with)…

Phillips Hue - GitHub - bleything/panicswitch: A widget for Panic's Status Board app that controls your Philips Hue lights.
Nest Thermostat - http://takitapart.com/posts/nest-on-the-panic-status-board/
Webcam image - A simple Javascript-based reload of a webcam for use with Status Board. · GitHub

10

I grabbed the URLs of DataYours graphs and then just load those URLs into panels.
too much padding and doesn’t format nicely, the native (to status board) graphs look better.
But it’s been rock solid and gets the job done.

I also have a scene which, when triggered by a door opening, will generate a table with the last tripped time of each of the house doors.
I then have that last tripped panel in my status board as a table

needs tuning but it’s functional. I can at a glance see lots of data.

|-<:)

[quote=“parkerc, post:6, topic:186384”]Hey @akbooer

Yeah, I was thinking about how I could work DataYours data into it as well, as Status Board supports .csv files, hosted on Dropbox.

For a simple widget for e.g a temperature reading, or occupancy value - do you have any idea how to create one using the examples they give. They suggested viewing the source, which I did but can’t work out how they did it. I was thinking I could simply change it to call the value from Vera via a http request.

https://www.panic.com/statusboard/docs/spacepeople.html

Here’s one that someone modified to show a stock/share price

http://statusboard.maccast.com/appl_stock.php

The nice thing is that if you have the app, you can use a schemer to auto load the widgets e.g

panicboard://?url=http://statusboard.maccast.com/appl_stock.php&panel=diy&sourceDisplayName=Maccast[/quote]

11

[size=10pt]Vera - Status Board Temperature Graph[/size]

Just an update to say that with @akbooer’s (immense) help we have created some code for Vera to create JSON structure that meets the format Panic’s status board needs to create a graph.

Add that code to a scene and set it to run every x - mins

See here for more details - http://forum.micasaverde.com/index.php/topic,38702.0.html

12

[size=10pt]Vera - Status Board Battery Level Graph[/size]

Another StatusBoard panel for those that are interested, runs the same way as the temperature graph, update and use code within a recurring scene to generate a webpage for Status Board to refer to…

[code]local oftrvID = luup.variable_get(“urn:micasaverde-com:serviceId:HaDevice1”, “BatteryLevel”, 172)
local srtrvID = luup.variable_get(“urn:micasaverde-com:serviceId:HaDevice1”, “BatteryLevel”, 17)
local mbtrvID = luup.variable_get(“urn:micasaverde-com:serviceId:HaDevice1”, “BatteryLevel”, 263)
local cotrvID = luup.variable_get(“urn:micasaverde-com:serviceId:HaDevice1”, “BatteryLevel”, 304)

local text = [[

Status Board Battery Level Graph th { font-size: 22px; font-weight: bold; padding-left: 5px; padding-bottom: 3px; } td { height: 10px; font-size: 20px; font-weight: bold; padding-left: 5px; padding-bottom: 3px; } .name { width: 125px; height: 10px; text-align: left; } .progress { width: 150px; height: 10px; } .level { width: 40px; height: 10px; text-align: right; }
Vera Device Battery Level %
Office TRV
]]..oftrvID..[[
Spare Room TRV
]]..srtrvID..[[
Bedroom TRV
]]..mbtrvID..[[
Conservatory Therm
]]..cotrvID..[[
]]

local file = io.open(“/www/trvbatteries.html”, “w”)
file:write (text)
file:close()[/code]