Wigle Format for ESP32 WiFi Scan

[x20011]

Hello all,
I am currently building a Wifi scanner based on ESP32 and GPS support as a leisure project. The device works great so far, and writes all found networks into a csv file. For the CSV file I tried to stick to the Wigle file format so that I can upload the logs here later. However, it seems that something is still not quite right, as my logs are uploaded without errors, but are not processed any further. (No new wifi networks are displayed on the website).

Maybe someone has a hint where I might have made a mistake.

My file looks like this:
WigleWifi-1.4,appRelease=2.26,model=ESP32,release=0.0.0,device=ESP32,display=3fea5e7,board=ESP32,brand=Heltec
EC:6C:9A:50:C5:98,WLAN-965977,[WPA2_PSK],2021-05-11 05:17:05,11,-89,50.069386,8.184992,221,2.000000,WIFI
94:4A:0C:87:D6:79,EasyBox-800083,[WPA_WPA2_PSK],2021-05-11 05:17:05,11,-90,50.069386,8.184992,221,2.000000,WIFI
92:5C:14:CC:4D:62,Vodafone Hotspot,[OPEN],2021-05-11 05:17:05,11,-91,50.069386,8.184992,221,2.000000,WIFI
DC:53:7C:B9:CF:B3,UPC64D6E8F,[WPA_WPA2_PSK],2021-05-11 05:17:05,1,-92,50.069386,8.184992,221,2.000000,WIFI
E4:3E:D7:C7:D7:6E,Telekom_FON,[OPEN],2021-05-11 05:17:05,6,-92,50.069386,8.184992,221,2.000000,WIFI
54:67:51:0A:11:8B,UPCAA2E849,[WPA_WPA2_PSK],2021-05-11 05:17:05,1,-93,50.069386,8.184992,221,2.000000,WIFI
78:81:02:41:0D:D4,EasyBox-056428,[WPA_WPA2_PSK],2021-05-11 05:17:05,6,-93,50.069386,8.184992,221,2.000000,WIFI
E4:3E:D7:C7:D7:6D,WLAN-391171,[WPA2_PSK],2021-05-11 05:17:05,6,-93,50.069386,8.184992,221,2.000000,WIFI
0C:8E:29:8E:43:2C,WLAN-688465,[WPA2_PSK],2021-05-11 05:17:05,11,-93,50.069386,8.184992,221,2.000000,WIFI
DC:53:7C:EE:08:52,UPCF1DF4D2,[WPA_WPA2_PSK],2021-05-11 05:17:05,1,-94,50.069386,8.184992,221,2.000000,WIFI
D4:3F:CB:82:88:64,Vodafone-5D59,[WPA2_PSK],2021-05-11 05:17:05,6,-94,50.069386,8.184992,221,2.000000,WIFI
90:5C:44:CC:4D:62,UPC96B9DB1,[WPA_WPA2_PSK],2021-05-11 05:17:05,11,-95,50.069386,8.184992,221,2.000000,WIFI
F0:86:20:99:D2:28,WLAN-968317,[WPA2_PSK],2021-05-11 05:17:06,1,-90,50.069454,8.185082,223,2.000000,WIFI
78:DD:12:EB:33:48,WLAN-963134,[WPA2_PSK],2021-05-11 05:17:06,1,-92,50.069454,8.185082,223,2.000000,WIFI

[arkasha]

it looks like you're missing the header row - our format is a little unusual in that we have a prefix row for device spec (your prefix row looks good) followed by a traditional CSV header row (that appears to be missing):

https://api.wigle.net/csvFormat.html

[x20011]

it looks like you're missing the header row - our format is a little unusual in that we have a prefix row for device spec (your prefix row looks good) followed by a traditional CSV header row (that appears to be missing):

https://api.wigle.net/csvFormat.html

Wow, that really was the mistake. I had absolutely no idea about the missing csv header... Now it seems to work and the data is processed. Next weekend can come...

Thanks a lot for the quick help!

[arkasha]

no problem; our format is a little non-standard.
We wanted to prioritize readability and processing outside of our tool-chain. but we really did need just a little more metadata than a simple CSV could provide.

[d2k2]

a side question, do you also scan Bluetooth?
And would you share the code?
(i have some TTGO T-Beam ESP32 here that could get a second live with that )