Hi,
I have been using emoncms.org for recording live data from a number of community solar projects for nearly 12 months and it has been working perfectly. We use our own hardware for the monitoring and it is first sent to our linode server and then pushed to the emoncms inputs using the API key. Thank you to everyone here who helps make it possible.
However we now need to log data from a different sort of meter which records half hourly kWh data for 24 hours and then sends a single .csv file to us via ftp.
We would like the (timestamped) half hourly data to be logged in emoncms.org which would be updated daily (at slightly different times each day).
We have tried to restructure the data to send to emoncms using the code below. It works to the extent that new inputs are being created but the data does not seem to actually be recorded by emoncms. We have tried using both PHPFina and PHP timeseries for logging the feeds.
I have read through this thread but there doesn’t seem to be a solution for emoncms.org: Uploading historic data - #12 by thundersun
The is the code we are using:
curl -g ‘https://www.emoncms.org/input/bulk.json?data=[[0,18,0.0]]&time=1508279400&apikey=74b7a699ba984a9a20c0ba3a7e2e4b31’
curl -g ‘https://www.emoncms.org/input/bulk.json?data=[[0,18,0.0]]&time=1508281200&apikey=74b7a699ba984a9a20c0ba3a7e2e4b31’
curl -g ‘https://www.emoncms.org/input/bulk.json?data=[[0,18,0.0]]&time=1508283000&apikey=74b7a699ba984a9a20c0ba3a7e2e4b31’
curl -g ‘https://www.emoncms.org/input/bulk.json?data=[[0,18,0.0]]&time=1508284800&apikey=74b7a699ba984a9a20c0ba3a7e2e4b31’
from a linux command line
[0,18,0.0] 0 is the time offset, 18 is the node and 0.0 is the value
time=1508284800 is the linux time associated with the data point.
there are 18*48 of these lines sent up for 18 meters and 48 timestamps
I can send the raw .csv if that is helpful.
Thank you in advance,
Felix