Today I finished programming the essentials for my website. I have added Biology, Spanish, Catalan, Technology, Index, English, and I have updated everything that was pending. I also added the image for Biology, which uses little carbon dioxide and has low energy consumption. Yesterday Jordi taught me everything I needed to start my website. Later I will create my farm, that is, we will use the school garden, and then, if we have time, we can create a server with the Steamackers, which will be connected to the school's Wi-Fi. And if I can choose, I will connect as many AIs as possible so they can give me answers from anywhere in the world, for what purpose, I don't really know.
Day 2
Today I tested the temperature sensor that is next to the humidity one, meaning they are all-in-one. Then I used the soil moisture meter which wasn't working; it was showing zero all the time. Also, the light detector; we will use the humidity sensor to see if the plants need water to activate the water pump to irrigate them, logically, right? I'll probably try other moisture sensors and we will finish testing everything and we will test the LoRa transmitter that will send us information every 1 or 3 minutes according to Spanish law.
Day 3
Today we tried to program the LoRa with the boards but it was a mess because we don't know it, we will know tomorrow barely how to transfer the data from the garden to the base plate which will be placed automatically from JSON, so we automate it, we will place an external battery and if we can we will place solar panels because the LoRa can only send information every 2-5 minutes due to Spanish law. To be honest, I feel lazy to place everything I do every day because I'm very sleepy.
Day 4
Today we connected the LoRa system to the base board and finally started receiving data from the garden, which was quite exciting since until now we had only tested components separately. We powered on the system and saw that it began sending information automatically as planned. We tested several sensors; some worked well, others didn’t respond properly, so we disconnected and swapped them until we kept the ones giving consistent readings.We also installed the external battery so the system can stay powered without relying on the computer. During the tests, we noticed the LoRa sent data with a slight delay, but within the limits allowed by the regulations. We let it run for a good while to make sure everything stayed stable. There are still some details to adjust and we need to see how it performs over longer periods, but for now, we’re happy because everything is starting to work as it should. Little by little, the project is taking shape.
Day 5
Today we took a major step forward in the project by starting to work with Apps Script to manage all the information sent by the LoRa system. The idea is to automate data processing to avoid doing it manually, saving time and reducing errors. First, we set up a script that receives data transmitted by LoRa and automatically organizes it into a Google Sheets spreadsheet. This allows us to centralize all the information and keep it well organized for easy access at any time. After getting the spreadsheet up and running, we focused on creating a connection between the sheet and our website. This way, we can display the data in real time in a visual and accessible way, without needing to access the sheet directly. This integration will help us monitor the garden’s status from any internet-connected device. Although there are still many improvements and details to refine, today we successfully connected the three main parts of the system: data capture with LoRa, storage and processing with Apps Script and Google Sheets, and presentation on the web. Without a doubt, a very productive day that brings us closer to having a fully automated and functional system.
