Mixing Events and data

Posted on
Fri Nov 18, 2016 6:35 am
johnpolasek offline
Posts: 911
Joined: Aug 05, 2011
Location: Aggieland, Texas

Mixing Events and data

No rush, but I think that you may still have a few bugs in the EVENT data plotting; I finally got the I7-Z-wave changeover completed last night and started playing with updating my plots to use this new ability; The first thing that I found was that although the log indicates that there should be -minute-s1 and -minute-s2 plots, those png files are never generated when all the data is EVENT based. The hour and day files are there, but the minute files are not. Second, when I took my plot of door open events on the left axis and attempted to add the family beacon home count max data item plotted on the right axis, ONLY the count data was plotted; all the events were skipped, but the minute files started appearing... deleting that data item made the events come back but the minute pngs go away again... Is there no way to mix these tow data types? The download file says it's version 4-16-12.

UPDATE... looking at the plot a little more closely from here at work, I think the issue with the events not plotting is that something went wrong with the Triggers for the variables being used for the source of the events... all the hour data is coming from before I updated to I7 Tuesday afternoon; it's like no door open events occurred after the version change. I'm at work and can't open doors to make sure the variables are changing till I get home, but looking at another control page, the "Date/Time opened" values that come from the same trigger ARE correct,

Posted on
Fri Nov 18, 2016 11:30 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: Mixing Events and data

Indigoplotd does nothing different in 6 vs 7
Could you check if the data is in the sql database?
You can use indigo utilities for this
Or look at documents/indigoplotd/SQl/xxxx
Xxxx = device#-state something like 282208849-onOffState
and the data should look like:
Code: Select all
785;20161118131456;1.0
786;20161118131634;0.0
787;20161118170912;1.0
788;20161118171025;0.0
789;20161118171138;1.0
790;20161118171251;0.0
791;20161118171527;1.0
792;20161118171730;0.0
793;20161118173825;1.0
794;20161118174008;0.0
795;20161118214052;1.0
796;20161118214205;0.0
797;20161118224028;1.0
798;20161118224141;0.0


there could be some confusion on the data base path = the plugin points still to the v6 database or i7 still is using 6 sql database ...


Sent from my iPhone using Tapatalk

Posted on
Mon Nov 21, 2016 6:38 am
johnpolasek offline
Posts: 911
Joined: Aug 05, 2011
Location: Aggieland, Texas

Re: Mixing Events and data

Here's the plot:
Attachments
Pi Doors copy-hour-S2 copy.png
Pi Doors copy-hour-S2 copy.png (65.32 KiB) Viewed 1734 times

Posted on
Mon Nov 21, 2016 6:43 am
johnpolasek offline
Posts: 911
Joined: Aug 05, 2011
Location: Aggieland, Texas

Re: Mixing Events and data

