EventGhost

Support Forum
http://www.eventghost.net:80/forum/

ClimateDataCalculation

http://www.eventghost.net:80/forum/viewtopic.php?t=6363

Page 3 of 37

Re: ClimateDataCalculation

Posted: Wed Dec 03, 2014 3:31 pm
by krambriw
Updated actions so that you can set the report file name. To upgrade existing report generating actions, I think you just have to open, set the name and save configuration for those again (before you run them). Do not add .html to the name, it is done by the action. See sample picture below.
You find the new version in the normal place: http://sto.hopto.org/Under%20constructi ... lculation/

The error message is coming from the webserver plugin, that I cannot do so much about but you can select a file name without special characters. Are you using the latest webserver plugin, I am and it works fine for me when I try with special characters in the file name.
Image1.jpg

Re: ClimateDataCalculation

Posted: Fri Dec 05, 2014 12:40 pm
by Mastiff
Thanks! Getting there. :) Everything starts falling into place, but I'm not really sure about the numbers on he graph. Ididn't see it until now because it hasn't rained for a while, but don't they look a bit exaggerated? Sort of "look for the old man with the boat and all the animals" exaggerated, I mean! ;)

Re: ClimateDataCalculation

Posted: Fri Dec 05, 2014 1:37 pm
by krambriw
Noah's...I see what you mean. Something in the db must be strange. I would expect you to see a graph showing the total accumulated rain per reading so to speak. It should have been a graph with a curve that was (hopefully) slowly increasing and not jumping like a tsunami

I think we need to look into your rain database to check what values you actually have stored. Try the below script and publish a few lines here around the critical point where your graph is making the big jump.

I do not have a rain sensor myself any longer but typical structure of lines should be printed like this:

Code: Select all

14:34:35   (u'2014-11-15 08:27:56', 1416036477, u'RainSensor on roof', 10, 8, 0, u'fMov == sMov')
14:34:35   (u'2014-11-15 08:47:24', 1416037645, u'RainSensor on roof', 10, 33, 0, u'fMov == sMov')
14:34:35   (u'2014-11-16 12:41:38', 1416138098, u'RainSensor on roof', 10, 59, 0, u'fMovAverage == sMovAverage')
The Total rain value is 8, 33, 59

In the script below, just change the name 'RainSensor on roof' to your table name

BR

Code: Select all

import sqlite3

def GetAllData(
    dbName, 
    dbTableId
):
    dbName = str(dbName)
    conn = sqlite3.connect(dbName)
    c = conn.cursor()
    t = ((dbTableId),)
    try:
        c.execute('SELECT * FROM '+dbName.split('.')[0]+' WHERE tableId=?', t)
        coll = c.fetchall()
        conn.close()
        return coll
    except:
        conn.close()
        return None

rows = GetAllData('rainData.db', 'RainSensor on roof')

for row in rows:
    print row

Re: ClimateDataCalculation

Posted: Fri Dec 05, 2014 3:02 pm
by Mastiff
Sorry, but that just gave an error message. The å in "Regnmåler", perhaps?

Code: Select all

16:01:26      Traceback (most recent call last):
16:01:26        Python script "45", line 22, in <module>
16:01:26          for row in rows:
16:01:26      TypeError: 'NoneType' object is not iterable

Re: ClimateDataCalculation

Posted: Fri Dec 05, 2014 3:31 pm
by krambriw
Of course, could you change the line nbr 10 as follows

Code: Select all

    t = ((dbTableId.decode('utf-8')),)

Re: ClimateDataCalculation

Posted: Fri Dec 05, 2014 7:17 pm
by Mastiff
Yep, that worked. Here's something I think will be in the area. Is that right?

Code: Select all

