SmartThings Community

rebelbah · 2019-01-10 13:56:51 UTC

Hi All
Has anyone been able to use the Aeotec HEM v1 to log to a spread sheet, either local or to a cloud service such as onedrive or google drive

greg · 2019-01-10 14:11:13 UTC

I think these are probably the two most popular.

[RELEASE] Simple Event Logger Community Created SmartApps

Simple Event Logger is a fully customizable SmartApp that allows you to accurately log all device activity to a Google Sheets Spreadsheet. Each event is stored on a separate row so that you have their exact time and details. Google Sheets has an easy to use filter feature which allows you to do things like view all events for specific device(s), in a specified date/range and/or specific types of events like temperature. Since all of your data will be stored in one spreadsheet, advanced users can easily generate pivot tables and graphs for any information they need. It also eliminates the need to update the code in multiple spreadsheets every time a new version is released. See the Installation Instructions for a complete list of features that make this SmartApp unique. This SmartApp wa…

Here is a “round up” that doesn’t include SEL. I think some of the other information might be outdated as well. I think Plotwatt plotzed

ROUNDUP: Data Logging and Charting Solutions FAQ

There’s loads of data logging and charting solutions, so I thought I’d create an index. Reply with any solutions I’ve missed and I will update this post. Amazon DynamoDB [cloud (free/paid)]: Elastic Stack (LogStash+Beats+Elasticsearch+Kibana) [private (free) / cloud (paid)]: Can’t see a specific thread on the community, but here’s a github link: Google Sheets [cloud (free)]: [image] GroveStreams [cloud (free/paid)]: [image] InfluxData TICK Stack (Telegraf+InfluxDB+Chronograf+Kapacitor ) + Grafana [private (free) / cloud (paid)]: [image] Initial State [cloud (free/paid)]: [image] PlotWatt [cloud (free/paid)]: Note: PlotWatt is discontinuing its support for 3rd party residential energy monitors on March 31st, 2017 [image] ThingLayer [cloud (free)]: D…

rebelbah · 2019-01-10 14:48:13 UTC

found this after doing a google search, logs to google spread sheet

github.com

krlaframboise/SmartThings/blob/master/smartapps/krlaframboise/simple-event-logger.src/ReadMe.md#simple-event-logger

<h1 id="simple-event-logger">Simple Event Logger - v1.4.1</h1>
<p>By Kevin LaFramboise (krlaframboise)</p>

<p><img align="right" src="https://raw.githubusercontent.com/krlaframboise/Resources/master/simple-event-logger/app-SimpleEventLogger@3x.png" alt="Simple Event Logger Logo" />The Simple Event Logger is a fully customizable SmartApp that allows you to accurately log all device activity to a Google Sheets Spreadsheet.  Each event is stored on a separate row so that you have their exact time and details.</p>

<p>Google Sheets has an easy to use filter feature which allows you to do things like view all events for a specific device(s), in a specified date/range and/or specific types of events like temperature.</p>

<p>Since all of your data will be stored in one spreadsheet,advanced users can easily generate pivot tables and graphs for any information they need.  It also eliminates the need to update the code in multiple spreadsheets every time a new version is released.</p>

<hr>

<h2>Menu</h2>

<ul>
	<li><a href="#features">Features</a></li>
	<li>Installation<br>
		<ul>
			<li><a href="#google-sheets-setup">Google Sheets Web App Installation</a></li>
			<li><a href="#smartapp-setup">SmartApp Installation</a></li>			
		</ul>

This file has been truncated. show original

Aeotec home energy meter V1(DSB09104-ZWUS) log to spread sheet