Using software by writing data to mysql DB directly

Hello - 

I am very interested in this software but currently the only way I have to monitor my PV array is via a Enphase Envoy ENV-120-01. This unit stores data offsite that is then available to me via an API. 

I was hoping to write some php scripts to pull this data and drop it into a MySQL DB for use by EmonCMS but I could not find any documentation on using the system sans hardware sensors.

Please advise.

Many Thanks

TrystanLea's picture

Re: Using software by writing data to mysql DB directly

Hello rjsears, If you login to emoncms and navigate to the input page, there's a link to the API helper which lists the emoncms input API to which you could forward the data read in your php script with a http request.

rjsears's picture

Re: Using software by writing data to mysql DB directly

Thanks! Got it installed and will start playing with it.

rjsears's picture

Re: Using software by writing data to mysql DB directly

OK, all up and running. Went to the Input section you described, and I see a lot of ways to POST data to the system, but does the system provide any way to (scheduled or otherwise) reach out and grab data from another system?

For example, the manufacturer of my monitoring equuipment provides an API that I have to hit with curl (or a web browser) passing an API key, user_id and system_id and then it send me back whatever report that I requested. 

How would I go about getting this information into Emoncms?

TrystanLea's picture

Re: Using software by writing data to mysql DB directly

Emoncms doesnt have the ability to make a scheduled request - there would be a lot of problems with this, different equipment api's by monitoring manufacturers etc but this is what you could build into your php script, the first half could make a curl request to the system you want to poll data from and then second part would then send that data in the right format to the emoncms api.

This is a good example of this that we use for creating our ukgrid visualisation:

https://github.com/TrystanLea/ukgrid/blob/master/cron.php

Its not actually sending data to the emoncms api more a very lighweight custom design I put together for that application but the principle is the same.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.