The new Emoncms v5 is great!
I had a bit of difficult during migration, but after that the result is fine!
This is new Report module of emoncms5 and it’s very helpful !
During migration i wrote some query for check the data integrity:
Extract double records from feed_3 (histogram table):
SELECT * FROM feed_3 as A WHERE EXISTS ( SELECT 1 FROM feed_3 AS B WHERE A.time = B.time AND A.data = B.data AND A.data2 = B.data2 GROUP BY B.time, B.data, B.data2 HAVING COUNT(*) > 1 ) LIMIT 0 , 30
This query is helpful for check that Report module doesn’t give wrong results.
Extract double records from feed_2 (kwh/d table):
SELECT * FROM feed_2 AS A WHERE EXISTS ( SELECT 1 FROM feed_2 AS B WHERE A.time = B.time AND A.data = B.data GROUP BY B.time, B.data HAVING COUNT( * ) >1 ) LIMIT 0 , 30
Emoncms3 sometimes wrote double records for the same day, this query can show you what days are double.