====== Wanesy SPN templates ======

This page lists the templates to be used with SPN firmware. All CSV files start with a line describing all fields (IN or OUT). IN fields are mandatory to upload a CSV file to the gateway. Each line contains at least an example line.

===== Configuration file (JSON) =====

<hidden>
<code json xxxxxxxx_data.json>
{
  "body": {
    "public": {
      "rx_data_history": {
        "db_max_entries": 10000
      },
      "loftp": {
        "enable": false
      },
      "csvlo": {
        "rotation_time": "hour",
        "rotation_count": 100
      },
      "rhttp": {
        "enable": false,
        "secure": false,
        "host": "",
        "port": 80,
        "path": ""
      },
      "reftp": {
        "enable": false,
        "user": "",
        "password": "",
        "host": "",
        "port": 21,
        "path": "/"
      },
      "smsma": {
        "enable": true
      },
      "node_red": {
        "enable": false
      },
      "sscan": {
        "enable": false,
        "freq_min": 0,
        "freq_max": 0
      },
      "region_specific": {
        "region": 1
      },
      "lora_network": {
        "nwk_id": 0
      },
      "rx_rf": {
        "radio_0": {
          "enable": true,
          "freq": 867500000
        },
        "radio_1": {
          "enable": true,
          "freq": 868500000
        },
        "chan_multisf_0": {
          "enable": false,
          "radio": 0,
          "if": 0
        },
        "chan_multisf_1": {
          "enable": false,
          "radio": 0,
          "if": 0
        },
        "chan_multisf_2": {
          "enable": false,
          "radio": 0,
          "if": 0
        },
        "chan_multisf_3": {
          "enable": false,
          "radio": 0,
          "if": 0
        },
        "chan_multisf_4": {
          "enable": false,
          "radio": 0,
          "if": 0
        },
        "chan_multisf_5": {
          "enable": false,
          "radio": 0,
          "if": 0
        },
        "chan_multisf_6": {
          "enable": false,
          "radio": 0,
          "if": 0
        },
        "chan_multisf_7": {
          "enable": false,
          "radio": 0,
          "if": 0
        },
        "chan_monosf": {
          "enable": false,
          "radio": 0,
          "if": 0,
          "bandwidth": 250000,
          "spread_factor": 7
        },
        "chan_fsk": {
          "enable": false,
          "radio": 0,
          "if": 0,
          "bandwidth": 250000,
          "datarate": 50000
        }
      },
      "tx_rf": {
        "antenna_gain": 3,
        "insertion_loss": 0,
        "tx_power": 5
      },
      "packets_forwarding": {
        "enable": false,
        "host": ""
      },
      "network": {
        "lan": {
          "type": "dhcp",
          "address": "",
          "netmask": "",
          "gateway": ""
        },
        "wlan": {
          "network_name": "",
          "passphrase": "",
          "type": "dhcp",
          "address": "",
          "netmask": "",
          "gateway": ""
        },
        "gsm": {
          "enable": true,
          "operator": {
            "mcc": "",
            "mnc": ""
          },
          "pin_code": "",
          "apn": "",  * {{.:xxxxxxxx_end_device_fleet.csv|}}
          "user": "",
          "password": ""
        },
        "openvpn": {
          "enable": false
        }
      },
      "time": {
        "timezone": "Europe/Paris",
        "ntp": {
          "polling": 6,
          "address_1": "0.pool.ntp.org",
          "address_2": "1.pool.ntp.org"
        }
      },
      "login": {
        "password": "spnpwd"
      }
    }
  }
}
</code>
</hidden>

===== End-device fleet (CSV) =====

<hidden>
<code csv xxxxxxxx_end_device_fleet.csv>
activation_type (IN),class (IN),dev_eui (IN),app_eui (IN),app_key (IN),dev_addr (IN),nwks_key (IN),apps_key (IN),rx_window (IN),rx_frequency (IN),rx_datarate (IN),status (OUT)
OTAA,A,F2714274138142A1,AC453432F44BA875,2342BD67EF9878911ACD9089BBCC6712,,,,255,869525000,0,UNKNOWN
ABP,C,,,,876123FE,0198817BCD764EA4791056BCD3615731,12987467DC091DEB986248652DE90819,255,869525000,0,UNKNOWN
</code>
</hidden>

===== Gateway fleet (CSV) =====

<hidden>
<code csv xxxxxxxx_gateway_fleet.csv>
gateway_id (IN),ip_address (OUT),nb_packets_received (OUT),nb_packets_sent (OUT),seen_time (OUT),disabled (OUT)
7276FF003903001D,127.0.0.1,0,0,1583749130,false
7276FF0039020003,192.168.4.167,211044,0,1583414745,false
</code>
</hidden>

===== Tx data (CSV) =====

<hidden>
<code csv xxxxxxxx_tx_data.csv>
end_device_id (IN),port (IN),acknowledge (IN),try_number (IN),payload (IN),tx_data_id (OUT),status (OUT),update_time (OUT)
876123FE,1,true,3,GQgZh9vhNoGYew==,1,-5,1583749149
</code>
</hidden>

===== Rx data (CSV) =====

<hidden>
<code csv xxxxxxxx_rx_data.csv>
rx_data_id (OUT),end_device_id (OUT),gateway_id (OUT),received_time (OUT),sequence_number (OUT),port (OUT),radio_id (OUT),channel (OUT),snr_db (OUT),rssi_dbm (OUT),frequency_hz (OUT),modulation_type (OUT),data_rate (OUT),coding_rate (OUT),adr (OUT),payload (OUT)
1,876123FE,7276FF003903001D,1582707215,0,1,0,5,16.500000,-74,868100000,LoRa,SF12BW125,4/5,false,AAECAwQFBgcICQoLDA0ODw==
</code>
</hidden>

===== Status (CSV) =====

<hidden>
<code csv xxxxxxxx_status.csv>
lan_status (OUT),lan_hardware_address (OUT),lan_address (OUT),lan_broadcast (OUT),lan_netmask (OUT),wlan_status (OUT),wlan_hardware_address (OUT),wlan_address (OUT),wlan_broadcast (OUT),wlan_netmask (OUT),gsm_status (OUT),gsm_address (OUT),gsm_broadcast (OUT),gsm_netmask (OUT),license_expiration_date (OUT),license_gateway_number (OUT),license_max_number_of_gateways (OUT),license_end_device_number (OUT),license_max_number_of_end_devices (OUT)
true,70:76:FF:02:00:80,192.168.4.116,192.168.5.255,255.255.254.0,false,04:A3:16:61:A3:D2,,,,false,,,,2147483647,2,100,3,5000
</code>
</hidden>