Home Assistant - Emoncms History

jamespreedy · 2023-12-19T13:58:21.723Z

Hi folks,

I’m pushing a little data from HASS to OEM using the Emoncms History integration.

Emoncms History

Instructions on how to integrate Emoncms history into Home Assistant.

I can’t see in the documentation how you would push data to two different hosts.
I’m trying to push to my local emonHP Pi, as well as to the emoncms.org host.

Has anyone been able to do this please?
Example yaml below for a single connection, wondering if anyone has similar for 2x.

Thanks in advance!

# Example configuration.yaml entry
emoncms_history:
  api_key: YOUR_EMONCMS_WRITE_API_KEY
  url: https://emoncms.org
  inputnode: 19
  whitelist:
    - sensor.owm_temperature
    - sensor.owm_wind_speed

LeiChat · 2023-12-19T16:12:36.895Z

Someone will hopefully correct me if I am wrong, but I think you would/could import to your local using the Home Assistant Emoncms History integration and then configure that local Emoncms to publish the input/feed to the cloud hosted instance.

Download or upload emoncms feed data between local and remote emoncms server’s (github.com)

jamespreedy · 2023-12-19T16:35:51.565Z

@LeiChat - Thats a cracking idea - didn’t think of it at all, thank you!!

LeiChat · 2023-12-20T10:56:23.222Z

How did you get on? I suspect I have given bogus advice.

I added a couple of feeds in the local sync last night but looking at the cloud instance, they haven’t updated since I last clicked the “Upload” button.

image2239×210 31 KB

image2361×935 135 KB

jamespreedy · 2023-12-20T23:13:40.018Z

Not so well sadly … I made the changes and saw my data flow to emoncms from my local host. I celebrated, and then realised a day later that it seemed to be a one time thing. I’m able to press the button and see the data push to the remote host again, my I’ve not found a permanent solution as yet …

LeiChat · 2023-12-23T19:19:43.306Z

Hi. I think we need to amend the emonHub configuration to include the additional feeds.

emonHub Configuration File — OpenEnergyMonitor 0.0.1 documentation

KnightPhoenix · 2023-12-23T21:14:34.815Z

The Sync tab in the web interface is a one time fire and forget.

To setup a periodic sync you’ll need to setup a cron tab (on the ssh interface) .

Use putty to connect to emonhp.local (or the ip address of your instance)
default username is pi and default password is on the paperwork that came with the unit.

then type

crontab -e

at the bottom of the file add the below line

*/5 * * * * php /opt/emoncms/modules/sync/sync_upload.php

This will upload the data to emoncms every 5 minutes.

Let me know if this helps

jamespreedy · 2023-12-23T22:00:21.517Z

@KnightPhoenix - works an absolute treat - thank you so much!
Have a lovely festive period and a happy new year!

LeiChat · 2024-01-06T10:13:16.854Z

@KnightPhoenix I had it working for a while but think I’ve done something to bugger it up.

heatpump_targetT is synchronising OK but heatpump_dhw is missing data.

Cloud:

image1397×699 52.6 KB

Local:

image1388×612 45.1 KB

Cloud Feed with the ‘missing date’ checked

image2241×1323 201 KB

Last few days, I have been using the ‘Import data’ feature at the bottom of the Feeds to populate the missing data for the heatpump_dhw feed.

The light blue DHW graph shading doesn’t show in my local heatpump app, perhaps it’s running an older version than is on the cloud.

I do not seem to be missing data locally, it’s coming over from Home Assistant.

image2238×1229 200 KB

KnightPhoenix · 2024-01-06T11:01:00.020Z

First thing to do is to go and check the schedule on the Cron job. This needs to be completed from ssh.

You can also check for any errors in the emoncms logs from the web interface.

LeiChat · 2024-01-06T18:37:35.212Z

Thank you. I tried a Full Update from the Admin > Update menu and that seems to have sorted everything. I can see the Space/DHW split in the app and the heatpump_dhw feed is synchronising in time with the others.

LeiChat · 2024-01-07T09:19:58.221Z

Maybe I was wrong about that fixing the upload. There was no data for heatpump_dhw from 10am yesterday when I checked this morning. I’ve checked the crontab and that looks fine for the every five minutes schedule. The other three feeds (house_temperature, outdoor_temperature and heatpump_targetT) are still uploading fine.

Is it the emonHub.log I’m looking for issues in?
emonhub.log.txt (204.2 KB)

I’m able to grab the CSV data for heatpump_dhw from my local instance and use the “Import data” feature on emoncms.org to catch things up, but as you can see in the attached screenshot below, it’s not receiving/processing the heatpump_dhw since I did the manual upload at around 08:45.

image2234×1148 189 KB

EDIT: Just had a thought… the other three all have a ‘unit’ specified for the feed. But on my local instance and emoncms I do not have a unit specified for heatpump_dhw. Wasn’t sure what to select as it’s a boolean 1/0 value. Should I try “Other” ?

image1060×1288 94 KB

borpin · 2024-01-08T11:27:38.948Z

A post was split to a new topic: Sync Issues

LeiChat · 2024-01-08T13:02:53.140Z

Thanks for splitting it. Apologies to jamespreedy for any notifications.

TrystanLea · 2024-08-21T17:21:00.264Z

KnightPhoenix:

To setup a periodic sync you’ll need to setup a cron tab (on the ssh interface) .

A quick related note to say that there is a new version of the sync module now available that does away with the crontab entry replacing it with a dedicated service that runs in the background alongside a more efficient upload process, release post available here: Emoncms Sync module v3.x.x