Github project repository
Added: “Google Sheet script for month-to-month data logging.md.” File is copied into Google App script editor. Before pasting into editor; erase any existing code in the Google script editor. Replace new sheet_id with sheet_id where Google App script was placed. For more detailed information see article:
"ESP32 Data Logging to Google Sheets with Google Scripts"
Author: IOTDesignPro
Project would have been impossible for me without the help of people from community; arduino.cc Forum, Adafruit.com Forum, ESP8266 Forum, Github.com, Random Nerd Tutorials Forum. Project started back in the Fall of 2013; with gifted "Arduino Uno." Thank you to all the people that have helped with the project!
Project served from ESP32 Project web site severed from ESP32.
Project web site served by Free Hosting Service
"CameraRainGauge.ino" was developed to provide a data logger accessible over the Internet, with graphing, capability to manage files via file transfer protocol (FTP), over-the-air (OTA) firmware updates, supports two web sites, webRTC video feed, and uploading data to Google Sheets!
Heart of the project is task management; this is accomplished using network time protocol (NTP) servers to set ESP32 system time. UDP packets from the NTP server are decoded into MONTH,DATE, YEAR, HOUR, MINUTE, and SECOND. Conditional "if" statement "if((MINUTE % 15 == 0) && (SECOND==0))" are used to execute tasks at specified number of minutes and seconds; this statement evaluates "true" every fifth teen minutes and zero seconds. NTP is used to automatically configure time zone and daylight-saving time., plus date-time stamps.
Live video feed: Camera view option of project
Camera used for video streaming is a Wyse Cam v3. My method of video streaming is a little different; with a Raspberry Pi 4 running Portainer with a Docker, container, “Wyze-Bridge.” Container interfaces with your “Wyze” account; using your “Wyze” app account credentials to capture the H.264 video stream and provide webRTC URL’s that can be embedded in a web page. “Wyze-Bridge” is specific to the “Wyze” cameras and does not need “Wyze” RTSP firmware.
AsyncWebServer handles "GET" requests from the Internet and processing of web pages.
William
CameraRainGauge.ino project updated 07/31/2023.
-
- Posts: 17
- Joined: Thu Aug 03, 2023 3:14 am
- Location: Indianapolis, IN
- Contact:
Who is online
Users browsing this forum: No registered users and 49 guests