Exported data wrong

JaBK · 2018-03-07T09:21:14.476Z

My arduino uno sends data from my energy meter (counting pulses) to emoncms every minute. Or to be more precise, when the next pulse occurs after 1 minute. The sum of kWh on emoncms is correct (daily use). But when I try to export it to CVS for further analasys, the sum is not correct anymore. I get the best results if I choose 10s interval, but the sum of kWh is stil a few percent off.

Why is that happening and is there a solution?

JaBK · 2018-03-07T11:04:02.801Z

I see, there is already somebody with the same problem:

Missing data points in CSV export Emoncms

Using: vlow-write-v8.5 hosted locally on my emonPi with firmware emonPi_RFM69CW_RF12Demo_DiscreteSampling.ino from SD image from 17 Jun 2015 When I export data from one of my feeds (CT1 watts, fixed interval, no averaging PHPFINA, 10 second intervals), outputting the CSV data for every minute, the data has gaps in it every so often. In the CSV export interface, I enter the following data for export: Start date and time: 02/08/2016 18:30:00 End date and time: 11/08/2016 11:00:00 Interval: 1 …

That is my problem…

TrystanLea · 2018-03-07T17:46:45.304Z

Hello @JaBK

Can you attach a screenshot of what your data looks like? how many gaps do you see?

You could use the wh_accumulator process which will join across gaps, which may solve your problem. You could keep both your current approach and add a wh_accumulator to test if you like.

JaBK · 2018-03-09T08:34:28.091Z

This is correct:

USE%20TODAY1323×703 26.4 KB

This is what I get, when I export data choosing 10s interval (daily sum is in the red square):

10S%20INTERVAL479×608 16.9 KB

This is what I get when I export data choosing 1min interval:

1MIN%20INTERVAL451×596 15.7 KB

How do I set up wh- accumulator? what does it do?