INDIGOplotD -- a plot tool for indigo

A Plugin to create Plots from INDIGO data and other sources
Post Reply
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

Re: INDIGOplotD -- a plot tool for indigo

Post by kw123 »

to stop it for the time being select no sql in the config at the bottom..
Top
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

Re: INDIGOplotD -- a plot tool for indigo

Post by kw123 »

moyse, could you try this version. It will skip the bad data and should not swamp the log file..

http://forums.indigodomo.com/viewtopic. ... 219#p91219


Karl

ps I still would like to understand why there is bad / incomplete data returned from the SQL query.
Could this device/variable/state have blank as a value? Then I might be able to explain it.
Top
moyse
Posts: 39
Joined: Mon Apr 14, 2014 6:55 am

Re: INDIGOplotD -- a plot tool for indigo

Post by moyse »

kw123 wrote:what database are you using?
It complains that the SQL query returns bad data!

it should have

ID date data

data is missing.
Ah. Okay, I see what you mean...

could you send me some lines of an SQL output file:

that are for example:
/Users/yourID/Documents/INDIGOplotD/sql/46489666-humidity (the #-humidity should be replaced with yours.)

just double-click on one of them and send me the first lines..

Karl
Okay, I've done

Code: Select all

cd Documents/INDIGOplotD/sql
grep 20141211103609 *
and I get the following:
1380917085-sensorValue:1 20141211103609
1380917085-sensorValue:2 20141211103609 0
1497049140-sensorValue:1 20141211103609
1497049140-sensorValue:2 20141211103609 0
386100125-batteryLevel:1 20141211103609
386100125-batteryLevel:2 20141211103609 0
386100125-batteryLevel:3 20141211103609 100
386100125-onOffState:1 20141211103609 False
923962281-sensorValue:1 20141211103609
923962281-sensorValue:2 20141211103609 0
If I look at the first of those files I see:
1 20141211103609
2 20141211103609 0
4 20141211104811 12.2
5 20141211110012 8
6 20141211111212 6.3
7 20141211112412 5.9
8 20141211113612 5.1
9 20141211114812 5
10 20141211120014 5.3
I'll try the new version - thanks very much for the super fast work!

Edit: Hmm. Now I seem to have missing lines in my plots. It's almost like it lost data since the beginning of January... I reverted to -30 though, and so I'm really confused! See below for the minute, and day plot
refreshingimage-2.png
refreshingimage-2.png (6.45 KiB) Viewed 5259 times
refreshingimage-3.png
refreshingimage-3.png (10.4 KiB) Viewed 5259 times
Last edited by moyse on Mon Jan 26, 2015 1:14 pm, edited 1 time in total.
Top
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

Re: INDIGOplotD -- a plot tool for indigo

Post by kw123 »

It looks as if the first line has blank as data.


Sent from my iPhone using Tapatalk
Top
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

INDIGOplotD -- a plot tool for indigo

Post by kw123 »

moyse,

let me play this back:

1. the plots lines now show below 0.
2. the sql import works? ... it looks as if ALL entries with ID=1 have no data.
3. you now miss data .. it looks like the sql import is empty and the data starts accumulating (see the 2 little line pieces monday 20:00)
[edit] could you do reload data from SQL (not the 2 day one), that should kill the bad data lines. they are are left over from early days..


for 3:
could you send me:
the log file output of menu: indigo/indigoplot/print-log plots + devices
and
the output of print formatted data

Thanks

Karl
Top
moyse
Posts: 39
Joined: Mon Apr 14, 2014 6:55 am

Re: INDIGOplotD -- a plot tool for indigo

Post by moyse »

kw123 wrote:moyse,

let me play this back:

1. the plots lines now show below 0.
2. the sql import works? ... it looks as if ALL entries with ID=1 have no data.
Yes, I think so. It's just the default SQLite from SQL logger btw.
3. you now miss data .. it looks like the sql import is empty and the data starts accumulating (see the 2 little line pieces monday 20:00)
[edit] could you do reload data from SQL (not the 2 day one), that should kill the bad data lines. they are are left over from early days..
That didn't seem to work. :-(

BTW I see this being printed every second or so:
INDIGOplotD readSQLdataBatch calledfrom ...runConcurrentThread
for 3:
could you send me:
the log file output of menu: indigo/indigoplot/print-log plots + devices
INDIGOplotD command: PrintPlotData
INDIGOplotD indigoCommand: PrintPlotData
INDIGOplotD PLOT:: deviceID/deviceName: 1691929873/test
INDIGOplotD --Background>>#FFFFFF<<
INDIGOplotD --DeviceNamePlot>>test<<
INDIGOplotD --ExtraText>><<
INDIGOplotD --ExtraTextColorRGB>>#000000<<
INDIGOplotD --ExtraTextFrontBack>>front<<
INDIGOplotD --ExtraTextRotate>>0<<
INDIGOplotD --ExtraTextSize>>8<<
INDIGOplotD --ExtraTextXPos>>0.5<<
INDIGOplotD --ExtraTextYPos>>0.5<<
INDIGOplotD --Grid>>0<<
INDIGOplotD --LeftLabel>><<
INDIGOplotD --LeftLog>>linear<<
INDIGOplotD --LeftScaleDecPoints>><<
INDIGOplotD --LeftScaleRange>>00:10<<
INDIGOplotD --LeftScaleTics>><<
INDIGOplotD --MHDDays>>[2, 14, 90]<<
INDIGOplotD --MHDShift>>[u'0', u'0', u'0']<<
INDIGOplotD --NumberIsUsed>>1<<
INDIGOplotD --PlotFileLastUpdate>>0<<
INDIGOplotD --PlotFileOrVariName>><<
INDIGOplotD --PlotType>>dataFromTimeSeries<<
INDIGOplotD --Raw>><<
INDIGOplotD --RightLabel>><<
INDIGOplotD --RightLog>>linear<<
INDIGOplotD --RightScaleDecPoints>>0<<
INDIGOplotD --RightScaleRange>><<
INDIGOplotD --RightScaleTics>><<
INDIGOplotD --TextColor>>#000000<<
INDIGOplotD --TextFont>>0<<
INDIGOplotD --TextMATFont>>sans-serif<<
INDIGOplotD --TextSize>>8<<
INDIGOplotD --Textscale21>>1.5<<
INDIGOplotD --TitleText>>Test<<
INDIGOplotD --TransparentBackground>>1.0<<
INDIGOplotD --TransparentBlocks>>1.0<<
INDIGOplotD --XLabel>>x-axis Text<<
INDIGOplotD --XLog>>linear<<
INDIGOplotD --XScaleDecPoints>>0<<
INDIGOplotD --XScaleFormat>><<
INDIGOplotD --XScaleRange>><<
INDIGOplotD --XScaleTics>><<
INDIGOplotD --XYvPolar>>xy<<
INDIGOplotD --ampm>>24<<
INDIGOplotD --dataSource>>interactive<<
INDIGOplotD --drawZeroLine>>True<<
INDIGOplotD --resxy>>[u'820,350', u'1024,768']<<
INDIGOplotD --line 1: {u'lineType': u'Histogram', u'lineSmooth': u'None', u'lineLeftRight': u'Left', u'lineFunc': u'None', u'lineToColumnIndexA': 13, u'lineMultiplier': 1.0, u'lineToColumnIndexB': 0, u'lineOffset': 0.0, u'lineColor': u'#0000FF', u'lineWidth': u'1', u'lineKey': u'Living room', u'lineShift': 0}
INDIGOplotD PLOT:: deviceID/deviceName: 179418475/Temperatures
INDIGOplotD --Background>>#FFFFFF<<
INDIGOplotD --DeviceNamePlot>>Temperatures<<
INDIGOplotD --ExtraText>><<
INDIGOplotD --ExtraTextColorRGB>>#000000<<
INDIGOplotD --ExtraTextFrontBack>>front<<
INDIGOplotD --ExtraTextRotate>>0.0<<
INDIGOplotD --ExtraTextSize>>8<<
INDIGOplotD --ExtraTextXPos>>0.0<<
INDIGOplotD --ExtraTextYPos>>0.0<<
INDIGOplotD --Grid>>1<<
INDIGOplotD --LeftLabel>>C<<
INDIGOplotD --LeftLog>>linear<<
INDIGOplotD --LeftScaleDecPoints>>0<<
INDIGOplotD --LeftScaleRange>>-10:40<<
INDIGOplotD --LeftScaleTics>>-10,0,10,20,30,40<<
INDIGOplotD --MHDDays>>[1, 14, 90]<<
INDIGOplotD --MHDShift>>[-1, 0, 0]<<
INDIGOplotD --NumberIsUsed>>1<<
INDIGOplotD --PlotFileLastUpdate>>0<<
INDIGOplotD --PlotFileOrVariName>><<
INDIGOplotD --PlotType>>dataFromTimeSeries<<
INDIGOplotD --Raw>><<
INDIGOplotD --RightLabel>>Humidity<<
INDIGOplotD --RightLog>>linear<<
INDIGOplotD --RightScaleDecPoints>>0<<
INDIGOplotD --RightScaleRange>>0:100<<
INDIGOplotD --RightScaleTics>>0,10,20,30,40,50,60,70,80,90,100<<
INDIGOplotD --TextColor>>#000000<<
INDIGOplotD --TextFont>>0<<
INDIGOplotD --TextMATFont>>sans-serif<<
INDIGOplotD --TextSize>>8<<
INDIGOplotD --Textscale21>>1.5<<
INDIGOplotD --TitleText>>Temperatures<<
INDIGOplotD --TransparentBackground>>1.0<<
INDIGOplotD --TransparentBlocks>>1.0<<
INDIGOplotD --XLabel>>x-axis Text<<
INDIGOplotD --XLog>>linear<<
INDIGOplotD --XScaleDecPoints>>0<<
INDIGOplotD --XScaleFormat>><<
INDIGOplotD --XScaleRange>><<
INDIGOplotD --XScaleTics>><<
INDIGOplotD --XYvPolar>>xy<<
INDIGOplotD --ampm>>24<<
INDIGOplotD --dataSource>>interactive<<
INDIGOplotD --drawZeroLine>>True<<
INDIGOplotD --resxy>>[u'820,350', u'1024,768']<<
INDIGOplotD --line 1: {u'lineColor': u'#A00000', u'lineSmooth': u'None', u'lineLeftRight': u'Left', u'lineFunc': u'None', u'lineToColumnIndexA': 1, u'lineMultiplier': 1.0, u'lineToColumnIndexB': 0, u'lineOffset': 0.0, u'lineType': u'LineSolid', u'lineWidth': u'2', u'lineKey': u'Garage', u'lineShift': 0}
INDIGOplotD --line 2: {u'lineColor': u'#A0A000', u'lineSmooth': u'None', u'lineLeftRight': u'Left', u'lineFunc': u'None', u'lineToColumnIndexA': 6, u'lineMultiplier': 1.0, u'lineToColumnIndexB': 0, u'lineOffset': 0.0, u'lineType': u'LineSolid', u'lineWidth': u'2', u'lineKey': u'Downstairs', u'lineShift': 0}
INDIGOplotD --line 3: {u'lineType': u'LineSolid', u'lineSmooth': u'None', u'lineLeftRight': u'Left', u'lineFunc': u'None', u'lineToColumnIndexA': 17, u'lineMultiplier': 1.0, u'lineToColumnIndexB': 0, u'lineOffset': 0.0, u'lineColor': u'#FFA500', u'lineWidth': u'2', u'lineKey': u'Exterior', u'lineShift': 0}
INDIGOplotD --line 4: {u'lineType': u'LineDashed', u'lineSmooth': u'None', u'lineLeftRight': u'Right', u'lineFunc': u'None', u'lineToColumnIndexA': 19, u'lineMultiplier': 1.0, u'lineToColumnIndexB': 0, u'lineOffset': 0.0, u'lineColor': u'#00FF00', u'lineWidth': u'2', u'lineKey': u'Front Ext. Humidity', u'lineShift': 0}
INDIGOplotD PLOT:: deviceID/deviceName: 453728453/Battery levels
INDIGOplotD --Background>>#FFFFFF<<
INDIGOplotD --DeviceNamePlot>>Battery levels<<
INDIGOplotD --ExtraText>><<
INDIGOplotD --ExtraTextColorRGB>>#000000<<
INDIGOplotD --ExtraTextFrontBack>>front<<
INDIGOplotD --ExtraTextRotate>>0<<
INDIGOplotD --ExtraTextSize>>8<<
INDIGOplotD --ExtraTextXPos>>0.5<<
INDIGOplotD --ExtraTextYPos>>0.5<<
INDIGOplotD --Grid>>0<<
INDIGOplotD --LeftLabel>>On<<
INDIGOplotD --LeftLog>>linear<<
INDIGOplotD --LeftScaleDecPoints>><<
INDIGOplotD --LeftScaleRange>>00:100<<
INDIGOplotD --LeftScaleTics>>20,40,60,80,100<<
INDIGOplotD --MHDDays>>[2, 14, 90]<<
INDIGOplotD --MHDShift>>[u'0', u'0', u'0']<<
INDIGOplotD --NumberIsUsed>>1<<
INDIGOplotD --PlotFileLastUpdate>>0<<
INDIGOplotD --PlotFileOrVariName>><<
INDIGOplotD --PlotType>>dataFromTimeSeries<<
INDIGOplotD --Raw>><<
INDIGOplotD --RightLabel>><<
INDIGOplotD --RightLog>>linear<<
INDIGOplotD --RightScaleDecPoints>>0<<
INDIGOplotD --RightScaleRange>><<
INDIGOplotD --RightScaleTics>><<
INDIGOplotD --TextColor>>#000000<<
INDIGOplotD --TextFont>>0<<
INDIGOplotD --TextMATFont>>sans-serif<<
INDIGOplotD --TextSize>>8<<
INDIGOplotD --Textscale21>>1.5<<
INDIGOplotD --TitleText>><<
INDIGOplotD --TransparentBackground>>1.0<<
INDIGOplotD --TransparentBlocks>>1.0<<
INDIGOplotD --XLabel>>Time<<
INDIGOplotD --XLog>>linear<<
INDIGOplotD --XScaleDecPoints>>0<<
INDIGOplotD --XScaleFormat>><<
INDIGOplotD --XScaleRange>><<
INDIGOplotD --XScaleTics>><<
INDIGOplotD --XYvPolar>>xy<<
INDIGOplotD --ampm>>24<<
INDIGOplotD --dataSource>>interactive<<
INDIGOplotD --drawZeroLine>>True<<
INDIGOplotD --resxy>>[u'820,350', u'1024,768']<<
INDIGOplotD --line 1: {u'lineColor': u'#FF0000', u'lineSmooth': u'None', u'lineLeftRight': u'Left', u'lineFunc': u'None', u'lineToColumnIndexA': 3, u'lineMultiplier': 1.0, u'lineToColumnIndexB': 0, u'lineOffset': 0.0, u'lineType': u'LineSolid', u'lineWidth': u'1', u'lineKey': u'Garage', u'lineShift': 0}
INDIGOplotD --line 2: {u'lineColor': u'#FFFF00', u'lineSmooth': u'None', u'lineLeftRight': u'Left', u'lineFunc': u'None', u'lineToColumnIndexA': 5, u'lineMultiplier': 1.0, u'lineToColumnIndexB': 0, u'lineOffset': 0.0, u'lineType': u'LineSolid', u'lineWidth': u'1', u'lineKey': u'Garage door', u'lineShift': 0}
INDIGOplotD --line 3: {u'lineColor': u'#00A000', u'lineSmooth': u'None', u'lineLeftRight': u'Left', u'lineFunc': u'None', u'lineToColumnIndexA': 8, u'lineMultiplier': 1.0, u'lineToColumnIndexB': 0, u'lineOffset': 0.0, u'lineType': u'LineSolid', u'lineWidth': u'1', u'lineKey': u'Back door', u'lineShift': 0}
INDIGOplotD --line 4: {u'lineColor': u'#383838', u'lineSmooth': u'None', u'lineLeftRight': u'Left', u'lineFunc': u'None', u'lineToColumnIndexA': 16, u'lineMultiplier': 1.0, u'lineToColumnIndexB': 0, u'lineOffset': 0.0, u'lineType': u'LineSolid', u'lineWidth': u'1', u'lineKey': u'Landing', u'lineShift': 0}
INDIGOplotD --line 5: {u'lineColor': u'#4B0082', u'lineSmooth': u'None', u'lineLeftRight': u'Left', u'lineFunc': u'None', u'lineToColumnIndexA': 21, u'lineMultiplier': 1.0, u'lineToColumnIndexB': 0, u'lineOffset': 0.0, u'lineType': u'LineSolid', u'lineWidth': u'1', u'lineKey': u'Front exterior', u'lineShift': 0}
INDIGOplotD PLOT:: deviceID/deviceName: 129316554/Doors opening
INDIGOplotD --Background>>#FFFFFF<<
INDIGOplotD --DeviceNamePlot>>Doors opening<<
INDIGOplotD --ExtraText>><<
INDIGOplotD --ExtraTextColorRGB>>#000000<<
INDIGOplotD --ExtraTextFrontBack>>front<<
INDIGOplotD --ExtraTextRotate>>0<<
INDIGOplotD --ExtraTextSize>>8<<
INDIGOplotD --ExtraTextXPos>>0.5<<
INDIGOplotD --ExtraTextYPos>>0.5<<
INDIGOplotD --Grid>>0<<
INDIGOplotD --LeftLabel>>Open<<
INDIGOplotD --LeftLog>>log<<
INDIGOplotD --LeftScaleDecPoints>>0<<
INDIGOplotD --LeftScaleRange>>1:100<<
INDIGOplotD --LeftScaleTics>>1,2,4,6,8,10,20,40,60,80,100<<
INDIGOplotD --MHDDays>>[2, 14, 90]<<
INDIGOplotD --MHDShift>>[u'0', u'0', u'0']<<
INDIGOplotD --NumberIsUsed>>1<<
INDIGOplotD --PlotFileLastUpdate>>0<<
INDIGOplotD --PlotFileOrVariName>><<
INDIGOplotD --PlotType>>dataFromTimeSeries<<
INDIGOplotD --Raw>><<
INDIGOplotD --RightLabel>><<
INDIGOplotD --RightLog>>linear<<
INDIGOplotD --RightScaleDecPoints>>0<<
INDIGOplotD --RightScaleRange>><<
INDIGOplotD --RightScaleTics>>0<<
INDIGOplotD --TextColor>>#000000<<
INDIGOplotD --TextFont>>0<<
INDIGOplotD --TextMATFont>>sans-serif<<
INDIGOplotD --TextSize>>8<<
INDIGOplotD --Textscale21>>1.5<<
INDIGOplotD --TitleText>><<
INDIGOplotD --TransparentBackground>>1.0<<
INDIGOplotD --TransparentBlocks>>1.0<<
INDIGOplotD --XLabel>>x-axis Text<<
INDIGOplotD --XLog>>linear<<
INDIGOplotD --XScaleDecPoints>>0<<
INDIGOplotD --XScaleFormat>><<
INDIGOplotD --XScaleRange>><<
INDIGOplotD --XScaleTics>><<
INDIGOplotD --XYvPolar>>xy<<
INDIGOplotD --ampm>>24<<
INDIGOplotD --dataSource>>interactive<<
INDIGOplotD --drawZeroLine>>True<<
INDIGOplotD --resxy>>[u'820,350', u'1024,768']<<
INDIGOplotD --line 1: {u'lineColor': u'#FF0000', u'lineSmooth': u'None', u'lineLeftRight': u'Left', u'lineFunc': u'None', u'lineToColumnIndexA': 2, u'lineMultiplier': 1.0, u'lineToColumnIndexB': 0, u'lineOffset': 2.0, u'lineType': u'FilledCurves', u'lineWidth': u'2', u'lineKey': u'Garage', u'lineShift': 0}
INDIGOplotD --line 2: {u'lineColor': u'#A0A000', u'lineSmooth': u'None', u'lineLeftRight': u'Left', u'lineFunc': u'None', u'lineToColumnIndexA': 4, u'lineMultiplier': 1.0, u'lineToColumnIndexB': 0, u'lineOffset': 0.0, u'lineType': u'Histogram1', u'lineWidth': u'1', u'lineKey': u'Garage door', u'lineShift': 0}
INDIGOplotD --line 3: {u'lineColor': u'#00FFFF', u'lineSmooth': u'None', u'lineLeftRight': u'Left', u'lineFunc': u'None', u'lineToColumnIndexA': 7, u'lineMultiplier': 1.0, u'lineToColumnIndexB': 0, u'lineOffset': 3.0, u'lineType': u'Histogram4', u'lineWidth': u'1', u'lineKey': u'Back door', u'lineShift': 0}
INDIGOplotD --line 4: {u'lineType': u'Histogram2', u'lineSmooth': u'None', u'lineLeftRight': u'Left', u'lineFunc': u'None', u'lineToColumnIndexA': 15, u'lineMultiplier': 1.0, u'lineToColumnIndexB': 0, u'lineOffset': 0.0, u'lineColor': u'#383838', u'lineWidth': u'1', u'lineKey': u'Landing', u'lineShift': 0}
INDIGOplotD --line 5: {u'lineColor': u'#FFA500', u'lineSmooth': u'None', u'lineLeftRight': u'Left', u'lineFunc': u'None', u'lineToColumnIndexA': 13, u'lineMultiplier': 1.0, u'lineToColumnIndexB': 0, u'lineOffset': 0.0, u'lineType': u'Histogram2', u'lineWidth': u'1', u'lineKey': u'Living', u'lineShift': 0}
INDIGOplotD --line 6: {u'lineColor': u'#00FF00', u'lineSmooth': u'None', u'lineLeftRight': u'Left', u'lineFunc': u'None', u'lineToColumnIndexA': 11, u'lineMultiplier': 1.0, u'lineToColumnIndexB': 0, u'lineOffset': 0.0, u'lineType': u'Histogram4', u'lineWidth': u'1', u'lineKey': u'Front door', u'lineShift': 0}
INDIGOplotD --line 7: {u'lineColor': u'#4B0082', u'lineSmooth': u'None', u'lineLeftRight': u'Left', u'lineFunc': u'None', u'lineToColumnIndexA': 20, u'lineMultiplier': 1.0, u'lineToColumnIndexB': 0, u'lineOffset': 0.0, u'lineType': u'Histogram2', u'lineWidth': u'2', u'lineKey': u'Front exterior', u'lineShift': 0}
INDIGOplotD

INDIGOplotD command: PrintDeviceData
INDIGOplotD indigoCommand: PrintDeviceData
DevNo, Name, ID State Measurement offset multipl minValue maxValue ColfilGps resetType --- nickName
1 Garage Motion - Temperature ok: 1
# 1 Dev-ID: 281400050 sensorValue average 0.0 1.0 -200.0 50000.0 1 1 0 GarageMotion+SensorValue+aver
2 Garage Motion - Motion Sensor ok: 1
# 1 Dev-ID: 863180179 onOffState count 0.0 1.0 -200.0 50000.0 2 1 0 GarageMotion+On/Off+coun
# 2 batteryLevel average 0.0 1.0 -200.0 50000.0 3 1 0 GarageMotion+BatteryLevel%+aver
3 Garage door - Door/Window ok: 1
# 1 Dev-ID: 1718877376 onOffState count 0.0 1.0 -200.0 50000.0 4 1 0 Garagedoor-+On/Off+coun
# 2 batteryLevel average 0.0 1.0 -200.0 50000.0 5 1 0 Garagedoor-+BatteryLevel%+aver
4 Garage door - Temperature 1 ok: 1
# 1 Dev-ID: 1838057829 sensorValue average 0.0 1.0 -200.0 50000.0 6 1 0 Garagedoor-+SensorValue+aver
5 Back door - Door/Window ok: 1
# 1 Dev-ID: 338417942 onOffState count 0.0 1.0 -200.0 50000.0 7 1 0 Backdoor-D+On/Off+coun
# 2 batteryLevel average 0.0 1.0 -200.0 50000.0 8 1 0 Backdoor-D+BatteryLevel%+aver
6 1st floor landing - Door ok: 1
# 1 Dev-ID: 771043360 onOffState average 0.0 1.0 -200.0 50000.0 15 1 0 1stfloorlan+On/Off+aver
# 2 batteryLevel average 0.0 1.0 -200.0 50000.0 16 1 0 1stfloorlan+BatteryLevel%+aver
7 Bedroom 2 - Back Window ok: 1
# 1 Dev-ID: 1715072217 onOffState count 0.0 1.0 -200.0 50000.0 9 1 0 Bedroom2-B+On/Off+coun
# 2 batteryLevel average 0.0 1.0 -200.0 50000.0 10 1 0 Bedroom2-B+BatteryLevel%+aver
8 Front door - Door/Window ok: 1
# 1 Dev-ID: 1953382308 onOffState average 0.0 1.0 -200.0 50000.0 11 1 0 Frontdoor-+On/Off+aver
# 2 batteryLevel average 0.0 1.0 -200.0 50000.0 12 1 0 Frontdoor-+BatteryLevel%+aver
9 Front - Exterior Temperature ok: 1
# 1 Dev-ID: 1380917085 sensorValue average 0.0 1.0 -200.0 50000.0 17 1 0 Front-Exter+SensorValue+aver
10 Motion - Living room ok: 1
# 1 Dev-ID: 449977528 onOffState average 0.0 1.0 -200.0 50000.0 13 1 0 Motion-Livi+On/Off+aver
# 2 batteryLevel average 0.0 1.0 -200.0 50000.0 14 1 0 Motion-Livi+BatteryLevel%+aver
11 Front - Exterior Luminance ok: 1
# 1 Dev-ID: 1497049140 sensorValue average 0.0 1.0 -200.0 50000.0 18 1 0 Front-Exter+SensorValue+aver
12 Front - Exterior Humidity ok: 1
# 1 Dev-ID: 923962281 sensorValue average 0.0 1.0 -200.0 50000.0 19 1 0 Front-Exter+SensorValue+aver
13 Front - Motion Sensor ok: 1
# 1 Dev-ID: 386100125 onOffState count 0.0 1.0 -200.0 50000.0 20 1 0 Front-Motio+On/Off+coun
# 2 batteryLevel average 0.0 1.0 -200.0 50000.0 21 1 0 Front-Motio+BatteryLevel%+aver
INDIGOplotD
INDIGOplotD Index list for dataColumn to Device#/State#
INDIGOplotD Column=Dev#/St# Column=Dev#/St# Column=Dev#/St# Column=Dev#/St# Column=Dev#/St#
INDIGOplotD 1= 1/ 1 2= 2/ 1 3= 2/ 2 4= 3/ 1 5= 3/ 2
INDIGOplotD 6= 4/ 1 7= 5/ 1 8= 5/ 2 9= 7/ 1 10= 7/ 2
INDIGOplotD 11= 8/ 1 12= 8/ 2 13= 10/ 1 14= 10/ 2 15= 6/ 1
INDIGOplotD 16= 6/ 2 17= 9/ 1 18= 11/ 1 19= 12/ 1 20= 13/ 1
INDIGOplotD 21= 13/ 2
INDIGOplotD
INDIGOplotD
INDIGOplotD Consumption Cost data; type gConsumption Period
INDIGOplotD ...not defined
INDIGOplotD Consumption Cost data; type wConsumption Period
INDIGOplotD ...not defined
INDIGOplotD Consumption Cost data; type eConsumption Period
INDIGOplotD ...not defined
INDIGOplotD Consumption Cost data; type oConsumption Period
INDIGOplotD ...not defined
INDIGOplotD readSQLdataBatch calledfrom ...runConcurrentThread
INDIGOplotD readSQLdataBatch c


INDIGOplotD command: print device states
INDIGOplotD indigoCommand: PrintDevStates
INDIGOplotD variables ------------------------- Value used as
id: 105911904 ExternalMotionAlarm: true ; ==> 1.0
id: 245587112 FrontMotion: false ; ==> 0.0
id: 764771792 FullAlarm: true ; ==> 1.0
id: 1154633854 INDIGOplotD-Script-Message: ; ==> not usable
id: 1034293617 isDaylight: true ; ==> 1.0
INDIGOplotD devices -------------------------- State(Value:used as), State(Value:used as), ...
id: 771043360 1st floor landing - Door: batteryLevel("70":70.0), batteryLevel.ui("70%":70.0), onOffState("True":1.0),
id: 89508926 1st floor landing - Tamper Switch: onOffState("False":0.0),
id: 338417942 Back door - Door/Window: batteryLevel("92":92.0), batteryLevel.ui("92%":92.0), onOffState("False":0.0),
id: 1269295364 Back door - Tamper Switch: onOffState("False":0.0),
id: 851977669 Back door light - Micro Smart Energy Illuminator (DSC19): accumEnergyTimeDelta("3527804":3527804.0), accumEnergyTimeDelta.ui("3527804 seconds":3527804.0), accumEnergyTotal("0.391":0.391), accumEnergyTotal.ui("0.391 kWh":0.391), brightnessLevel("0":0.0),
: curEnergyLevel("72.767":72.767), curEnergyLevel.ui("72.767 W":72.767), onOffState("False":0.0),
id: 1022117558 Balcony light switch - Relay Switch (TZ66D): onOffState("False":0.0),
id: 1715072217 Bedroom 2 - Back Window: batteryLevel("96":96.0), batteryLevel.ui("96%":96.0), onOffState("False":0.0),
id: 1275624761 Bedroom 2 - Back Window Tamper Switch: onOffState("False":0.0),
id: 1596825276 Downstairs bathroom - Light: onOffState("False":0.0),
id: 923962281 Front - Exterior Humidity: sensorValue("86.0":86.0), sensorValue.ui("86%":86.0),
id: 1497049140 Front - Exterior Luminance: sensorValue("1000.0":1000.0), sensorValue.ui("1000 lux":1000.0),
id: 1380917085 Front - Exterior Temperature: sensorValue("1.8":1.8), sensorValue.ui("1.8 °C":1.8),
id: 386100125 Front - Motion Sensor: batteryLevel("61":61.0), batteryLevel.ui("61%":61.0), onOffState("True":1.0),
id: 1953382308 Front door - Door/Window: batteryLevel("76":76.0), batteryLevel.ui("76%":76.0), onOffState("False":0.0),
id: 99574575 Front door - Tamper Switch: onOffState("False":0.0),
id: 813544034 Front door light - Micro Smart Energy Illuminator (DSC19): accumEnergyTimeDelta("2057604":2057604.0), accumEnergyTimeDelta.ui("2057604 seconds":2057604.0), accumEnergyTotal("3.403":3.403), accumEnergyTotal.ui("3.403 kWh":3.403), brightnessLevel("100":100.0),
: curEnergyLevel("67.645":67.645), curEnergyLevel.ui("67.645 W":67.645), onOffState("True":1.0),
id: 1718877376 Garage door - Door/Window: batteryLevel("95":95.0), batteryLevel.ui("95%":95.0), onOffState("False":0.0),
id: 1796143904 Garage door - Tamper Switch: onOffState("False":0.0),
id: 1838057829 Garage door - Temperature 1: sensorValue("13.81":13.81), sensorValue.ui("13.81 °C":13.81),
id: 1725879307 Garage Motion - Luminance: sensorValue("64.0":64.0), sensorValue.ui("64 lux":64.0),
id: 863180179 Garage Motion - Motion Sensor: batteryLevel("70":70.0), batteryLevel.ui("70%":70.0), onOffState("False":0.0),
id: 281400050 Garage Motion - Temperature: sensorValue("7.6":7.6), sensorValue.ui("7.6 °C":7.6),
id: 1377868214 Garage Motion - Tilt/Tamper: onOffState("False":0.0),
id: 1752929438 Living room - Window over sink: batteryLevel("93":93.0), batteryLevel.ui("93%":93.0), onOffState("False":0.0),
id: 1977605400 Living room window over sink - Tamper Switch: onOffState("False":0.0),
id: 449977528 Motion - Living room: batteryLevel("50":50.0),
id: 97263294 Tamper - living room: onOffState("False":0.0),



and
the output of print formatted data

Thanks

Karl
Okay, they're added as attachments.

Thanks again!
Attachments
minute.dat.formatted.txt
(3.47 KiB) Downloaded 153 times
hour.dat.formatted.txt
(169.9 KiB) Downloaded 181 times
day.dat.formatted.txt
(16.1 KiB) Downloaded 151 times
Top
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

Re: INDIGOplotD -- a plot tool for indigo

Post by kw123 »

the data definitions are ok,
>> the sql import does not work. also the message every seconds indicates that its not finished and it tries to load the data.

could you send me one of the files e.g. temperature sql files that does not work? do not post, but send an email in indigo.
[edit] could you also send the log file when you do the import?
thx

Karl
Top
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

Re: INDIGOplotD -- a plot tool for indigo

Post by kw123 »

moyse,
this version now checks for python versions installed and picks the highest version 2.x available. This should fix your problem.

http://forums.indigodomo.com/viewtopic. ... 327#p91327

Karl
Top
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

Re: INDIGOplotD -- a plot tool for indigo

Post by kw123 »

FYI: GNUPLOT 5.x has significant changes to 4.x

The GNUPLOT files in indigoplotd are NOT compatible with 5.x !

So do NOT upgrade to GNUPLOT 5.x (yet)


Karl
Top
geoffsharris
Posts: 45
Joined: Mon Nov 26, 2012 11:22 pm

Re: INDIGOplotD -- a plot tool for indigo

Post by geoffsharris »

Hi Karl,

Fantastic Tool! Thank you so much. I'm trying to use it to track devices and temperature in a greenhouse to get a better handle on energy optimization. Two questions. 1) Is it possible to integrate device on (value=1) over time to get a cumulative total of minutes that the device is on? If I could sum all of the time bins that the device is on, I could easily multiply this by the wattage and calculate total power usage per time period desired. 2) looks like a small bug or something that I need the RTFM again. When I graph 1 day instead of the default 2, the tick marks are 12am, 1, 3, 4, 6, 7, 9, 10, 12PM, etc. It looks like this should be 12, 1:30, 3, 4:30, 6 based upon the data. Could there be some sort of rounding function that is either setting this to int values or it just isn't displaying the rest of the value. See attachments
Attachments
Outside temperature graph-minute-S2.png
Outside temperature graph-minute-S2.png (97.7 KiB) Viewed 4890 times
Outside temperature graph-minute-S2 Day.png
Outside temperature graph-minute-S2 Day.png (69.27 KiB) Viewed 4890 times
Top
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

Re: INDIGOplotD -- a plot tool for indigo

Post by kw123 »

SUMS:

for on states you could you try
"count" ==> add 1 of value is > 0, is reset to 0 at each new time bin
or
"sum" ==> sum up the values ,
the reset to 0 can be set to day/week/month.. [EDIT] this is implemented in the select menu, but not yet in the code.. it current reset at every bin.

as a "measurement" in the config menu


TIC MARKS:
the tics and tic label are handled by GNUPLOT /MATPLOT. It depends on the format of the number displayed.

looks like here it is set to full hours and no minutes. I believe I selected %H with out ":%M" as format string. The problem with AM/PM display is that there is no space for the minutes.

I am looking at making the labels / tics better, but the number of combinations is very large.. hard to put that into code.


Karl

ps coming up:
1. fixed week day /month/quarter .. plots i.e. always monday-sunday month 1...31..
2. can overlay last weeks(month) data on this weeks(month) data..
Top
CrazyFin
Posts: 381
Joined: Thu Jan 08, 2015 4:09 pm
Location: Stockholm, SWEDEN

Re: INDIGOplotD -- a plot tool for indigo

Post by CrazyFin »

kw123 wrote:FYI: GNUPLOT 5.x has significant changes to 4.x

The GNUPLOT files in indigoplotd are NOT compatible with 5.x !

So do NOT upgrade to GNUPLOT 5.x (yet)
Ooops and I just did this right before I saw your post.... :-( Actually I did not upgrade, I did not had GNUPLOT installed and I just ran your install script from the plugin menu.

What is the easiest way to uninstall and then make sure that I install GNUPLOT 4.x?

===
EDIT
====

I used home-brew to uninstall and then I just followed the last part found on page http://www.physics.buffalo.edu/phy410-5 ... s/install/

I just changed the path to "gnuplot-4.6.6" since that was the version I downloaded after uninstalling 5.0:

"macuser:~/Downloads$ cd gnuplot-4.6.6
macuser:~/Downloads/gnuplot-4.6.6$ ./configure --with-readline=builtin
macuser:~/Downloads/gnuplot-4.6.6$ make
macuser:~/Downloads/gnuplot-4.6.6$ sudo make install"

And voilaaaa! Now it seems to work again. I am glad that I had some minor Ubuntu knowledge now when learning to work in terminal windows on MAC OS X.... :lol:
Top
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

Re: INDIGOplotD -- a plot tool for indigo

Post by kw123 »

make sure you install the proper font library when installing, ... check the terminal command in the PDF on how to install gnuplot
Top
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

Re: INDIGOplotD -- a plot tool for indigo

Post by kw123 »

geoffsharris: the newly posted version 3-8-1 should do the things you requested.. ==> see measurement = "integrate"

and someone requested the FIXED time window option ( fixed window = e.g. Monday-Sunday). This version should do that.

happy plotting

Karl
Top
CrazyFin
Posts: 381
Joined: Thu Jan 08, 2015 4:09 pm
Location: Stockholm, SWEDEN

Re: INDIGOplotD -- a plot tool for indigo

Post by CrazyFin »

kw123 wrote:make sure you install the proper font library when installing, ... check the terminal command in the PDF on how to install gnuplot
1. Ok, I am unsure though about how I can verify that I am installing / having the proper font library?

2. I did follow the PDF first (used the procedure you described in your excellent PDF document) but that installed the newer version 5.0 of GNUPLOT and then all plot-files became zero in size. I then uninstalled GNUPLOT 5.0 and reinstalled the proper version (4.6.6) using the method described in the link above (http://www.physics.buffalo.edu/phy410-5 ... s/install/)

I really like IndigoPlotD! :D For me who is not so familiar with using SQL commands, IndigoPlotD has enabled me to create cool graphs and plots in just a few days that I never was able to do in HomeSeer... :roll:
Top
Post Reply

Return to “INDIGOplotD”