Differences
This shows you the differences between two versions of the page.
|
iothings:proiecte:2023sric:loratrackingsystem [2024/05/30 01:51] sebastian.matusa [The Things Network Application] |
iothings:proiecte:2023sric:loratrackingsystem [2024/05/30 01:56] (current) sebastian.matusa [Google Sheets Data] |
||
|---|---|---|---|
| Line 278: | Line 278: | ||
| - | ==== Google Sheets Script ==== | + | |
| + | ==== Google Sheets ==== | ||
| + | The data received in Google Sheets includes the following fields: Device ID, Application ID, Device EUI, Device Address, Received At, Port, Undecoded Payload, SSIDs, Gateway ID, EUI, RSSI, SNR, Latitude, Longitude, and Altitude of the gateway. | ||
| + | |||
| + | === Google Sheets Script === | ||
| <code> | <code> | ||
| Line 407: | Line 411: | ||
| The primary purpose of this script is to collect and organize data from LoRaWAN devices into a structured format within a Google Sheets spreadsheet. It handles both the data from the devices themselves (including SSIDs detected by the devices) and metadata from the gateways that received the uplink messages, ensuring all relevant information is logged efficiently. | The primary purpose of this script is to collect and organize data from LoRaWAN devices into a structured format within a Google Sheets spreadsheet. It handles both the data from the devices themselves (including SSIDs detected by the devices) and metadata from the gateways that received the uplink messages, ensuring all relevant information is logged efficiently. | ||
| - | === Google Sheets Data === | + | |
