I am importing Octopus Agile data into EMONCMS into a PHPTimeseries feed directly. I have setup a dummy input and then created the feed from it. ( I am bulk loading data in the future so I can see the price changes during the day )
I am using -
http://xxx.xxx.xxx.xxx/emoncms/feed/insert.json?id=44&time=" + timevalue[i] + "&value=" + costvalue[i] + "&apikey=....
timevalue is unixtime and UTC.
importing via a python script using requests.
It loads directly into the feed fine.
The csv output from the feed ( via the graph) compared with the raw input from Agile shows ( a sample ) -
CSV Output from feed raw output from Agile
2020-06-03 14:00:00 4.9 2020-06-03T14:00:00Z 4.893
2020-06-03 14:30:00 5.3 2020-06-03T14:30:00Z 5.292
2020-06-03 15:00:00 17.5 2020-06-03T15:00:00Z 17.472 16:00 in Agile app
2020-06-03 15:30:00 18.2 2020-06-03T15:30:00Z 18.228
2020-06-03 16:00:00 18.7 2020-06-03T16:00:00Z 18.69
2020-06-03 16:30:00 20.1 2020-06-03T16:30:00Z 20.055
2020-06-03 17:00:00 20.1 2020-06-03T17:00:00Z 20.097
2020-06-03 17:30:00 20.1 2020-06-03T17:30:00Z 20.097
2020-06-03 18:00:00 7.3 2020-06-03T18:00:00Z 7.2765
2020-06-03 18:30:00 6.8 2020-06-03T18:30:00Z 6.8355
The graph display is showing in UTC zone but the Agile App is showing in BST zone.
When I import via the input ( every 30 minutes in the past) Emoncms appears to convert to BST - so is this happening in the logic between an input and a feed?
Any advice on what I should do - should I convert prior to loading into the feed? I want to input values in the future not in the past hence the input field does not really work for me.