Emoncms.org feed on PVOutput

[nfreitas]

I’ve my feed on emoncms.org
https://goo.gl/L5u9Lq

How can I autoupload the data to PVOutput?

Thanks

[bankstownbloke]

If they provide an API to download data, then it might be possible.

[nfreitas]

Any update on this request?

[bankstownbloke]

https://emoncms.org/site/api#feed

You’ll need to obtain a read apikey from emoncm and send to pvoutput@gmail.com to see if an Auto Uploader can be developed.

[adrian-jas-smith]

I also have an emonpi (a raspberry pi) feeding an emoncms.org solar/consumption account; as well as an EW4009 Watts Clever solar/consumption system feeding a pvoutput.org account, using the PV Bean Counter software (using a Windows XP VM on Linux).
https://pvoutput.org/intraday.jsp?id=22129&sid=20013&dt=20170915&gs=0&m=1

The problem I have at present is that my solar is registered as consumption on pvoutput.org, because the Watts Clever EW4009 / PV Bean Counter software does not distinguish import/export.

Where as the emonpi and emoncms.org is able to record import/export correctly in its hardware method.

I have been wanting to change this dual system to a single monitoring system for some time now using only the emonpi feeding both emoncms,org and pvoutput.org.

Today I subscribed to this community, and I came across this post on your forum:

Upload emonpi data (perl script)

This is a really basic script to send my household consumption and voltage data to pvoutput. It sends data with a 15 minute delay to allow the solar data (in my case from the Enphase auto feed) to get fed first. If you don't and don't have a donation / sponsored account things go wrong - it's documented, but I forget where. After editing the access keys and feed IDs, run this every 5 minutes out of cron. You will also get the requests written to the log file so it can be replayed if something …

I may try to use/modify this perl script and install it on the emonpi to update pvoutput.org.

I also came across your software: org.pvoutput.integration.v1.5.0.1.zip at:
https://bitbucket.org/pvoutput/pvoutput-integration-service/downloads/
and I now see that it can be installed on Linux (which is my preferred method),
so I may try installing, and using this on my Linux home server; or on the emonpi system.

I use an enasolar inverter, and have an import/export smart meter; which I can only read manually at my house, or use the power company website to see my consumption and solar export data.

Maybe you could create a pvoutput updater using the above perl script that can then be installed on the emonpi raspberry pi (also a Linux system)?

This would then be able to be installed by any emonpi user(s), and allow them to send their consumption/solar data to pvoutput.org as well as to emoncms.org.
Thanks, for all your work on pvoutput.org, and the various uploaders that you have provided.

[MK_Solar]

Are you running EmonSD / NodeRed on a Raspberry Pi by any chance?
If so, I’ve written a NodeRed flow to take the MQTT data and upload it directly to PVOutput.org if you are.
It’s been running for several months and after much tweaking seems pretty solid now.

[adrian-jas-smith]

I am using an older (April2015) emonBase (standard rasp pi B+) with emonSD software, with an emonTX collector/transmitter. I am not running the newer emonpi, or NodeRed as far as i know.

I have not really touched the emonBase system for a long time now; it is very reliable; apart from a recent 26 hour ISP/Internet cable fault (van hit pole bringing down cable-TV and Internet for our area) so I was unable to send the 26 hours emonBase data to emoncms.org. Having a simple transaction log file available to me may have allowed me to update emoncms later?

This is one of the nice things that I like about pvoutput is that it allows you to manually feed .csv data to it via a simple web-page up-loader days after any data upload failures. I also use it to fix occasional unexplained spikes in my consumption graphs from time to time.

Would your software work, or adapt for me without me using NodeRed?

[MK_Solar]

I’m not sure if your version of EmonSD has NodeRed installed, if you try accessing http://:1880 or http://:1880/nodered to see if it’s there. My uploader code is written in NodeRed, so it’s not going to work with anything else.
You may be able to retrofit NR to your install, I stripped out the original version of NR and replaced it with latest version from their website in a few commands (needed the latest version for Alexa integration), or it might just be easier to upgrade to the latest version of EmonSD where it’s all installed for you. The code is just a cut’n’paste, then edit in the API key and give it test.

[jyan335pv]

Hi NFreitas:

I am seeing your post here. Can you share your NodeRed flow with me? I just recently setup a RaspberryPi and am trying to get things moved to PVOutput.

Thanks,

Jon