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.
Click to display ⇲
Click to hide ⇱
Click to display ⇲
{
"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"
}
}
}
}
Click to display ⇲
Click to hide ⇱
Click to display ⇲
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
Click to display ⇲
Click to hide ⇱
Click to display ⇲
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
Click to display ⇲
Click to hide ⇱
Click to display ⇲
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
Click to display ⇲
Click to hide ⇱
Click to display ⇲
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==
Click to display ⇲
Click to hide ⇱
Click to display ⇲
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