I haven’t seen a BATTERY status report in SEL since 23 Oct.
I just noticed the same thing, nothing logged since 10/27/2020. I don’t think I am seeing a fix for this at the current time unless I am missing something.
Hi Kevin, @krlaframboise,
I already know that this smartapp will stop working when groovy disappears and that battery events are no longer captured because they are not in the event history. The rest still works fine.
There are many of us who still use app so as not to lose the graphics that we already have made for a long time…
To avoid the loss of device event capture due to frequent delays or stops in the smatthings event history server during the month of July and possible future failures, I have modified the Simple Event Logger app to version 1.6, to set the start time of the next event capture period (startDate variable) at the time of the last event captured + 1 sec.
In this way, if the event history is stopped or delayed, the time of the last event captured will be kept as the startDate value and no events will be lost when the history is restored.
The end time of the capture period (endDate variable) remains to the current time + the time selected as the events capture frequency.
I’ve tested it and it works fine, no live logging errors and no duplicate or missing events on google sheet appears.
If you want to review and publish the modification I will send you the link or if you want I will publish it here.
Thanks for your app
Hi @Mariano_Colmenarejo , thanks a lot for this improvement!
@krlaframboise, I am are aware you have discontinued the support for the tool, but I can’t stress enough how useful this still is today. So, I guess we will keep on using until it breaks!
I got very interested in Mariano’s modification above, so I wonder if that is ok for you that I run some tests with his version? Thank you!
I’m not sure why any changes were necessary because the application already has a catch-up feature built-in which prevents it from missing events when there’s an issue preventing it from logging events.
How long it goes back is controlled by the setting “Maximum Catch-Up Interval” which is located in “Other Options”.
The maximum is currently 6 hours because if you’re logging a lot of devices it will normally time out and never catch up with values higher than that, but if you want a higher number then you could easily add additional intervals on line 298 and around line 590.
It does not recover delayed events, since there are problems of delays in the processing of events, not events missing and therefore the app reports 0 events captured in that period and correct final status, therefore it goes to the next period time and simply considers that there have been no events in that period.
With the modification, what it does now is assign the time of the last event captured as the start time of the new capture period. In this way, even if there are delays in the history, those events are not lost. They Will be captured when they appear in the history.
Here are some snapshots of what happened in July in Europe. App with “Maximum Catch-Up Interval” = 6 hours
That’s a relatively new issue so you’re right about my handler not have a built-in feature to handle that problem.
The change you made could potentially cause problems for a couple of rare scenarios and I don’t have time to review and test your version so I won’t be adding it to the SmartApp.
I’m sure there are others that are interested in the changes you made, but I’d rather not have 2 instances of the SmartApp linked to on this topic so I’d appreciate it if you could PM the code/link to any users that request it.
thank you for your code: It’s simple but very powerful. I’ve acquired a Sonoff TH16 and now I can register external temp of my home.
I write here because I have some trouble with registered data. Today is 30 december 2021: at 16:37 I read 1640878657000 in Google Sheet. I can’t understand to convert this number (I haven’t discovery any information about this format). In addition: If I connect my Google Sheet with Google Data Studio for the same number I read 30 december 2021 15:37 (there is a difference of 1 hour). Can you help me? .
Sorry and Happy New Year,
This is a typical Java time value: (Unix epoch time) * 1000 + milliseconds.
1640878657 is the epoch time (Thursday, December 30, 2021 3:37:37 PM UT) and 000 milliseconds. Things typically display it in your local timezone, taking into account if DST is active.
Did @jlv’s reply provide you enough information to solve your problem?
Hi @krlaframboise and @jlv ,
thank you and sorry for the delay. Yes, jlv’s reply help me.
EDIT 02/01/2022 For all (in MS Excel or similar)
From Java Time to Excel Time
- Divide number / 1000 to obtain seconds => 1640878657000 / 1000 = 1640878657
- Divide number / 86400 to obtain days => 1640878657 / 86400 = 18991,65112
- Sum number and 01/01/1970 00:00 => 18991,65112 + 25569,00 = 44560,65112
- Format data dd/mm/yyyy hh:mm => 30/12/2021 15:37
Happy new year
Quick question, is there a way to limit the number of events? The temp sensors I am pulling data from are coming less than every minute. I only need them once a day. Thanks so much! This SmartApp is wonderful!
Unless you need the device to report that often you should check the device’s settings to see if it has threshold or interval settings that can be adjusted because that’s most likely hurting the battery life.
That being said, I think the other settings section of the app has a setting for the number of events so it could be set to 1, but that’s a global setting so doing that would impact all devices being logged.
We are really grateful for monitoring various indoor environments and using them for the district.
Particulate matter data(dust, fine dust, …) cannot be collected, how can I fix this part?
I am sorry that I know very little about coding
My Simple Event Logger (and Google Sheets Logger) has been working great until yesterday 11 Jan 2023.
Can anyone advise if this due to platform changes or has something gone wrong at my end. ?
Groovy SmartApps were just shut off.
So sad and reeaalllly frustrating. Is there hope of a similar app on the new platform ?
Here’s one alternative; I don’t recall seeing anyone working on a new logger for Sheets though.
I missed this one - it might be a hassle if you don’t already have something set up that can host the smart app.
@TAustin has something but for the life of me i cannot find the post… its somewhere on the board