Announcement

Collapse
No announcement yet.

System Reporting - Addons

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    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

    #2
    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.
    Last edited by Pete; May 11, 2018, 09:52 AM.
    - Pete

    Auto mator
    Homeseer 3 Pro - 3.0.0.548 (Linux) - Ubuntu 18.04/W7e 64 bit Intel Haswell CPU 16Gb
    Homeseer Zee2 (Lite) - 3.0.0.548 (Linux) - Ubuntu 18.04/W7e - CherryTrail x5-Z8350 BeeLink 4Gb BT3 Pro
    HS4 Lite - Ubuntu 22.04 / Lenovo Tiny M900 / 32Gb Ram

    HS4 Pro - V4.1.18.1 - Ubuntu 22.04 / Lenova Tiny M900 / 32Gb Ram
    HSTouch on Intel tabletop tablets (Jogglers) - Asus AIO - Windows 11

    X10, UPB, Zigbee, ZWave and Wifi MQTT automation-Tasmota-Espurna. OmniPro 2, Russound zoned audio, Alexa, Cheaper RFID, W800 and Home Assistant

    Comment

    Working...
    X