20:16:00      (u'2014-11-30 23:29:05', 1417386546, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-11-30 23:40:50', 1417387251, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-11-30 23:51:01', 1417387862, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 00:01:12', 1417388473, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 00:12:57', 1417389178, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 00:26:16', 1417389977, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 00:36:27', 1417390588, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 00:51:20', 1417391481, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 01:02:19', 1417392139, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 01:12:30', 1417392750, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 01:31:18', 1417393878, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 01:42:16', 1417394536, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 01:53:14', 1417395194, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 02:08:07', 1417396087, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 02:19:52', 1417396792, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 02:30:50', 1417397450, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 02:42:35', 1417398155, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 02:52:46', 1417398766, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 03:02:57', 1417399377, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 03:14:42', 1417400082, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 03:26:27', 1417400787, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 03:36:38', 1417401398, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 03:49:10', 1417402150, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 04:04:03', 1417403043, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 04:14:14', 1417403654, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 04:25:59', 1417404359, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 04:36:10', 1417404970, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 04:47:08', 1417405628, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 04:58:53', 1417406333, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 05:09:04', 1417406944, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 05:19:15', 1417407555, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 05:31:00', 1417408260, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 05:43:32', 1417409012, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 05:53:43', 1417409624, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 06:05:28', 1417410329, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 06:15:39', 1417410940, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 06:25:50', 1417411551, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 06:37:35', 1417412256, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 06:48:33', 1417412914, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 07:00:18', 1417413619, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 07:11:16', 1417414277, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 07:21:27', 1417414888, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 07:32:25', 1417415546, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 07:43:23', 1417416204, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 07:53:34', 1417416815, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 08:04:32', 1417417473, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 08:18:38', 1417418319, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 08:28:49', 1417418930, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 08:40:34', 1417419635, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 08:50:45', 1417420246, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 09:01:43', 1417420904, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 09:12:41', 1417421562, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 09:22:52', 1417422173, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 09:33:50', 1417422831, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 09:45:35', 1417423536, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 09:55:46', 1417424147, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 10:06:44', 1417424805, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 10:17:42', 1417425463, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 10:27:53', 1417426074, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 10:38:04', 1417426685, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 10:49:02', 1417427343, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 11:00:00', 1417428001, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 11:10:58', 1417428659, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 11:21:10', 1417429270, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 11:32:08', 1417429928, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 11:42:19', 1417430539, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 11:52:30', 1417431150, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 12:03:28', 1417431808, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 12:13:39', 1417432419, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 12:23:50', 1417433030, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 12:34:01', 1417433641, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 12:44:12', 1417434252, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 12:55:10', 1417434910, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 13:05:21', 1417435521, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 13:15:32', 1417436132, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 13:25:43', 1417436743, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 13:35:54', 1417437354, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 13:46:05', 1417437965, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 13:56:16', 1417438576, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 14:06:27', 1417439187, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 14:16:38', 1417439798, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 14:26:49', 1417440409, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 14:37:47', 1417441067, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 14:47:58', 1417441678, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 14:58:09', 1417442289, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 15:08:20', 1417442900, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 15:18:31', 1417443511, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 15:29:29', 1417444169, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 15:39:40', 1417444780, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 15:49:51', 1417445391, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 16:00:49', 1417446049, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 16:11:00', 1417446660, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 16:21:58', 1417447319, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 16:33:43', 1417448024, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 16:45:28', 1417448729, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 16:55:39', 1417449340, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 17:05:50', 1417449951, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 17:16:01', 1417450562, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 17:26:59', 1417451220, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 17:37:10', 1417451831, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 17:47:21', 1417452442, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 17:57:32', 1417453053, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 18:07:43', 1417453664, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 18:17:54', 1417454275, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 18:28:52', 1417454933, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 18:39:03', 1417455544, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 18:50:48', 1417456249, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 19:00:59', 1417456860, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 19:11:57', 1417457518, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 19:22:55', 1417458176, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 19:35:27', 1417458928, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 19:47:12', 1417459633, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 19:57:23', 1417460244, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 20:08:21', 1417460902, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 20:18:32', 1417461513, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 20:28:44', 1417462124, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 20:38:54', 1417462735, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 20:49:05', 1417463346, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 21:01:37', 1417464098, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 21:11:49', 1417464709, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 21:22:00', 1417465320, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 21:32:58', 1417465978, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 21:43:09', 1417466589, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 21:53:20', 1417467200, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 22:04:18', 1417467858, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 22:14:29', 1417468469, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 22:24:40', 1417469080, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 22:34:51', 1417469691, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 22:45:02', 1417470302, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 22:55:13', 1417470913, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 23:07:45', 1417471665, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 23:19:30', 1417472370, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 23:30:28', 1417473028, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 23:40:39', 1417473639, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-01 23:51:37', 1417474297, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 00:01:48', 1417474908, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 00:11:59', 1417475519, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 00:22:10', 1417476130, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 00:32:21', 1417476741, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 00:42:32', 1417477352, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 00:53:30', 1417478010, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 01:06:02', 1417478762, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 01:20:08', 1417479608, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 01:30:19', 1417480219, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 01:41:17', 1417480877, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 01:51:28', 1417481488, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 02:03:13', 1417482194, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 02:14:11', 1417482852, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 02:24:22', 1417483463, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 02:36:54', 1417484215, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 02:47:52', 1417484873, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 02:58:03', 1417485484, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 03:09:01', 1417486142, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 03:19:59', 1417486800, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 03:31:44', 1417487505, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 03:42:42', 1417488163, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 03:52:53', 1417488774, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 04:03:51', 1417489432, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 04:14:02', 1417490043, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 04:24:13', 1417490654, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 04:37:32', 1417491453, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 04:47:43', 1417492064, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 04:57:54', 1417492675, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 05:08:05', 1417493286, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 05:18:16', 1417493897, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 05:33:09', 1417494790, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 05:43:20', 1417495401, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 05:56:39', 1417496200, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 06:09:58', 1417496999, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 06:24:04', 1417497845, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 06:34:15', 1417498456, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 06:44:27', 1417499067, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 06:56:59', 1417499819, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 07:07:57', 1417500477, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 07:18:08', 1417501088, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 07:29:53', 1417501793, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 07:41:38', 1417502498, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 07:53:23', 1417503203, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 08:05:08', 1417503908, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 08:18:27', 1417504707, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 08:30:12', 1417505412, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 08:41:57', 1417506117, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 08:52:08', 1417506728, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 09:03:06', 1417507386, u'Regnm\xe5ler', 0, 1676624, 0, u'')
20:16:00      (u'2014-12-02 09:14:04', 1417508044, u'Regnm\xe5ler', 0, 1676774, 150, u'')
20:16:00      (u'2014-12-02 09:25:02', 1417508702, u'Regnm\xe5ler', 0, 1676774, 0, u'')
20:16:00      (u'2014-12-02 09:35:13', 1417509313, u'Regnm\xe5ler', 0, 1676924, 150, u'')
20:16:00      (u'2014-12-02 09:45:24', 1417509924, u'Regnm\xe5ler', 0, 1676924, 0, u'')
20:16:00      (u'2014-12-02 09:55:35', 1417510535, u'Regnm\xe5ler', 0, 1677074, 150, u'')
20:16:00      (u'2014-12-02 10:06:33', 1417511193, u'Regnm\xe5ler', 0, 1677074, 0, u'')
20:16:00      (u'2014-12-02 10:16:44', 1417511804, u'Regnm\xe5ler', 0, 1677224, 150, u'')
20:16:00      (u'2014-12-02 10:26:55', 1417512415, u'Regnm\xe5ler', 0, 1677224, 0, u'')
20:16:00      (u'2014-12-02 10:37:06', 1417513026, u'Regnm\xe5ler', 0, 1677374, 150, u'')
20:16:00      (u'2014-12-02 10:48:04', 1417513685, u'Regnm\xe5ler', 0, 1677374, 0, u'')
20:16:00      (u'2014-12-02 10:58:15', 1417514295, u'Regnm\xe5ler', 0, 1677524, 150, u'')
20:16:00      (u'2014-12-02 11:08:26', 1417514907, u'Regnm\xe5ler', 0, 1677524, 0, u'')
20:16:00      (u'2014-12-02 11:18:37', 1417515518, u'Regnm\xe5ler', 0, 1677674, 150, u'')
20:16:00      (u'2014-12-02 11:30:22', 1417516223, u'Regnm\xe5ler', 0, 1677674, 0, u'')
20:16:00      (u'2014-12-02 11:41:20', 1417516881, u'Regnm\xe5ler', 0, 1677824, 150, u'')
20:16:00      (u'2014-12-02 11:51:31', 1417517492, u'Regnm\xe5ler', 0, 1677824, 0, u'')
20:16:00      (u'2014-12-02 12:02:29', 1417518150, u'Regnm\xe5ler', 0, 1677974, 150, u'')
20:16:00      (u'2014-12-02 12:12:40', 1417518761, u'Regnm\xe5ler', 0, 1677974, 0, u'')
20:16:00      (u'2014-12-02 12:25:12', 1417519513, u'Regnm\xe5ler', 0, 1678124, 150, u'')
20:16:00      (u'2014-12-02 12:36:10', 1417520171, u'Regnm\xe5ler', 0, 1678124, 0, u'')
20:16:00      (u'2014-12-02 12:47:55', 1417520876, u'Regnm\xe5ler', 0, 1678274, 150, u'')
20:16:00      (u'2014-12-02 12:58:06', 1417521487, u'Regnm\xe5ler', 0, 1678274, 0, u'')
20:16:00      (u'2014-12-02 13:08:17', 1417522098, u'Regnm\xe5ler', 0, 1678424, 150, u'')
20:16:00      (u'2014-12-02 13:21:36', 1417522897, u'Regnm\xe5ler', 0, 1678424, 0, u'')
20:16:00      (u'2014-12-02 13:31:47', 1417523508, u'Regnm\xe5ler', 0, 1678574, 150, u'')
20:16:00      (u'2014-12-02 13:42:46', 1417524166, u'Regnm\xe5ler', 0, 1678574, 0, u'')
20:16:00      (u'2014-12-02 13:56:51', 1417525012, u'Regnm\xe5ler', 0, 1678724, 150, u'')
20:16:00      (u'2014-12-02 14:07:02', 1417525623, u'Regnm\xe5ler', 0, 1678724, 0, u'')
20:16:00      (u'2014-12-02 14:17:13', 1417526234, u'Regnm\xe5ler', 0, 1678874, 150, u'')
20:16:00      (u'2014-12-02 14:27:24', 1417526845, u'Regnm\xe5ler', 0, 1678874, 0, u'')
20:16:00      (u'2014-12-02 14:37:35', 1417527456, u'Regnm\xe5ler', 0, 1679024, 150, u'')
20:16:00      (u'2014-12-02 14:49:20', 1417528161, u'Regnm\xe5ler', 0, 1679024, 0, u'')
20:16:00      (u'2014-12-02 14:59:31', 1417528772, u'Regnm\xe5ler', 0, 1679174, 150, u'')
20:16:00      (u'2014-12-02 15:09:42', 1417529383, u'Regnm\xe5ler', 0, 1679174, 0, u'')
20:16:00      (u'2014-12-02 15:20:40', 1417530041, u'Regnm\xe5ler', 0, 1679324, 150, u'')
20:16:00      (u'2014-12-02 15:30:51', 1417530652, u'Regnm\xe5ler', 0, 1679324, 0, u'')
20:16:00      (u'2014-12-02 15:41:03', 1417531263, u'Regnm\xe5ler', 0, 1679474, 150, u'')
20:16:00      (u'2014-12-02 15:52:01', 1417531921, u'Regnm\xe5ler', 0, 1679474, 0, u'')
20:16:00      (u'2014-12-02 16:02:12', 1417532532, u'Regnm\xe5ler', 0, 1679624, 150, u'')
20:16:00      (u'2014-12-02 16:13:57', 1417533237, u'Regnm\xe5ler', 0, 1679624, 0, u'')
20:16:00      (u'2014-12-02 16:24:55', 1417533895, u'Regnm\xe5ler', 0, 1679774, 150, u'')
20:16:00      (u'2014-12-02 16:35:06', 1417534506, u'Regnm\xe5ler', 0, 1679774, 0, u'')
20:16:00      (u'2014-12-02 16:48:25', 1417535305, u'Regnm\xe5ler', 0, 1679924, 150, u'')
20:16:00      (u'2014-12-02 16:58:36', 1417535916, u'Regnm\xe5ler', 0, 1679924, 0, u'')
20:16:00      (u'2014-12-02 17:09:34', 1417536574, u'Regnm\xe5ler', 0, 1680074, 150, u'')
20:16:00      (u'2014-12-02 17:19:45', 1417537185, u'Regnm\xe5ler', 0, 1680074, 0, u'')
20:16:00      (u'2014-12-02 17:32:17', 1417537937, u'Regnm\xe5ler', 0, 1680224, 150, u'')
20:16:00      (u'2014-12-02 17:42:28', 1417538548, u'Regnm\xe5ler', 0, 1680224, 0, u'')
20:16:00      (u'2014-12-02 17:52:39', 1417539159, u'Regnm\xe5ler', 0, 1680374, 150, u'')
20:16:00      (u'2014-12-02 18:02:50', 1417539770, u'Regnm\xe5ler', 0, 1680374, 0, u'')
20:16:00      (u'2014-12-02 18:13:01', 1417540381, u'Regnm\xe5ler', 0, 1680524, 150, u'')
20:16:00      (u'2014-12-02 18:23:12', 1417540992, u'Regnm\xe5ler', 0, 1680524, 0, u'')
20:16:00      (u'2014-12-02 18:33:23', 1417541604, u'Regnm\xe5ler', 0, 1680674, 150, u'')
20:16:00      (u'2014-12-02 18:43:34', 1417542214, u'Regnm\xe5ler', 0, 1680674, 0, u'')
20:16:00      (u'2014-12-02 18:56:06', 1417542966, u'Regnm\xe5ler', 0, 1680824, 150, u'')
20:16:00      (u'2014-12-02 19:07:04', 1417543624, u'Regnm\xe5ler', 0, 1680824, 0, u'')
20:16:00      (u'2014-12-02 19:18:49', 1417544329, u'Regnm\xe5ler', 0, 1680974, 150, u'')
20:16:00      (u'2014-12-02 19:29:47', 1417544987, u'Regnm\xe5ler', 0, 1680974, 0, u'')
20:16:00      (u'2014-12-02 19:39:58', 1417545598, u'Regnm\xe5ler', 0, 1681124, 150, u'')
20:16:00      (u'2014-12-02 19:50:09', 1417546209, u'Regnm\xe5ler', 0, 1681124, 0, u'')
20:16:00      (u'2014-12-02 20:01:54', 1417546915, u'Regnm\xe5ler', 0, 1681274, 150, u'')
20:16:00      (u'2014-12-02 20:12:05', 1417547526, u'Regnm\xe5ler', 0, 1681274, 0, u'')
20:16:00      (u'2014-12-02 20:22:16', 1417548137, u'Regnm\xe5ler', 0, 1681424, 150, u'')
20:16:00      (u'2014-12-02 20:32:27', 1417548748, u'Regnm\xe5ler', 0, 1681424, 0, u'')
20:16:00      (u'2014-12-02 20:42:38', 1417549359, u'Regnm\xe5ler', 0, 1681574, 150, u'')
20:16:00      (u'2014-12-02 20:59:05', 1417550346, u'Regnm\xe5ler', 0, 1681574, 0, u'')
20:16:00      (u'2014-12-02 21:16:19', 1417551380, u'Regnm\xe5ler', 0, 1681724, 150, u'')
20:16:00      (u'2014-12-02 21:26:30', 1417551991, u'Regnm\xe5ler', 0, 1681724, 0, u'')
20:16:00      (u'2014-12-02 21:37:28', 1417552649, u'Regnm\xe5ler', 0, 1681874, 150, u'')
20:16:00      (u'2014-12-02 21:47:39', 1417553260, u'Regnm\xe5ler', 0, 1681874, 0, u'')
20:16:00      (u'2014-12-02 21:58:37', 1417553918, u'Regnm\xe5ler', 0, 1682024, 150, u'')
20:16:00      (u'2014-12-02 22:08:48', 1417554529, u'Regnm\xe5ler', 0, 1682024, 0, u'')
20:16:00      (u'2014-12-02 22:19:46', 1417555187, u'Regnm\xe5ler', 0, 1682174, 150, u'')
20:16:00      (u'2014-12-02 22:31:31', 1417555892, u'Regnm\xe5ler', 0, 1682174, 0, u'')
20:16:00      (u'2014-12-02 22:42:29', 1417556550, u'Regnm\xe5ler', 0, 1682324, 150, u'')
20:16:00      (u'2014-12-02 22:52:40', 1417557161, u'Regnm\xe5ler', 0, 1682324, 0, u'')
20:16:00      (u'2014-12-02 23:03:38', 1417557819, u'Regnm\xe5ler', 0, 1682474, 150, u'')
20:16:00      (u'2014-12-02 23:13:49', 1417558430, u'Regnm\xe5ler', 0, 1682474, 0, u'')
20:16:00      (u'2014-12-02 23:24:00', 1417559041, u'Regnm\xe5ler', 0, 1682624, 150, u'')
20:16:00      (u'2014-12-02 23:35:45', 1417559746, u'Regnm\xe5ler', 0, 1682624, 0, u'')
20:16:00      (u'2014-12-02 23:45:57', 1417560357, u'Regnm\xe5ler', 0, 1682774, 150, u'')
20:16:00      (u'2014-12-02 23:56:08', 1417560968, u'Regnm\xe5ler', 0, 1682774, 0, u'')
20:16:00      (u'2014-12-03 00:06:19', 1417561579, u'Regnm\xe5ler', 0, 1682924, 150, u'')
20:16:00      (u'2014-12-03 00:16:30', 1417562190, u'Regnm\xe5ler', 0, 1682924, 0, u'')
20:16:00      (u'2014-12-03 00:27:28', 1417562848, u'Regnm\xe5ler', 0, 1683074, 150, u'')
20:16:00      (u'2014-12-03 00:37:39', 1417563459, u'Regnm\xe5ler', 0, 1683074, 0, u'')
20:16:00      (u'2014-12-03 00:47:50', 1417564070, u'Regnm\xe5ler', 0, 1683224, 150, u'')
20:16:00      (u'2014-12-03 00:58:01', 1417564681, u'Regnm\xe5ler', 0, 1683224, 0, u'')
20:16:00      (u'2014-12-03 01:09:46', 1417565386, u'Regnm\xe5ler', 0, 1683374, 150, u'')
20:16:00      (u'2014-12-03 01:22:18', 1417566138, u'Regnm\xe5ler', 0, 1683374, 0, u'')
20:16:00      (u'2014-12-03 01:33:16', 1417566796, u'Regnm\xe5ler', 0, 1683524, 150, u'')
20:16:00      (u'2014-12-03 01:45:01', 1417567501, u'Regnm\xe5ler', 0, 1683524, 0, u'')
20:16:00      (u'2014-12-03 01:57:33', 1417568253, u'Regnm\xe5ler', 0, 1683674, 150, u'')
20:16:00      (u'2014-12-03 02:07:44', 1417568865, u'Regnm\xe5ler', 0, 1683674, 0, u'')
20:16:00      (u'2014-12-03 02:17:55', 1417569476, u'Regnm\xe5ler', 0, 1683824, 150, u'')
20:16:00      (u'2014-12-03 02:28:06', 1417570086, u'Regnm\xe5ler', 0, 1683824, 0, u'')
20:16:00      (u'2014-12-03 02:39:51', 1417570791, u'Regnm\xe5ler', 0, 1683974, 150, u'')
20:16:00      (u'2014-12-03 02:52:23', 1417571544, u'Regnm\xe5ler', 0, 1683974, 0, u'')
20:16:00      (u'2014-12-03 03:04:08', 1417572248, u'Regnm\xe5ler', 0, 1684124, 150, u'')
20:16:00      (u'2014-12-03 03:15:53', 1417572953, u'Regnm\xe5ler', 0, 1684124, 0, u'')
20:16:00      (u'2014-12-03 03:26:51', 1417573612, u'Regnm\xe5ler', 0, 1684274, 150, u'')
20:16:00      (u'2014-12-03 03:39:23', 1417574364, u'Regnm\xe5ler', 0, 1684274, 0, u'')
20:16:00      (u'2014-12-03 03:50:21', 1417575022, u'Regnm\xe5ler', 0, 1684424, 150, u'')
20:16:00      (u'2014-12-03 04:03:40', 1417575821, u'Regnm\xe5ler', 0, 1684424, 0, u'')
20:16:00      (u'2014-12-03 04:13:51', 1417576432, u'Regnm\xe5ler', 0, 1684574, 150, u'')
20:16:00      (u'2014-12-03 04:25:36', 1417577137, u'Regnm\xe5ler', 0, 1684574, 0, u'')
20:16:00      (u'2014-12-03 04:37:21', 1417577842, u'Regnm\xe5ler', 0, 1684724, 150, u'')
20:16:00      (u'2014-12-03 04:50:40', 1417578641, u'Regnm\xe5ler', 0, 1684724, 0, u'')
20:16:00      (u'2014-12-03 05:02:25', 1417579346, u'Regnm\xe5ler', 0, 1684874, 150, u'')
20:16:00      (u'2014-12-03 05:16:31', 1417580192, u'Regnm\xe5ler', 0, 1684874, 0, u'')
20:16:00      (u'2014-12-03 05:27:29', 1417580850, u'Regnm\xe5ler', 0, 1685024, 150, u'')
20:16:00      (u'2014-12-03 05:38:27', 1417581508, u'Regnm\xe5ler', 0, 1685024, 0, u'')
20:16:00      (u'2014-12-03 05:55:41', 1417582542, u'Regnm\xe5ler', 0, 1685174, 150, u'')
20:16:00      (u'2014-12-03 06:06:40', 1417583200, u'Regnm\xe5ler', 0, 1685174, 0, u'')
20:16:00      (u'2014-12-03 06:22:19', 1417584140, u'Regnm\xe5ler', 0, 1685324, 150, u'')
20:16:00      (u'2014-12-03 06:33:18', 1417584798, u'Regnm\xe5ler', 0, 1685324, 0, u'')
20:16:00      (u'2014-12-03 06:45:03', 1417585503, u'Regnm\xe5ler', 0, 1685474, 150, u'')
20:16:00      (u'2014-12-03 07:14:02', 1417587242, u'Regnm\xe5ler', 0, 1685474, 0, u'')
20:16:00      (u'2014-12-03 07:24:13', 1417587853, u'Regnm\xe5ler', 0, 1685624, 150, u'')
20:16:00      (u'2014-12-03 07:37:32', 1417588652, u'Regnm\xe5ler', 0, 1685624, 0, u'')
20:16:00      (u'2014-12-03 07:49:17', 1417589357, u'Regnm\xe5ler', 0, 1685774, 150, u'')
20:16:00      (u'2014-12-03 08:04:57', 1417590297, u'Regnm\xe5ler', 0, 1685774, 0, u'')
20:16:00      (u'2014-12-03 08:17:29', 1417591049, u'Regnm\xe5ler', 0, 1685924, 150, u'')
20:16:00      (u'2014-12-03 08:32:22', 1417591943, u'Regnm\xe5ler', 0, 1685924, 0, u'')
20:16:00      (u'2014-12-03 08:45:41', 1417592741, u'Regnm\xe5ler', 0, 1686074, 150, u'')
20:16:00      (u'2014-12-03 08:55:52', 1417593352, u'Regnm\xe5ler', 0, 1686074, 0, u'')
20:16:00      (u'2014-12-03 09:08:24', 1417594104, u'Regnm\xe5ler', 0, 1686224, 150, u'')
20:16:00      (u'2014-12-03 09:18:35', 1417594715, u'Regnm\xe5ler', 0, 1686224, 0, u'')
20:16:00      (u'2014-12-03 09:30:20', 1417595420, u'Regnm\xe5ler', 0, 1686374, 150, u'')
20:16:00      (u'2014-12-03 09:41:18', 1417596078, u'Regnm\xe5ler', 0, 1686374, 0, u'')
20:16:00      (u'2014-12-03 09:51:29', 1417596689, u'Regnm\xe5ler', 0, 1686524, 150, u'')
20:16:00      (u'2014-12-03 10:04:01', 1417597442, u'Regnm\xe5ler', 0, 1686524, 0, u'')
20:16:00      (u'2014-12-03 10:18:54', 1417598335, u'Regnm\xe5ler', 0, 1686674, 150, u'')
20:16:00      (u'2014-12-03 10:30:39', 1417599040, u'Regnm\xe5ler', 0, 1686674, 0, u'')
20:16:00      (u'2014-12-03 10:40:50', 1417599651, u'Regnm\xe5ler', 0, 1686824, 150, u'')
20:16:00      (u'2014-12-03 10:51:01', 1417600262, u'Regnm\xe5ler', 0, 1686824, 0, u'')
20:16:00      (u'2014-12-03 11:01:12', 1417600873, u'Regnm\xe5ler', 0, 1686974, 150, u'')
20:16:00      (u'2014-12-03 11:11:23', 1417601484, u'Regnm\xe5ler', 0, 1686974, 0, u'')
20:16:00      (u'2014-12-03 11:21:34', 1417602095, u'Regnm\xe5ler', 0, 1687124, 150, u'')
20:16:00      (u'2014-12-03 11:31:45', 1417602706, u'Regnm\xe5ler', 0, 1687124, 0, u'')
20:16:00      (u'2014-12-03 11:41:56', 1417603317, u'Regnm\xe5ler', 0, 1687274, 150, u'')
20:16:00      (u'2014-12-03 11:52:07', 1417603928, u'Regnm\xe5ler', 0, 1687274, 0, u'')
20:16:00      (u'2014-12-03 12:02:18', 1417604539, u'Regnm\xe5ler', 0, 1687424, 150, u'')
20:16:00      (u'2014-12-03 12:12:29', 1417605150, u'Regnm\xe5ler', 0, 1687424, 0, u'')
20:16:00      (u'2014-12-03 12:22:40', 1417605761, u'Regnm\xe5ler', 0, 1687574, 150, u'')
20:16:00      (u'2014-12-03 12:33:38', 1417606419, u'Regnm\xe5ler', 0, 1687574, 0, u'')
20:16:00      (u'2014-12-03 12:43:49', 1417607030, u'Regnm\xe5ler', 0, 1687724, 150, u'')
20:16:00      (u'2014-12-03 12:54:00', 1417607641, u'Regnm\xe5ler', 0, 1687724, 0, u'')
20:16:00      (u'2014-12-03 13:04:11', 1417608252, u'Regnm\xe5ler', 0, 1687874, 150, u'')
20:16:00      (u'2014-12-03 13:14:23', 1417608863, u'Regnm\xe5ler', 0, 1687874, 0, u'')
20:16:00      (u'2014-12-03 13:24:34', 1417609474, u'Regnm\xe5ler', 0, 1688024, 150, u'')
20:16:00      (u'2014-12-03 13:34:45', 1417610085, u'Regnm\xe5ler', 0, 1688024, 0, u'')
20:16:00      (u'2014-12-03 13:44:56', 1417610696, u'Regnm\xe5ler', 0, 1688174, 150, u'')
20:16:00      (u'2014-12-03 13:55:07', 1417611307, u'Regnm\xe5ler', 0, 1688174, 0, u'')
20:16:00      (u'2014-12-03 14:05:18', 1417611918, u'Regnm\xe5ler', 0, 1688324, 150, u'')
20:16:00      (u'2014-12-03 14:15:29', 1417612529, u'Regnm\xe5ler', 0, 1688324, 0, u'')
20:16:00      (u'2014-12-03 14:26:27', 1417613187, u'Regnm\xe5ler', 0, 1688474, 150, u'')
20:16:00      (u'2014-12-03 14:36:38', 1417613798, u'Regnm\xe5ler', 0, 1688474, 0, u'')
20:16:00      (u'2014-12-03 14:47:36', 1417614456, u'Regnm\xe5ler', 0, 1688624, 150, u'')
20:16:00      (u'2014-12-03 14:58:34', 1417615114, u'Regnm\xe5ler', 0, 1688624, 0, u'')
20:16:00      (u'2014-12-03 15:08:45', 1417615725, u'Regnm\xe5ler', 0, 1688774, 150, u'')
20:16:00      (u'2014-12-03 15:20:30', 1417616430, u'Regnm\xe5ler', 0, 1688774, 0, u'')
20:16:00      (u'2014-12-03 15:31:28', 1417617088, u'Regnm\xe5ler', 0, 1688924, 150, u'')
20:16:00      (u'2014-12-03 15:41:39', 1417617699, u'Regnm\xe5ler', 0, 1688924, 0, u'')
20:16:00      (u'2014-12-03 15:51:50', 1417618310, u'Regnm\xe5ler', 0, 1689074, 150, u'')
20:16:00      (u'2014-12-03 16:02:48', 1417618968, u'Regnm\xe5ler', 0, 1689074, 0, u'')
20:16:00      (u'2014-12-03 16:12:59', 1417619579, u'Regnm\xe5ler', 0, 1689224, 150, u'')
20:16:00      (u'2014-12-03 16:23:10', 1417620190, u'Regnm\xe5ler', 0, 1689224, 0, u'')
20:16:00      (u'2014-12-03 16:33:21', 1417620801, u'Regnm\xe5ler', 0, 1689374, 150, u'')
20:16:00      (u'2014-12-03 16:43:32', 1417621412, u'Regnm\xe5ler', 0, 1689374, 0, u'')
20:16:00      (u'2014-12-03 16:53:43', 1417622024, u'Regnm\xe5ler', 0, 1689524, 150, u'')
20:16:00      (u'2014-12-03 17:03:54', 1417622634, u'Regnm\xe5ler', 0, 1689524, 0, u'')
20:16:00      (u'2014-12-03 17:14:05', 1417623245, u'Regnm\xe5ler', 0, 1689674, 150, u'')
20:16:00      (u'2014-12-03 17:24:16', 1417623857, u'Regnm\xe5ler', 0, 1689674, 0, u'')
20:16:00      (u'2014-12-03 17:34:27', 1417624468, u'Regnm\xe5ler', 0, 1689824, 150, u'')
20:16:00      (u'2014-12-03 17:44:38', 1417625079, u'Regnm\xe5ler', 0, 1689824, 0, u'')
20:16:00      (u'2014-12-03 17:55:36', 1417625737, u'Regnm\xe5ler', 0, 1689974, 150, u'')
20:16:00      (u'2014-12-03 18:06:34', 1417626395, u'Regnm\xe5ler', 0, 1689974, 0, u'')
20:16:00      (u'2014-12-03 18:16:45', 1417627006, u'Regnm\xe5ler', 0, 1690124, 150, u'')
20:16:00      (u'2014-12-03 18:26:56', 1417627617, u'Regnm\xe5ler', 0, 1690124, 0, u'')
20:16:00      (u'2014-12-03 18:37:07', 1417628228, u'Regnm\xe5ler', 0, 1690274, 150, u'')
20:16:00      (u'2014-12-03 18:47:18', 1417628839, u'Regnm\xe5ler', 0, 1690274, 0, u'')
20:16:00      (u'2014-12-03 18:57:29', 1417629450, u'Regnm\xe5ler', 0, 1690424, 150, u'')
20:16:00      (u'2014-12-03 19:07:40', 1417630061, u'Regnm\xe5ler', 0, 1690424, 0, u'')
20:16:00      (u'2014-12-03 19:17:51', 1417630672, u'Regnm\xe5ler', 0, 1690574, 150, u'')
20:16:00      (u'2014-12-03 19:28:02', 1417631283, u'Regnm\xe5ler', 0, 1690574, 0, u'')
20:16:00      (u'2014-12-03 19:38:13', 1417631894, u'Regnm\xe5ler', 0, 1690724, 150, u'')
20:16:00      (u'2014-12-03 19:48:24', 1417632505, u'Regnm\xe5ler', 0, 1690724, 0, u'')
20:16:00      (u'2014-12-03 19:59:22', 1417633163, u'Regnm\xe5ler', 0, 1690874, 150, u'')
20:16:00      (u'2014-12-03 20:09:33', 1417633774, u'Regnm\xe5ler', 0, 1690874, 0, u'')
20:16:00      (u'2014-12-03 20:21:18', 1417634479, u'Regnm\xe5ler', 0, 1691024, 150, u'')
20:16:00      (u'2014-12-03 20:31:29', 1417635090, u'Regnm\xe5ler', 0, 1691024, 0, u'')
20:16:00      (u'2014-12-03 20:41:40', 1417635701, u'Regnm\xe5ler', 0, 1691174, 150, u'')
20:16:00      (u'2014-12-03 20:51:51', 1417636312, u'Regnm\xe5ler', 0, 1691174, 0, u'')
20:16:00      (u'2014-12-03 21:02:02', 1417636923, u'Regnm\xe5ler', 0, 1691324, 150, u'')
20:16:00      (u'2014-12-03 21:12:13', 1417637534, u'Regnm\xe5ler', 0, 1691324, 0, u'')
20:16:00      (u'2014-12-03 21:22:25', 1417638145, u'Regnm\xe5ler', 0, 1691474, 150, u'')
20:16:00      (u'2014-12-03 21:32:36', 1417638756, u'Regnm\xe5ler', 0, 1691474, 0, u'')
20:16:00      (u'2014-12-03 21:42:47', 1417639367, u'Regnm\xe5ler', 0, 1691624, 150, u'')
20:16:00      (u'2014-12-03 21:52:58', 1417639978, u'Regnm\xe5ler', 0, 1691624, 0, u'')
20:16:00      (u'2014-12-03 22:03:09', 1417640589, u'Regnm\xe5ler', 0, 1691774, 150, u'')
20:16:00      (u'2014-12-03 22:13:20', 1417641200, u'Regnm\xe5ler', 0, 1691774, 0, u'')
20:16:00      (u'2014-12-03 22:23:31', 1417641811, u'Regnm\xe5ler', 0, 1691924, 150, u'')
20:16:00      (u'2014-12-03 22:33:42', 1417642422, u'Regnm\xe5ler', 0, 1691924, 0, u'')
20:16:00      (u'2014-12-03 22:43:53', 1417643033, u'Regnm\xe5ler', 0, 1692074, 150, u'')
20:16:00      (u'2014-12-03 22:54:04', 1417643644, u'Regnm\xe5ler', 0, 1692074, 0, u'')
20:16:00      (u'2014-12-03 23:04:15', 1417644255, u'Regnm\xe5ler', 0, 1692224, 150, u'')
20:16:00      (u'2014-12-03 23:14:26', 1417644866, u'Regnm\xe5ler', 0, 1692224, 0, u'')
20:16:00      (u'2014-12-03 23:25:24', 1417645524, u'Regnm\xe5ler', 0, 1692374, 150, u'')
20:16:00      (u'2014-12-03 23:35:35', 1417646135, u'Regnm\xe5ler', 0, 1692374, 0, u'')
20:16:00      (u'2014-12-03 23:45:46', 1417646746, u'Regnm\xe5ler', 0, 1692524, 150, u'')
20:16:00      (u'2014-12-03 23:55:57', 1417647357, u'Regnm\xe5ler', 0, 1692524, 0, u'')
20:16:00      (u'2014-12-04 00:06:55', 1417648015, u'Regnm\xe5ler', 0, 1692674, 150, u'')
20:16:00      (u'2014-12-04 00:17:06', 1417648626, u'Regnm\xe5ler', 0, 1692674, 0, u'')
20:16:00      (u'2014-12-04 00:27:17', 1417649237, u'Regnm\xe5ler', 0, 1692824, 150, u'')
20:16:00      (u'2014-12-04 00:37:28', 1417649848, u'Regnm\xe5ler', 0, 1692824, 0, u'')
20:16:00      (u'2014-12-04 00:47:39', 1417650459, u'Regnm\xe5ler', 0, 1692974, 150, u'')
20:16:00      (u'2014-12-04 00:57:50', 1417651070, u'Regnm\xe5ler', 0, 1692974, 0, u'')
20:16:00      (u'2014-12-04 01:08:01', 1417651681, u'Regnm\xe5ler', 0, 1693124, 150, u'')
20:16:00      (u'2014-12-04 01:18:59', 1417652340, u'Regnm\xe5ler', 0, 1693124, 0, u'')
20:16:00      (u'2014-12-04 01:29:10', 1417652951, u'Regnm\xe5ler', 0, 1693274, 150, u'')
20:16:00      (u'2014-12-04 01:39:21', 1417653562, u'Regnm\xe5ler', 0, 1693274, 0, u'')
20:16:00      (u'2014-12-04 01:51:06', 1417654267, u'Regnm\xe5ler', 0, 1693424, 150, u'')
20:16:00      (u'2014-12-04 02:01:17', 1417654878, u'Regnm\xe5ler', 0, 1693424, 0, u'')
20:16:00      (u'2014-12-04 02:11:28', 1417655489, u'Regnm\xe5ler', 0, 1693574, 150, u'')
20:16:00      (u'2014-12-04 02:21:39', 1417656100, u'Regnm\xe5ler', 0, 1693574, 0, u'')
20:16:00      (u'2014-12-04 02:31:50', 1417656711, u'Regnm\xe5ler', 0, 1693724, 150, u'')
20:16:00      (u'2014-12-04 02:42:01', 1417657322, u'Regnm\xe5ler', 0, 1693724, 0, u'')
20:16:00      (u'2014-12-04 02:52:12', 1417657933, u'Regnm\xe5ler', 0, 1693874, 150, u'')
20:16:00      (u'2014-12-04 03:02:23', 1417658544, u'Regnm\xe5ler', 0, 1693874, 0, u'')
20:16:00      (u'2014-12-04 03:12:34', 1417659155, u'Regnm\xe5ler', 0, 1694024, 150, u'')
20:16:00      (u'2014-12-04 03:22:45', 1417659766, u'Regnm\xe5ler', 0, 1694024, 0, u'')
20:16:00      (u'2014-12-04 03:32:56', 1417660377, u'Regnm\xe5ler', 0, 1694174, 150, u'')
20:16:00      (u'2014-12-04 03:43:54', 1417661035, u'Regnm\xe5ler', 0, 1694174, 0, u'')
20:16:00      (u'2014-12-04 03:54:05', 1417661646, u'Regnm\xe5ler', 0, 1694324, 150, u'')
20:16:00      (u'2014-12-04 04:04:16', 1417662257, u'Regnm\xe5ler', 0, 1694324, 0, u'')
20:16:00      (u'2014-12-04 04:14:27', 1417662868, u'Regnm\xe5ler', 0, 1694474, 150, u'')
20:16:00      (u'2014-12-04 04:24:38', 1417663479, u'Regnm\xe5ler', 0, 1694474, 0, u'')
20:16:00      (u'2014-12-04 04:34:49', 1417664090, u'Regnm\xe5ler', 0, 1694624, 150, u'')
20:16:00      (u'2014-12-04 04:45:00', 1417664701, u'Regnm\xe5ler', 0, 1694624, 0, u'')
20:16:00      (u'2014-12-04 04:55:11', 1417665312, u'Regnm\xe5ler', 0, 1694774, 150, u'')
20:16:00      (u'2014-12-04 05:05:22', 1417665923, u'Regnm\xe5ler', 0, 1694774, 0, u'')
20:16:00      (u'2014-12-04 05:15:34', 1417666534, u'Regnm\xe5ler', 0, 1694924, 150, u'')
20:16:00      (u'2014-12-04 05:25:45', 1417667145, u'Regnm\xe5ler', 0, 1694924, 0, u'')
20:16:00      (u'2014-12-04 05:35:56', 1417667756, u'Regnm\xe5ler', 0, 1695074, 150, u'')
20:16:00      (u'2014-12-04 05:46:07', 1417668367, u'Regnm\xe5ler', 0, 1695074, 0, u'')
20:16:00      (u'2014-12-04 05:56:18', 1417668978, u'Regnm\xe5ler', 0, 1695224, 150, u'')
20:16:00      (u'2014-12-04 06:06:29', 1417669589, u'Regnm\xe5ler', 0, 1695224, 0, u'')
20:16:00      (u'2014-12-04 06:16:40', 1417670200, u'Regnm\xe5ler', 0, 1695374, 150, u'')
20:16:00      (u'2014-12-04 06:26:51', 1417670811, u'Regnm\xe5ler', 0, 1695374, 0, u'')
20:16:00      (u'2014-12-04 06:37:02', 1417671422, u'Regnm\xe5ler', 0, 1695524, 150, u'')

Re: ClimateDataCalculation

Posted: Sat Dec 06, 2014 7:36 am
by krambriw
This is where it goes wrong

Code: Select all

20:16:00      (u'2014-12-02 08:52:08', 1417506728, u'Regnm\xe5ler', 0, 150, 0, u'')
20:16:00      (u'2014-12-02 09:03:06', 1417507386, u'Regnm\xe5ler', 0, 1676624, 0, u'')
The value jumps to a very high one and from then on it is kept in the algo. I cannot explain how this happened but is likely the data that was received could have been corrupt. However this showed that there is an error in my evaluation routine since 150 is from then on added to each of the following stored records even if it should not. This is because we are entering into the routine that thinks the sensor has been resetted and this routine is not correct :(

It will be a bit more complex but I think I have to
- introduce a 'reasonable' magnitude control to avoid such huge quick changes in the readings. First idea is if the change from previous reading is more than 100-1000 mm the reading should be discarded
- improve the routine that is miscalculating and storing the records

I think unfortunately you have to reset your rain database and start all over, I do not know if it makes sense to try to repair it, I do not have any suitable tool for it (basically it would of course be possible by writing a python script)

BR

Re: ClimateDataCalculation

Posted: Sat Dec 06, 2014 11:34 am
by Mastiff
Well, it doesn't really matter if I have to reset the database, it hasn't rained much since I got it started (after the previous change). But I would suggest a much smaller tolerance for jumps. How about 10 mm? You'd really have to have a large interval of checks to get up to 100 mm! :D

Re: ClimateDataCalculation

Posted: Sat Dec 06, 2014 3:18 pm
by krambriw
Thanks for providing the feedback. I have made an update that I believe is working ok. It got a bit complicated since I have to cover the situation that the battery in the sensor needs to be changed from time to time...

Also the check if the value is 'out of range' is targeting really only those strange values like you had in your sample data. Therefore I kept the max allowed diff between readings at 100 mm to allow very long sampling intervals. I mean if we have faulty data, I would expect it to be really far off like in your case.

While simulating, I think it looks ok and I have 'simulated' that the sensor has been restarted twice (at 13:55:27 and 15:08:48). The graph below and the related data looks as if it is handled correctly now.

Best regards
Image1.jpg

Code: Select all

16:09:46   (u'2014-12-06 13:18:18', 1417868298, u'RainSensor on roof', 10, 59, 59, u'fMovAverage == sMovAverage')
16:09:46   (u'2014-12-06 13:24:45', 1417868686, u'RainSensor on roof', 10, 88, 88, u'fMovAverage == sMovAverage')
16:09:46   (u'2014-12-06 13:52:21', 1417870341, u'RainSensor on roof', 10, 113, 113, u'fMovAverage == sMovAverage')
16:09:46   (u'2014-12-06 13:54:48', 1417870489, u'RainSensor on roof', 10, 139, 139, u'fMovAverage == sMovAverage')
16:09:46   (u'2014-12-06 13:55:27', 1417870527, u'RainSensor on roof', 10, 150, 11, u'fMovAverage == sMovAverage')
16:09:46   (u'2014-12-06 15:02:41', 1417874562, u'RainSensor on roof', 10, 175, 36, u'fMovAverage == sMovAverage')
16:09:46   (u'2014-12-06 15:08:48', 1417874928, u'RainSensor on roof', 10, 179, 4, u'fMovAverage < sMovAverage')
16:09:46   (u'2014-12-06 15:10:10', 1417875011, u'RainSensor on roof', 10, 191, 16, u'fMovAverage < sMovAverage')
16:09:46   (u'2014-12-06 15:15:10', 1417875311, u'RainSensor on roof', 10, 195, 20, u'fMovAverage < sMovAverage')
16:09:46   (u'2014-12-06 15:25:18', 1417875919, u'RainSensor on roof', 10, 247, 72, u'fMovAverage < sMovAverage')
16:09:46   (u'2014-12-06 15:55:52', 1417877752, u'RainSensor on roof', 10, 272, 97, u'fMovAverage < sMovAverage')

Re: ClimateDataCalculation

Posted: Sat Dec 06, 2014 7:09 pm
by Mastiff
OK, thanks! It's installed. And I have reset the database. I will check tomorrow if the database is working as it should, there's some rain forecasted for then.

Re: ClimateDataCalculation

Posted: Sat Dec 06, 2014 7:52 pm
by Mastiff
Something must have happened. I get this on the data collecction:

Code: Select all

20:52:05            Error in Action: "ClimateDataCalculation: RainDataCapture: Regnmåler"
20:52:05            Traceback (most recent call last) (1669):
20:52:05              File "C:\Programfiler\EventGhost\eg\Classes\ActionBase.py", line 170, in CallWrapper
20:52:05                return self(*args)
20:52:05              File "C:\Programfiler\EventGhost\plugins\ClimaDataCalculation\__init__.py", line 625, in __call__
20:52:05                rule
20:52:05              File "C:\Programfiler\EventGhost\plugins\ClimaDataCalculation\__init__.py", line 544, in SaveRainData
20:52:05                if s_epoch > dt + sInterval*60-30 and rainTotal < prev_delta + 100:
20:52:05            UnboundLocalError: local variable 'prev_delta' referenced before assignment

Re: ClimateDataCalculation

Posted: Sat Dec 06, 2014 10:50 pm
by krambriw
Sorry, how stupid of me, I lost completely that it has to work also starting with an empty db :oops:

New version is available

Re: ClimateDataCalculation

Posted: Sat Dec 06, 2014 10:56 pm
by Mastiff
Yeah, how incredibly stupid of you! I'm sure I could have done it a lot better...in my dreams...

Thanks, seems to work now! :D

Re: ClimateDataCalculation

Posted: Mon Dec 08, 2014 10:00 am
by Mastiff
Well, then comes my next question: How do I graphically show only the mm of rain that has fallen in the chosen period for the graph? When I do two days, I see it start on what the total was on the beginning of the first day and then stop on the total of the end of the period. The change in total rainfall insn't as interesting as how much that's actually fallen in the period. :)

Re: ClimateDataCalculation

Posted: Tue Dec 09, 2014 8:14 am
by krambriw
How do I graphically show only the mm of rain that has fallen in the chosen period for the graph?
This I understand is just a single value (end of period - start of period). You say that you want this presented in the graph? Are you asking how to get that value printed somewhere on the web page?

Like 'Total rain during the period: 17 mm'
All times are UTC
Page 3 of 37

Powered by phpBB® Forum Software © phpBB Limited