Menu Close

Just upgrade from Emoncms v3 to Emoncms v5

My Electric

 

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.

 

 

 

Posted in Domotica e Cloud, News

21 Comments

  1. website designer

    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.

  2. websites

    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.

    • Leen15

      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 🙂

  3. search engine marketing llc

    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!

  4. I was reading this

    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!

    • Leen15

      Hi, i recently change from joomla to wordpress, maybe you’ve visited the old version of my blog!

  5. seo

    Appreciation to my father who stated to me on the topic
    of this webpage, this weblog is truly amazing.

    • Leen15

      I execute these commands every 2-3 days and delete records result from them. This keeps my data clean.

  6. Pat

    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.

Leave a Reply

Your e-mail address will not be published. Required fields are marked *