LoWi3, MiLo, ReMI and MEMo3 register energy data from the connected meters and use it for the histories in the web server, for cost settlement, for control based on consumption,…This locally stored data can be shared in several ways:
Export to Excel in the form of a csv file
Export via http to a freely selectable central platform
Export via MQTT every minute between web servers LoWi3,ReMI, MEMo3 among themselves or with the smartplugs and THEos, or to an external app or cloud application.
LoWi, MiLo, ReMI
For the daily graphs, MiLo records the last 7 days at 1 hour resolution, LoWi3 and ReMI record the last 10 days at 5 minutes resolution. For the monthly charts, that will be the last 12 months at 1 day resolution. The ‘PRINT’ button under ‘DETAILS’ exports the chart data per day or per month to a readable csv file with the same resolution as in the charts.
MEMo3 records 7 variables in 32 bit format every minute for each of its 64 energy channels and stores these values for the last 3 years on its internal SD card. With the button ‘SUBTOTALS’ one can:
The data loggers LoWi3, ReMI and MEMo3 can be set to upload data periodically to a private http server.
In every http post, the MAC address is readably sent along in the url. The remote server can then do an initial test and see if this MAC address is available in its directory listing. The http file is in JSON format and consists of a header and a body.
The header is encrypted by the web server with a ‘secret key’. One can use this header “as a certificate” to have additional assurance of the sender’s identity.
The Body contains the measurement data in base64 format and this can be easily converted to a readable format. The result is very similar to the csv file which creates the export to Excel.
An example is the http link to EnergieID: In the LoWi3/ReMI setup paste the EnergieID url and login and the data is continuously loaded. Useful for backup, or to compare installations among themselves. In the City of Ghent’s Renometer project, energy consumption before and after home renovation is monitored.
2-WIRE data loggers and 2-WIRE modules interconnecting over the Internet, or forwarding data an external system (Raspberri Pi, home automation …), or to an application on a smartphone or in the cloud, it’s all possible via MQTT.
The prerequisite: stable internet and an MQTT license at 2-Wire or another broker.
MQTT between web servers
Via MQTT, we can pass any of the 16 log channels in a LoWi3, over the internet to e.g. a ReMI and a MEMo3.
In both web servers enter the MQTT account settings (url, login and password) and all log channels of both web servers are published (PUBLISH) every minute as Topic based on the MAC address.
To subscribe to this external data, create an MQTT log channel and give it a name, enter remote MAC address and respective channel number and the internet data is logged to monitor and switch.
MQTT with a smart plug
Distances no longer play a role, place an MQTT plug and then monitor and control it from another location, idem with the THEo stick with which one monitors air quality from a distance.
MQTT with the digital meter via P1
With the ‘fast publish’ button in the LoWi3 and ReMI, the digital meter values are loaded to MQTT every 10 seconds and thence forwarded to any linked server or application.
Data (payload) is JSON:
open Home Automation Bus (openHAB) is a software solution developed in Java that connects building automation components from different vendors in a protocol-neutral manner in one manufacturer-independent platform. Via wireless or non-wireless protocols (ZigBee, WiFi, Bluetooth, Z-Wave, GSM, KNX, Ethernet) lights, curtains, alarms, audio and video can be controlled and monitored.
Via MQTT, 2-Wire web servers (LoWi3, ReMI, MEMo3) and modules (Smartplug, THEo) can also be linked to openHAB.
From a 2-WIRE user we received some screenshots of his integration into openHAB.
Home Assistant is an open source platform for centralized control of smart devices and home automation, with a focus on freedom and privacy. The software can be used either as stand-alone software, within a container or with an associated operating system. Home Assistant can then be accessed through a Web interface and mobile applications for Android and iOS.
Home Assistant can communicate via a wide range of integrations created by volunteers with common home automation platforms from Google, IKEA, Amazon, Apple (HomeKit), Signify (Philips Hue), Tuya and via MQTT with the 2-WIRE web servers, among others LoWi3, ReMI, MEMo3 and the WiFI Plug .
Measurements from the digital meter and also yield from solar panels or the consumption of the charging station can be integrated to provide the user with a live overview of energy consumption, and based on changes in this data to take automated action.
From Jean-Paul we got a few screenshots of his integration in Home Assistant, an example of his code can be found in the MQQT manual.
The HTML_APP combines the benefits of an app, cloud and port forwarding in one document which one stores on the hard drive of the PC, tablet or central server(website) and opens with any web browser.
Separate from the customer’s corporate network, one can connect a GPRS modem with SIM card to a MEMo3 and through the HTML_APP one has full access to all functionalities. Incredibly useful to be able to easily monitor an installation in terms of operation, consumption, costs,….
In the play store of Android you can start downloading different MQTT apps, including“IoT MQTT Panel” by Rahul Kundu from India. This is basically a remote for smart home based on the MQTT platform in a free or a paid pro version. Here you can compose your own layout with line of bar graphs, radio buttons, speedometers,… light/dark mode, … with the different Topic and payloads from the LoWi3, ReMI, MEMo3, THEo, Plug,… from 2-WIRE and even combined with devices from other brands.
This APP also has ability to show historical consumption graphs with limited number of measurement points. Thus, even without a web server, one can control the autonomous WiFi (MQTT) plug, read out power and show ‘histories. Like the plug, the THEo stick can operate autonomously as a stand-alone MQTT device.
Elektrisch verbruik, injectie en gas uit de digitale meter worden via de PPC.04 module omgezet naar pulsen en dan ingelezen op eender welke datalogger. In het voorbeeld hiernaast gebeurt de inlezing en logging met een raspberry pi.
Ook de ReMI module heeft 2 solid-state uitgangen welke elk gemeten verbruik kan omzetten naar verbruikspulsen.
2-WIRE web server data loggers collect consumption data and can start displaying it live via web browser, on any platform within the network. Web servers can be set up to publish or upload this data to external applications. We use standard protocols and file formats so that integration can be done with a minimum of development.
Please note that the purchase price of the modules does not include extensive support for development of your own applications.
Fill in the required fields and get the free development package in your mailbox!