Open Island

this one work, and can parsing field data with json, it first has to run setup.  also change your payload based on the data field. The problem I met is that the decode data is not shown, same as the down link url https://blog.squix.org/2017/07/thethingsnetwork-how-to-use-google-spreadsheet-to-log-data.html this one is another version originated form above.: https://github.com/Uspizig/Ttn-gooogle-script Nice one: https://github.com/avbentem/libelium-waspmote-lorawan  is a well documented project, there is a section of http to google sheet and run on latest V8 runtime of google app script. https://github.com/avbentem/libelium-waspmote-lorawan/blob/master/src/google-sheets/README.md the code will send email to sheet owner in case of any error. So make sure you adjust the field property correctly.  After modification of  row.push fields. part, it works pretty well. my little question is that since few days, my sensor node always resend 3-4 times as retry. I will look int...

For the device side, if you search on arduino library manager, you will found a lot of libs with very similar names, arduino LMIC, LMIC arduino, lorawan LMIC...etc. if you look on git, there are plenty more...very confusing... I found this good discussion on TTN forum, it gives a clear view of available ones, and their stories, differences.(2020/10/14)   https://www.thethingsnetwork.org/forum/t/overview-of-lorawan-libraries-howto/24692 Currently there are 2 major parents of this kind of libraries: 1. LMiC from IBM   ‘LoRa MAC in C’   , which is a very old one. 2. Semtech LoRaMac-node  the complication:  1. LMIC has been ported to different frameworks. 2. on arduino, the lib mustly work with most MCU supported by arduino. But soem are adapted to specified MCU platform and sometimes different Mac chip. 3. Some of this lib is no longer supported, so you need to find the most updated. 4. Lora spec is upgrading, (slowly getting bigger). So not updated lib w...

https://github.com/things4u/ESP-1ch-Gateway  is a very updated library, this is one of those TTN 1ch forwarders, the most updated as today(2020/09/22). The writer is making the V6 on PlatformIO.  One good thing is that in platformIO the project files will include all the libraries in the project. So that you don't need to take care of the dependency of libs. I used to use arduino, when making larger projects, you will use a lot of libs,  it's not a big problem when you start the project and make it work. But as time gose by, libs would be updated or renewed and get yourself into  troubles of compatibility between libraries. and it's not done yet, some times when arduino board profiles make large change, some libs can fail...especially on newer boards, such esp32/8266... With PlatformIO, we get ride of the compatibility problem, since you include the need libs with correct version into the project, I'm not sure if the board definitions of platfromIO have impact on lib...

I have been trying to work out the TTN in my region which is 923 AS2. spending some time to find out how to make a 1ch gateway, which take only 1ch and 1SF. Now it comes to the node side, most of examples use IBM LMIC and it's variation. IBM LMIC is based on ST MCU, so some porting to arduino IDE. They all have simillar name but with different modification.  and the function to call in arduino are the same, so be very careful to install.(I believe you better have only one on it.) 1. Matthijs Skooij https://github.com/matthijskooijman/arduino-lmic based on LMIC 1.5 providing raw example; used to send lora mac to other, for testing purpose. ttn-abp ttb-otaa No wiki page, but good explaination on readme.md 2. Thomas Telkamp https://github.com/tftelkamp He has 2 git on LMIC, 1. arduino-lmic-v1.5 noted deprecated, and refer reader to Matthijs one.US915/AU915 hybrid mode 2. LoRa-LMIC-1.51 folked from  Forked from  things4u/LoRa-LMIC-1.51  not sure what ...

I have made a 1ch TTN gateway with the my heltec lora oled modules on hand. 1st, I found an working example with my boards from TTN forum: info are here:  http://ldsrc.blogspot.tw/2018/01/lorawan-working-example-from-network.html The major work of 1ch gateway is from here: but in the forum has better steps. http://things4u.github.io/ https://github.com/things4u/ESP-1ch-Gateway-v5.0 For gateway: 1. So, what I did to make it to 433Mhz, is to modify the frequency table in loraModem.h to like this: /* int freqs [] = {  868100000, // Channel 0, 868.1 MHz primary 868300000, // Channel 1, 868.3 MHz mandatory 868500000, // Channel 2, 868.5 MHz mandatory 867100000, // Channel 3, 867.1 MHz 867300000,  867500000,  867700000,  867900000,  868800000,  869525000 // Channel, for responses gateway (10%) // TTN defines an additional channel at 869.525Mhz using SF9 for class B. Not used }; ...