ClimateDataCalculation

krambriw · Post by **krambriw** » Wed Dec 03, 2014 3:31 pm

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.

Mastiff · Post by **Mastiff** » Fri Dec 05, 2014 12:40 pm

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!

krambriw · Post by **krambriw** » Fri Dec 05, 2014 1:37 pm

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

Mastiff · Post by **Mastiff** » Fri Dec 05, 2014 3:02 pm

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

krambriw · Post by **krambriw** » Fri Dec 05, 2014 3:31 pm

Of course, could you change the line nbr 10 as follows

Code: Select all

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

Mastiff · Post by **Mastiff** » Fri Dec 05, 2014 7:17 pm

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'')

krambriw · Post by **krambriw** » Sat Dec 06, 2014 7:36 am

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

Mastiff · Post by **Mastiff** » Sat Dec 06, 2014 11:34 am

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!

krambriw · Post by **krambriw** » Sat Dec 06, 2014 3:18 pm

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

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')

Mastiff · Post by **Mastiff** » Sat Dec 06, 2014 7:09 pm

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.

Mastiff · Post by **Mastiff** » Sat Dec 06, 2014 7:52 pm

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

krambriw · Post by **krambriw** » Sat Dec 06, 2014 10:50 pm

Sorry, how stupid of me, I lost completely that it has to work also starting with an empty db

New version is available

Mastiff · Post by **Mastiff** » Sat Dec 06, 2014 10:56 pm

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!

Mastiff · Post by **Mastiff** » Mon Dec 08, 2014 10:00 am

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.

krambriw · Post by **krambriw** » Tue Dec 09, 2014 8:14 am

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'

EventGhost

ClimateDataCalculation

Re: ClimateDataCalculation

Re: ClimateDataCalculation

Re: ClimateDataCalculation

Re: ClimateDataCalculation

Re: ClimateDataCalculation

Re: ClimateDataCalculation

Re: ClimateDataCalculation

Re: ClimateDataCalculation

Re: ClimateDataCalculation

Re: ClimateDataCalculation

Re: ClimateDataCalculation

Re: ClimateDataCalculation

Re: ClimateDataCalculation

Re: ClimateDataCalculation

Re: ClimateDataCalculation