Hi @krlaframboise really enjoying your work here, I use the data in Sheets to populate an interactive Google Data Studio Dashboard (pic below) where you can easily filter results etc.
I’ve had this up and running for 2 days now, but am yet to receive a battery report (despite it all being setup in the app etc). Any ideas why?
Very nice. How easy is it to set up and get it looking like that? (Consider writing a brief set of instructions)
Thanks @jlv . There’s a bit of messing around if you haven’t used data studio before and a few formulas etc, but nothing you couldn’t follow instructions for, plus I could share the above template as a starting point.
Only issue I have at the moment is time, so it’s not something I can do right now, but I’ll definitely put something together up as soon as I can.
That would be appreciated!
No problem!
I will get around to it I promise, just a bit manic with work, COVID and kids atm, but I’ll put something together soon and post the link here. In the meantime checkout how the interactive (mobile) template is developing on the link below:
I’l also be doing a tablet variant soon. My thought’s are that you could also add buttons with webhook hyperlinks to add a degree of dashboard control to something like this, it’s something to think about for the future.
So that’s 3 days with this running now and still no battery reports, is this normal? I’ve set it up to log events every 30 mins if that makes any difference - perhaps too much data to send accross at once? Should I shorten the reporting period perhaps? Any help appreciated 
Is it possible the device is not generating a battery report event? A lot of devices only generate an event if the value changes. Have a look ate the live logging in the IDE. you should see lines like these appear. each time the smartapp runs and doesn’t not find an event to log.
759bf2fc-1e34-4b58-ab2c-6c340998d718 20:48:24: debug SmartThings found 0 events between 10/11/2020 20:43:25 and 10/11/2020 20:48:23
759bf2fc-1e34-4b58-ab2c-6c340998d718 20:43:24: debug SmartThings found 0 events between 10/11/2020 20:38:25 and 10/11/2020 20:43:24
759bf2fc-1e34-4b58-ab2c-6c340998d718 20:38:25: debug SmartThings found 0 events between 10/11/2020 20:33:24 and 10/11/2020 20:38:24
Here is a section where events were generated and logged
759bf2fc-1e34-4b58-ab2c-6c340998d718 11:03:48: debug SmartThings found 0 events between 11/11/2020 10:58:26 and 11/11/2020 11:03:47
759bf2fc-1e34-4b58-ab2c-6c340998d718 10:58:28: debug Google Sheets Web App logged 1 events between 11/11/2020 10:53:23 and 11/11/2020 10:58:25 in 2.485 seconds.
759bf2fc-1e34-4b58-ab2c-6c340998d718 10:58:26: debug SmartThings found 1 events between 11/11/2020 10:53:24 and 11/11/2020 10:58:25, posting them to Google Sheets Web App
759bf2fc-1e34-4b58-ab2c-6c340998d718 10:53:27: debug Google Sheets Web App logged 1 events between 11/11/2020 10:48:23 and 11/11/2020 10:53:23 in 3.746 seconds.
759bf2fc-1e34-4b58-ab2c-6c340998d718 10:53:23: debug SmartThings found 1 events between 11/11/2020 10:48:24 and 11/11/2020 10:53:23, posting them to Google Sheets Web App
759bf2fc-1e34-4b58-ab2c-6c340998d718 10:48:26: debug Google Sheets Web App logged 1 events between 11/11/2020 10:43:23 and 11/11/2020 10:48:23 in 2.732 seconds.
759bf2fc-1e34-4b58-ab2c-6c340998d718 10:48:23: debug SmartThings found 1 events between 11/11/2020 10:43:24 and 11/11/2020 10:48:23, posting them to Google Sheets Web App
759bf2fc-1e34-4b58-ab2c-6c340998d718 10:43:23: debug SmartThings found 0 events between 11/11/2020 10:38:24 and 11/11/2020 10:43:23
759bf2fc-1e34-4b58-ab2c-6c340998d718 10:38:24: debug SmartThings found 0 events between 11/11/2020 10:33:24 and 11/11/2020 10:38:23
BTW, I am logging a temperature sensor at the bottom of my fishpond.
Thanks for the tip, will take look
So still no battery events (or energy for that matter) and logs seem ok, with no ‘0 event found’ entries in live logging, just:
15:29:43: debug SmartThings found 56 events between 12/11/2020 14:59:35 and 12/11/2020 15:29:33, posting them to Google Sheets Web App
I’m perplexed. 
Well, my SEL for batteries was logging battery readings identical to the Google Sheets Logger up through October 27. Since then, I see no more battery events from SEL, while the other Logger has recorded a few dozen other battery readings.
Meanwhile, my SEL for temperature values keeps recording new data.
So it looks like @krlaframboise’s prediction has come true, at least for some types of events.
If you open the device in the IDE and click on events, do you see any for battery? I think there are multiple tabs on the events screen so check them all…
Ok, well doing this was interesting as the first 3 devices I’ve looked at haven’t reported on battery for at least 5 days. So looks as though that is the issue?
The device might be reporting the battery more often than that, but if it’s the same value and the handler is creating the events without isStateChange:true then SmartThings is ignoring them.
I see no events for battery, but I do see other events listed (temperature, acceleration). The device I checked is a SmartThings Multipurpose Sensor (“Garage Door Blue”). The Google Sheets Logger shows it last reported a battery change this morning. In the events in the IDE I see a temperature event at the same time, but no battery event.
Events:
The logging results you’re seeing make sense, but I’m not sure why the battery events aren’t getting logged to the device event history…
My app pulls events from the device’s event history and logs the ones that occured after the last time it ran. My app hasn’t logged any battery events because there aren’t any in the history.
The other app subscribes to the events of each device and logs the most recent event since the last time it sent the events to Google so the device must be creating the events and they’re just not showing up in the device’s event history for some reason.
Strange isn’t it. Maybe a wider platform problem?
I suspect it is planned fallout from the continuing platform changes.
It’s only a matter of time until this app completely stops working so users are better off switching to that other app…
It would be awesome if you’d adjust the main post to reflect this. I’d say a lot of people are wasting time trying it. Thanks for all the work.
I WAS logging 2 sites (1 in UK, 1 in Florida) using Simple Event Logger.
Both seem to have stopped completely early this morning.
I know this has been half expected for some while but is this just my ST account or global?
To make matters yet worse; “Download Personal Data” in the App and importantly the “DeviceActivities.csv” contained also stopped working on or around 20Dec2020, has anyone else experienced this ?
thanks
john
