Production of temperature control system with Raspberry Pi and ESP32 (1)

Beginning

The products I handle at my place of employment are so severe that they become defective even if the temperature fluctuates by 2 to 3 degrees Celsius. We have more than 10 thermometers in the three rooms used for work and manage them 24 hours a day.

I made similar software before making this system, but I didn't think about data import in particular. Because there was work to collect temperature and humidity data once a week and put it together in Excel, which was troublesome. We will make a new version with Raspberry Pi and ESP32 that integrates temperature and humidity collection → recording → display → analysis.

Overview

温度管理システム.png Using Raspberry Pi as a server, SHT31 was attached and placed in each position Sends temperature and humidity from the ESP32 to the Raspberry Pi.

Use a browser and Excel to display.

The browser only displays the current temperature and humidity and update time for each position. Previous versions of this also displayed graphs, but I don't see them all the time, so Since it is sufficient for the current situation to notify only when there is an abnormality, the minimum information will be displayed.

Excel imports SQLite data directly from VBA so that graphs can be updated automatically. In the previous version, this was exported as a CSV file one by one. It was difficult to copy and paste, so I unified it.

For me, the work of extracting a CSV file from software and copying and pasting it into Excel is I don't think it's smart to use macros.

Download the extension file that runs SQLite in Excel from the following reference site. Link

By using this extension file, you can bring data directly from the database to an Excel sheet.

Get the parts you need

Beta version must be made by yourself. So I can't buy M5Stack because of my budget. Except for the temperature / humidity sensor, we make it with cheap parts (; ∀;)

Necessary parts

Raspberry Pi B +

I will use the one that was at home. ESP32 I bought it on Amazon. Link

SHT31 temperature / humidity sensor module

I bought it at Akizuki Denshi. Link

Universal board 6x8 cm

I bought it on Amazon. Link

100 μf electrolytic capacitor

Use the one that suits your home.

Battery box

I bought it on Amazon. Link

AA batteries

I will use the one I bought properly.

ssd1306 (OLED organic display)

I bought it on Amazon. Link

Jumper wire

I bought it on Amazon. Link

2.1mm DC jack female

I bought it at Akizuki Denshi. Link

2.1mm DC jack male

I bought it at Akizuki Denshi. Link

What kind of parts do you need? Next time, I will design before the parts come.

Recommended Posts

Production of temperature control system with Raspberry Pi and ESP32 (1)
Production of temperature control system with Raspberry Pi and ESP32 (2) Production of transmission device
Creating a temperature control system with Raspberry Pi and ESP32 (3) Recipient Python file
Get temperature and humidity with DHT11 and Raspberry Pi
Measure CPU temperature of Raspberry Pi with Python
Record temperature and humidity with systemd on Raspberry Pi
Measure temperature and humidity with Raspberry Pi3 and visualize with Ambient
[Raspberry Pi] Stepping motor control with Raspberry Pi
Servo motor control with Raspberry Pi
Measure and compare temperature with Raspberry Pi and automatically generate graph
Easily make a TweetBot that notifies you of temperature and humidity with Raspberry Pi + DHT11.
Notify LINE of body temperature from BLE thermometer with Raspberry Pi # 1
Notify LINE of body temperature from BLE thermometer with Raspberry Pi # 2
Graph display of household power consumption with 3GPI and Raspberry Pi
Pet monitoring with Rekognition and Raspberry pi
MQTT RC car with Arduino and Raspberry Pi
CSV output of pulse data with Raspberry Pi (CSV output)
Get CPU information of Raspberry Pi with Python
Raspberry + am2302 Measure temperature and humidity with temperature and humidity sensor
Simple VPN construction of IPsec gateway with Ubuntu 20.04 and Raspberry Pi ―― 1. StrongSwan introduced
I tweeted the illuminance of the room with Raspberry Pi, Arduino and optical sensor
GPGPU with Raspberry Pi
DigitalSignage with Raspberry Pi
Raspberry Pi system monitoring
Machine learning with Raspberry Pi 4 and Coral USB Accelerator
Easy IoT to start with Raspberry Pi and MESH
Detect mask wearing status with OpenCV and Raspberry Pi
Control brushless motors with GPIOs on Raspberry Pi Zero
Take the value of SwitchBot thermo-hygrometer with Raspberry Pi
Log the value of SwitchBot thermo-hygrometer with Raspberry Pi
Ubuntu 20.04 on raspberry pi 4 with OpenCV and use with python
Control power on / off of USB port of Raspberry Pi
Installation of Docker on Raspberry Pi and L Chika
Install pyenv on Raspberry Pi and version control Python
Getting Started with Yocto Project with Raspberry Pi 4 and WSL2
Troubleshoot with installing OpenCV on Raspberry Pi and capturing
Let's operate GPIO of Raspberry Pi with Python CGI
Version control of Node, Ruby and Python with anyenv
Simulate temperature measurement with Raspberry Pi + Flask + SQLite + Ajax
Simple VPN construction of IPsec gateway with CentOS 8 and openSUSE (Raspberry Pi) ―― 1. StrongSwan introduced
Simple VPN construction of IPsec gateway with Ubuntu 20.04 and Raspberry Pi --2 StrongSwan VPN connection confirmation
Easy introduction to home hack with Raspberry Pi and discord.py
Mutter plants with Raspberry Pi
Create your own IoT platform using raspberry pi and ESP32 (Part 3) ~ ESP32 settings Analog temperature sensor
Create a web surveillance camera with Raspberry Pi and OpenCV
Python beginner opens and closes interlocking camera with Raspberry Pi
Control the display of RGB LED matirix electric bulletin board freely with Raspberry Pi 3B +
I tried running Movidius NCS with python of Raspberry Pi3
Create an LCD (16x2) game with Raspberry Pi and Python
I tried connecting Raspberry Pi and conect + with Web API
I tried using the DS18B20 temperature sensor with Raspberry Pi
Creating a temperature / humidity monitor with Raspberry Pi (pigpio version)
A program that receives the servo command of the radio control, interrupts the Raspberry Pi and logs it
Building a distributed environment with the Raspberry PI series (Part 2: PiServer analysis and alternative system design)
Image recognition of garbage with Edge (Raspberry Pi) from zero knowledge using AutoML Vsion and TPU
Measure temperature, humidity, etc. with SensorTag and send it to Ambient via Raspberry Pi 3 to graph it Part 2
Control the motor with a motor driver using python on Raspberry Pi 3!
I tried to automate the watering of the planter with Raspberry Pi
I learned how the infrared remote control works with Raspberry Pi
Christmas classic (?) Lighting a Christmas tree with Raspberry Pi and Philips Hue
Make a thermometer with Raspberry Pi and make it viewable with a browser Part 4