And here's the data that SQL says it has:
    SQL-OUTPUT: Dakota Binary Input , Trigger ->True = Driveway trip=0.75, False Driveway Trip=0 (1 minute delay)
    id strftime('%Y-%m-%d-%H:%M:%S',ts,'localtime') binaryinput1
    ---------- -------------------------------------------- ------------
    920 2016-11-07-18:12:42 True
    921 2016-11-07-18:12:45 False
    922 2016-11-08-18:06:20 True
    923 2016-11-08-18:06:21 False
    924 2016-11-08-18:28:35 True
    925 2016-11-08-18:28:38 False
    926 2016-11-09-07:45:27 True
    927 2016-11-09-07:45:30 False
    928 2016-11-09-16:02:26 True
    929 2016-11-09-16:02:28 False
    930 2016-11-09-16:31:49 True
    931 2016-11-09-16:31:51 False
    932 2016-11-09-17:24:01 True
    933 2016-11-09-17:24:02 False
    934 2016-11-09-18:03:34 True
    935 2016-11-09-18:03:37 False
    936 2016-11-10-06:40:04 True
    937 2016-11-10-06:40:07 False
    938 2016-11-10-13:22:20 True
    939 2016-11-10-13:22:20 False
    940 2016-11-10-18:06:02 True
    941 2016-11-10-18:06:05 False
    942 2016-11-10-18:36:38 True
    943 2016-11-10-18:36:39 False
    944 2016-11-11-05:38:11 True
    945 2016-11-11-05:38:13 False
    946 2016-11-11-06:34:20 True
    947 2016-11-11-06:34:22 False
    948 2016-11-11-15:44:36 True
    949 2016-11-11-15:44:39 False
    950 2016-11-11-19:32:47 True
    951 2016-11-11-19:32:51 False
    952 2016-11-12-09:31:09 True
    953 2016-11-12-09:31:11 False
    954 2016-11-12-11:45:21 True
    955 2016-11-12-11:45:21 False
    956 2016-11-12-12:27:37 True
    957 2016-11-12-12:27:39 False
    958 2016-11-12-17:55:55 True
    959 2016-11-12-17:55:58 False
    960 2016-11-13-08:13:19 True
    961 2016-11-13-08:13:21 False
    962 2016-11-13-09:25:46 True
    963 2016-11-13-09:25:49 False
    964 2016-11-13-09:33:54 True
    965 2016-11-13-09:33:57 False
    966 2016-11-13-09:52:24 True
    967 2016-11-13-09:52:26 False
    968 2016-11-13-10:23:10 True
    969 2016-11-13-10:23:13 False
    970 2016-11-13-11:37:02 True
    971 2016-11-13-11:37:05 False
    972 2016-11-13-14:37:57 True
    973 2016-11-13-14:38:00 False
    974 2016-11-13-16:10:19 True
    975 2016-11-13-16:10:20 False
    976 2016-11-13-17:53:27 True
    977 2016-11-13-17:53:30 False
    978 2016-11-13-20:51:45 True
    979 2016-11-13-20:51:49 False
    980 2016-11-13-20:59:05 True
    981 2016-11-13-20:59:07 False
    982 2016-11-13-21:04:00 True
    983 2016-11-13-21:04:03 False
    984 2016-11-14-05:30:31 True
    985 2016-11-14-05:30:33 False
    986 2016-11-14-07:49:58 True
    987 2016-11-14-15:36:34 False
    988 2016-11-14-17:01:36 True
    989 2016-11-14-17:01:39 False
    990 2016-11-15-06:34:46 True
    991 2016-11-15-06:34:48 False
    992 2016-11-15-17:33:27 True
    993 2016-11-15-17:33:32 False
    994 2016-11-15-18:01:28 True
    995 2016-11-15-18:01:30 False
    996 2016-11-16-04:11:18 False
    997 2016-11-16-04:43:15 False
    998 2016-11-16-07:48:14 True
    999 2016-11-16-07:48:17 False
    1000 2016-11-16-16:53:53 True
    1001 2016-11-16-16:53:56 False
    1002 2016-11-16-18:07:36 True
    1003 2016-11-16-18:07:39 False
    1004 2016-11-17-05:41:52 True
    1005 2016-11-17-05:41:55 False
    1006 2016-11-17-06:38:54 True
    1007 2016-11-17-06:38:56 False
    1008 2016-11-17-17:53:51 True
    1009 2016-11-17-17:53:54 False
    1010 2016-11-17-18:18:59 True
    1011 2016-11-17-18:19:02 False
    1012 2016-11-18-05:36:43 True
    1013 2016-11-18-05:36:46 False
    1014 2016-11-18-06:44:23 True
    1015 2016-11-18-06:44:26 False
    1016 2016-11-18-16:15:42 True
    1017 2016-11-18-16:15:44 False
    1018 2016-11-18-17:56:21 True
    1019 2016-11-18-17:56:23 False


    SQL-OUTPUT: VAR Driveway Trip
    id strftime('%Y-%m-%d-%H:%M:%S',ts,'localtime') value
    ---------- -------------------------------------------- ----------
    528 2016-11-07-16:48:14 0
    529 2016-11-07-18:12:42 .75
    530 2016-11-07-18:13:45 0
    531 2016-11-08-18:06:20 .75
    532 2016-11-08-18:07:21 0
    533 2016-11-08-18:28:35 .75
    534 2016-11-08-18:29:38 0
    535 2016-11-09-07:45:27 .75
    536 2016-11-09-07:46:30 0
    537 2016-11-09-16:02:26 .75
    538 2016-11-09-16:03:50 0
    539 2016-11-09-16:31:49 .75
    540 2016-11-09-16:32:51 0
    541 2016-11-09-17:24:01 .75
    542 2016-11-09-17:25:02 0
    543 2016-11-09-18:03:34 .75
    544 2016-11-09-18:04:37 0
    545 2016-11-10-06:40:04 .75
    546 2016-11-10-06:41:07 0
    547 2016-11-10-13:22:20 .75
    548 2016-11-10-13:23:20 0
    549 2016-11-10-18:06:02 .75
    550 2016-11-10-18:07:05 0
    551 2016-11-10-18:36:38 .75
    552 2016-11-10-18:37:39 0
    553 2016-11-11-05:38:11 .75
    554 2016-11-11-05:39:13 0
    555 2016-11-11-06:34:20 .75
    556 2016-11-11-06:35:22 0
    557 2016-11-11-15:44:36 .75
    558 2016-11-11-15:45:39 0
    559 2016-11-11-19:32:47 .75
    560 2016-11-11-19:33:51 0
    561 2016-11-12-09:31:09 .75
    562 2016-11-12-09:32:11 0
    563 2016-11-12-11:45:21 .75
    564 2016-11-12-11:46:19 0
    565 2016-11-12-12:27:37 .75
    566 2016-11-12-12:28:39 0
    567 2016-11-12-17:55:55 .75
    568 2016-11-12-17:56:58 0
    569 2016-11-13-08:13:19 .75
    570 2016-11-13-08:14:21 0
    571 2016-11-13-09:25:46 .75
    572 2016-11-13-09:26:49 0
    573 2016-11-13-09:33:54 .75
    574 2016-11-13-09:34:57 0
    575 2016-11-13-09:52:24 .75
    576 2016-11-13-09:53:26 0
    577 2016-11-13-10:23:10 .75
    578 2016-11-13-10:24:13 0
    579 2016-11-13-11:37:02 .75
    580 2016-11-13-11:38:04 0
    581 2016-11-13-14:37:57 .75
    582 2016-11-13-14:39:00 0
    583 2016-11-13-16:10:19 .75
    584 2016-11-13-16:11:20 0
    585 2016-11-13-17:53:27 .75
    586 2016-11-13-17:54:30 0
    587 2016-11-13-20:51:45 .75
    588 2016-11-13-20:52:49 0
    589 2016-11-13-20:59:05 .75
    590 2016-11-13-21:00:07 0
    591 2016-11-13-21:04:00 .75
    592 2016-11-13-21:05:03 0
    593 2016-11-14-05:30:30 .75
    594 2016-11-14-05:31:33 0
    595 2016-11-14-07:49:58 .75
    596 2016-11-14-15:38:03 0
    597 2016-11-14-17:01:36 .75
    598 2016-11-14-17:02:39 0
    599 2016-11-15-06:34:45 .75
    600 2016-11-15-06:35:48 0
    601 2016-11-15-17:33:27 .75
    602 2016-11-15-17:34:31 0
    603 2016-11-15-18:01:28 .75
    604 2016-11-15-18:02:30 0
    605 2016-11-16-05:46:19 0
    606 2016-11-16-07:48:14 .75
    607 2016-11-16-07:49:17 0
    608 2016-11-16-16:53:53 .75
    609 2016-11-16-16:54:56 0
    610 2016-11-16-18:07:36 .75
    611 2016-11-16-18:08:39 0
    612 2016-11-17-05:41:52 .75
    613 2016-11-17-05:42:55 0
    614 2016-11-17-06:38:54 .75
    615 2016-11-17-06:39:56 0
    616 2016-11-17-17:53:51 .75
    617 2016-11-17-17:54:54 0
    618 2016-11-17-18:18:59 .75
    619 2016-11-17-18:20:02 0
    620 2016-11-18-05:36:43 .75
    621 2016-11-18-05:36:46 0
    622 2016-11-18-06:44:23 .75
    623 2016-11-18-06:44:26 0
    624 2016-11-18-16:15:42 .75
    625 2016-11-18-16:15:44 0
    626 2016-11-18-17:56:21 .75
    627 2016-11-18-17:57:23 0

Posted on
Mon Nov 21, 2016 10:44 am
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: Mixing Events and data

when you upgrade to i7 please make sure you update the path to the SQLite database in config:
Code: Select all
/Library/Application Support/Perceptive Automation/Indigo 6/Logs
should be changed to
Code: Select all
/Library/Application Support/Perceptive Automation/Indigo 7/Logs


this option was added because someone had his SQLlite database in some other place (not in the indigo directory)

Karl
Attachments
Screen Shot 2016-11-21 at 10.42.02.png
Screen Shot 2016-11-21 at 10.42.02.png (10.03 KiB) Viewed 1692 times

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 1 guest