Bruno84
(Bruno84)
December 31, 2021, 9:00pm
572
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
1 Like
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.
111197
(민주 김)
July 13, 2022, 4:02am
575
Hello,
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
I’m sorry
Thank you.
JohnS55
(John Skpp)
January 12, 2023, 5:00pm
576
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. ?
thanks
John.
MarkTr
(MarkTr)
January 12, 2023, 5:29pm
577
Groovy SmartApps were just shut off.
JohnS55
(John Skpp)
January 12, 2023, 5:42pm
578
MarkTr
(MarkTr)
January 12, 2023, 5:52pm
579
Here’s one alternative; I don’t recall seeing anyone working on a new logger for Sheets though.
I’ve been working on an integration between SmartThings and https://www.constantgraph.com (which is a cloud based logging and graphing site for home automation). ConstantGraph has been working with the Ezlo/Vera platform for a while now but this is the first attempt to hook it up to SmartThings.
Is anyone interested in testing it out and giving feedback on how well the integration works? The service is completely free. Of particularly interest is anyone who has a whole home energy meter capable of logging at at least every 30 seconds or better (e.g. Aeotec HEM) as there is a feature to “disaggregate” the energy signature into the individual devices (even if there are not smart).
Once you have created an account there is an option on the account page to connect to your SmartThings acco…
MarkTr
(MarkTr)
January 12, 2023, 6:00pm
580
I missed this one - it might be a hassle if you don’t already have something set up that can host the smart app.
Hi, @wptracy
Sorry for the delay. I had to go through the code of the Google sheets logger app and implement one on my side to see if it was possible using a SmartApp in the “new platform”.
First, as a reference SmartApps that use the NodeJS SDK can also:
Create subscriptions to device events and others
Send commands to devices from there depending on the scopes of its Access Token which you define during installation/update.
Send REST requests as they use NodeJS.
I was able to implement a simple SmartApp to log events into a Google sheet, there are other functionalities in the original one but I omitted them for testing purposes.
Here, you’ll find the SmartApp definition I used:
As evidence, here’s the data registered in the Google Sheet compared to the device history:
[image] […
fido
(Mike )
January 12, 2023, 6:04pm
581
@TAustin has something but for the life of me i cannot find the post… its somewhere on the board
Found it
Many of us used a nice SmartApp called Simple Event Logger to post SmartThings info to a Google spreadsheet. Now what? Is there a way to do this that doesn’t require a SmartApp?
The answer is yes, with the catch that you need a SmartThings hub and an intermediate computer to bridge between Edge devices and Googlesheets. On your always-on computer like a Raspberry Pi or other, you run a very small, 30-line nodeJS app that will accept HTTP posts from Edge containing the event info and it will use the Google API to post the contents to your spreadsheet.
How do you send the HTTP requests from Edge? You can use my Webrequestor or HTTP Devices drivers, which can be configured with the event info you want (text, number, boolean). The info is appended as a row in your spreadsheet along wit…
1 Like