www.homeseer.com    
 

Go Back   HomeSeer Message Board > HomeSeer Products & Services > HomeSeer General Discussion Area

HomeSeer General Discussion Area General discussion about HomeSeer that does not fall into any other category or are not specific to 1.x or 2.x versions of HomeSeer.

Reply
 
Thread Tools Display Modes
  #1  
Old May 11th, 2018, 08:11 AM
Brizeeafc Brizeeafc is offline
Seer
 
Join Date: Jun 2017
Location: Scotland
Posts: 9
System Reporting - Addons

Hi All

Looking for some advice.

I've had my Homeseer system for a year now and it works great.
What I'm looking for now is a way to produce a report that can be emailed or exported to excel.

In the report id like something like (I have modules to get the information)

1. Lowest, highest and average temperature per room.
2. How much Electric I've used today, I have an event that emails this at the moment.
3. How much gas I've used.

Would there be an add on that could help with this?

Thanks in advance.

Brian
Reply With Quote
  #2  
Old May 11th, 2018, 09:06 AM
Pete's Avatar
Pete Pete is offline
OverSeer
 
Join Date: Jan 2001
Location: House
Posts: 15,298
There is Jon00 Windows graphing utilities for creating your graphs / charts over here:

Jon00 Database Charting Utility for Homeseer 3

You could maybe write a script that creates a report from the above named plugin autonomous SQLite database. (like a mini Crystal reports / SAS BO thing).

There is also a charting paid plugin over here:

Device history software Plug-in for Homeseer 3

Thinking that is is drawing data from Homeseer's SQLite DBs.

Too there is the mcsMQTT plugin which uses Mosquitto over here ==> Discussion of mcsMQTT plug-in

Note the default Homeseer 3 DB is SQLite in Microsoft Windows or Linux (ARM or Intel / AMD).

There is one Homeseer user over the years that has manually created reports using Microsoft Excel for data and charting. Thinking he may still be doing this today.

My current Linux Homeseer 3 boxes are LAMP servers with mySQL running on them and I do utilize the mySQL for Homeseer a bit. I am seeing now the mySQL MariaDB being utilized a lot.
__________________
- Pete

Automator

HS3 Pro & Lite Edition Beta 3.0.0.435

HS3 Wintel Touch | Ubuntu 16.04 64 bit | Oracle Windows Virtual Box ==> for Wintel only SAPI and HS3 plugins | Speech - Microsoft SAPI - Neospeech - Amazon Echo | Hardware | Haswell Intel iSeries 3 - 16Gb | Pine64 - 2Gb computers | Openpeak Intel Atom SoC tabletop touchscreens (15 HS tabletop tablets) | Touchscreens - Windows embedded POE connected |Light switches - X10,UPB, ZWave and Zigbee | Firewall - PFSense - 2 WAN plus 4 LAN interfaces | Network - Gb managed switches / POE WAP(s) | CCTV - Zoneminder IPHD cams - variety | Audio - Russound - AB8SS | Security - Leviton HAI Omni Pro 2 | Weather - Davis Vantage Vue - MeteoStick - WeeWx | 1-Wire - AAG, Midon and HB | OWFS - Mosquitto - Node Red - Python - RPi Stretch - OpenWRT

Last edited by Pete; May 11th, 2018 at 10:52 AM.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
System crashed and seriously messed up my system jonjonbear Insteon Plug-in (Mark Sandler) 4 December 9th, 2015 12:07 PM
How to create your own addons. tonlof Tasker Plugin (3P) 0 May 16th, 2015 05:01 PM
Enable/disable addons from plug in kenrad Kodi/XBMC Plug-In (3P) 2 July 18th, 2014 09:01 PM
Updating XBMC Frodo Ubuntu PVR Addons Pete How-To's 6 February 23rd, 2014 06:26 PM


All times are GMT -4. The time now is 04:14 AM.


Copyright HomeSeer Technologies, LLC