Ross

@MrBill's idea of having a node server log to Google Sheets is something I've been hoping would happen for a while (I requested it a couple of years ago). I was successful in logging to GS with Network Resources and IFTTT, but it was cumbersome. While at it, it would be nice to go the other way - type a number in Google Sheets and have it write to a variable (I can do this with Rest; however, it then takes me to another webpage and I'd rather it stay right there. I've looked at @Bumbershoot's CSV. However, I couldn't figure out a way to "automatically" get the CSV to a Google Sheet so I can see it when I'm away from home. Maybe there's a simple step that I'm missing. I will make my requests under Product Requests per @Geddy's advice.

There are many folks just coming to this board for the first time and it pains me that they get castigated - they are totally freaking out! The 2nd sentence is fairly helpful but the first is quite unnecessary. May we just have a weeklong moratorium on snark while their worlds have been upended? If you can't help yourself, just say something like <snark omitted> to get it off your chest and then type the helpful part.

Carealtor, Have you heard of the dyslexic, agnostic, insomniac? He stayed up all night wondering if there was a dog. I would go back and edit my mistake, but then no one would understand the context of this post. Thanks, Ross

lilyoyo1, Regarding the security issue and shutdown of PCG, I have not seen an update nor any indication of when an update may be forthcoming. I understand I have to read them; however, the official announcement by Michael has 0 replies. That's why I jumped to this topic because it's the only other one I've found that was in the same boat. I will keep looking. I get that many answers are "somewhere in the forum"; but, unfortunately for casual users, it's not always innate for us to know where to look for things in the forum. The answer could be on the 18th page of 28. I have read many of your posts (not all 5,400 of them) and I appreciate your contributions to this board. I also realize that I may be the only one with my issue. I've already posted a comment to the developer on, I believe, the appropriate board and I need to have patience for the response. Thank you, Ross

I would be pleased if someone would either give a periodic update or let us know when to expect an update as to when those nodeservers will be available either on PGC or the Polisy nodeserver. I'm using the PCG Sonos Controller written by Simplextech which has more features (e.g., playlists) than the one on the Polisy nodeserver. I understand mine is a 1st world problem! Newb here. I'm not sure why there are 3 nodeservers (PCG, Polisy, PG3). Do the NS's have to be written differently for each? Thank you, Ross

ISY Newbie, Every event will trigger the ISY to review (my newbie word) all of its programs. If the event IS NOT mentioned in the IF section of a program, then that program is ignored and it moves onto the next program (we're talking milliseconds here). If the event IS mentioned in the IF section, then it runs the THEN section if all of the IF section is true or the ELSE section if any of the IF section is false. Bonus information - Not that you asked, but any change in a State variable is considered an event (thus triggering the ISY to run programs that contain that State variable in the IF section). However, if an integer variable changes, it is not considered an event. Regards, Ross

ISY Newbie, Since I am a newbie myself, I will talk "Newbie" to you as that is the only language I know... You are absolutely right - the From/To phrase makes you think that it will check continuously. I thought the same thing myself. However, it doesn't (thank you MrBill for explaining it to me). The program evaluates only at those 2 times (sunset and next day's sunrise). When lilyoyo1 said the ISY is event driven, he means that something has to happen (a certain time, light-on, light-off or, really, any condition that the ISY knows about) has to occur which then triggers the ISY to go through its programs to see if any program should be evaluated because something (an event) happened. Your original question was about the ISY checking continuously throughout the night and turning a light back on "at some point" if it's turned off. Since the ISY won't check continuously but, with a tweak, can evaluate its programs when the light is turned off (this is considered an event), we need to incorporate that info into the program. Asbril's first post has the appropriate program. He just used "Wait 2 minutes" because you said "at some point". However, you can use any interval you want with a minimum of 1 second. TrojanHorse - post #2 is completely accurate; however, it's written above newbie level. I understand what you said there, but I don't think it would have sunk in during my first few weeks of programming. I hope this is helpful, Ross

MrBill, I'd like to understand your sentence "In your example..." as I'm confused by the From... To... I believe what your saying is that my program below would only run the Then at 8am and the Else at 2pm. However, as long as it's between 8-2, the fans will turn on when the temp hits 75 - could be 9am or 11:30am. I'm missing something but I don't know what. Will you please explain what is happening? Thank you, Ross

Gary, Near the bottom of the "DarkSky Acquired by Apple" forum topic, I asked about a Weatherlink IP nodeserver. There, I provided the api documentation to Bob. He is going to take a look. Thanks, Ross ,