Direct Storage from HS Devices to InfluxDB

[Michael McSharry]

InfluxDB is independent of any MQTT traffic. You can use mcsMQTT without any MQTT associations and have only InfluxDB supported or you can have a combination of both. All I did was leverage the mcsMQTT UI to allow the user to select HS items from the Association tab and then when HS notifies that the HS device has been set then the value is routed to InfluxDB.

[ksum]

Does this mean I need an MQTT item associated with any HomeSeer device I wish to have data sent to InfluxDB? I am interested in having z-wave switches report status and value changes but do not intend on associating them with any MQTT topics.

[Michael McSharry]

Version 5.12.0.0 adds support to store HS Device Feature values directly into InfluxDB. Any time a HS DeviceValue is set, the value will be stored in InfluxDB. Selection of the Device Features that are to be placed in this database is done by use of checkbox in the "I" column on the list of HS Device Features.

There are other means to get data into InfluxDB such as via NodeRed or via Telegraph using MQTT or other protocols. The intent of this approach is to minimize the number of components a user needs to setup and to provide an easy way to select which values are to be included in InfluxDB.



The parameters of the InfluxDB server are setup on the History tab of mcsMQTT



The HS4 plugin is at http://mcsSprinklers.com/HSPI_mcsMQTT_5_12_0_0.zip. The HS4/HS3 plugin is at http://mcsSprinklers.com/mcsMQTT_5_12_0_0.zip. Upload speeds are slow it should be available in 30 to 60 min.

The mcsMQTT manual contains additional information on InfluxDB including setup of the server for the RPi for those who want a streamlined approach. The manual is in the updater zips referenced above and at http://mcsSprinklers.com/mcMQTT.pdf

To side-load a plugin the following process is used for HS4
1. Download the zip file that is in the HS4 updater format. (e.g. http://mcsSprinklers.com/HSPI_mcsMQTT_5_12_0_0.zip)
2. Place the download in the HS4 folder.
3. Unzip the file updater_override.json and put it in the same HS4 folder.
4. With browser navigate the the HS4 plugin menu, Add option. Only HS4 plugin available will be mcsMQTT. Select it. (I do not recall if you need to deselect the current mcsMQTT version before this or not)
5. Remove updater_override.json to restore normal Updater operation.

For HS3 it is paraphrased from the HS3 SDK
1. Download the zip file that is in the HS3 updater format. (e.g. http://mcsSprinklers.com/mcsMQTT_5_12_0_0.zip)
2. Place your package installation ZIP file into the \Updates3\Zips folder.
3. Unzip updater_override.txt. I believe it goes in the HS3 folder.
3. Now go to the menu Plugins‐>Manage and click on the Refresh (Update Listing) button so it finds your updater_override.txt file and it should list your package
4. Remove updater_override.txt file to restore normal Updater operation.