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 , 30This 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 , 30Emoncms3 sometimes wrote double records for the same day, this query can show you what days are double.
Paragraph writing is also a fun, if you be acquainted with afterward you can write if not it is complex to write.
Hey I know this is off topic but I was wondering if you knew of any widgets
I could add to my blog that automatically tweet my newest twitter updates.
I’ve been looking for a plug-in like this for quite some time and was hoping maybe you would have some experience with something like this. Please let me know if you run into anything. I truly enjoy reading your blog and I look forward to your new updates.
Hey, I’m new with wordpress, but exists lots of widget that can do what you need! Take a look at http://wordpress.org/extend/plugins/tags/twitter
Because the admin of this site is working, no uncertainty very rapidly it will be well-known, due to its feature contents.
Hi, I do believe this is an excellent web site. I stumbledupon it 😉 I may return
yet again since i have book marked it. Money and freedom is the best way to change, may you be
rich and continue to help other people.
Thanks a lot! I hope that my blog can help other people with my same issues!
When i find a solution of something, or something that i think could be helpful, i add it to my blog 🙂
Thanks very nice blog!
thank you 🙂
Good day! I could have sworn I’ve been to this blog before but after going through some of the posts I realized it’s new
to me. Regardless, I’m definitely pleased I discovered it and I’ll be bookmarking it and checking back often!
Nice to be in your bookmarks!
Hello to every one, it’s actually a pleasant for me to go to see this web site, it includes priceless Information.
Thanks 🙂
Hi! I could have sworn I’ve visited this site before but after browsing through many of the posts I realized it’s new to me.
Anyways, I’m certainly delighted I came across it and I’ll be bookmarking it and checking back often!
Hi, i recently change from joomla to wordpress, maybe you’ve visited the old version of my blog!
This is a topic that is close to my heart… Best wishes! Exactly where are your
contact details though?
Hey, Thanks!
I still didn’t add a “contact me” page, but you can contact me with twitter (see at the right of the page) or with G+ ( https://plus.google.com/117675149173574759897/)
Appreciation to my father who stated to me on the topic
of this webpage, this weblog is truly amazing.
Thanks a lot 🙂
Fastidious answer back in return of this query with genuine arguments and
explaining all about that.
I execute these commands every 2-3 days and delete records result from them. This keeps my data clean.
Aw, this was a very nice post. Spending some time and actual effort to create a great
article… but what can I say… I procrastinate a lot and don’t manage to get anything done.