Hello - I’m running an emonpi install and using it to log my OpenEVSE and some current clamps I have on the house power. Working well (I had tried setting up a FAMP server, but weird problems were making me crazy, plus emonpi is just so nice and packaged)
Here’s my problem… Last month some wonky data came out of my current meter for reasons that have been corrected. However, I now have points in my data that are many orders of magnitude higher than what they ought to be, and it’s completely trashing my views (because of the zoom) and causing havoc with my historical data. Is there any way I can go in and scrub the insanely high values out of the database?
I guess I could directly edit the SQL database? Any suggestions on that tip? I imagine that I’d need to set permission for remote access and use MySql Workbench on another machine…
Or maybe write a post processor script that would set any values over… say… 1000 kwh a day and set them to zero? Maybe this already exists?
I’d appreciate any suggestions as to how I could attack this problem.