Wigle.net KML import fail

[Leproide]

Hello, I have a wifi network geolocalization database with 16k records in kml/sql format I tried to import within the android MozStumbler app but it crashed I guess the wigle kml is not compatible, is there a way to convert and import it?

[hannosch]

The KML import feature of Mozilla Stumbler only supports its own data format. It's meant as a way to save and load stumbling progress over multiple sessions to show it on its own map. None of the data being imported is send to the backing service.

To my knowledge there is no converter for the wigle.net KML import format to the JSON format used by our location service. I'm afraid you'll have to write one yourself and send the data directly to the service. The service API is documented at https://mozilla.github.io/ichnaea/api/geosubmit2.html

[Leproide]

Hi hannosch, Thanks for your answers. In my sqlite I have a table for wifi and cells named "location" with:

• bssid
• level (for example -39)
• lat
• lon
• altitude
• accuracy (for ex. 14.5215616226196)
• time (for ex. 1467644099000, much network have 0 in this row)

In another table named network I have:

• bssid
• ssid
• frequency (for ex. 2437)
• capabilities (for ex. [WPA-PSK-CCMP+TKIP][WPA2-PSK-CCMP+TKIP][WPS][ESS] or UMTS;it UNKNOWN, EDGE;i)
• lasttime (for ex. 1467377157000)
• lastlat
• lastlon
• type (for ex. w for wifi and g for cell, i think)
• bestlevel
• bestlat
• bestlon

https://mozilla.github.io/ichnaea/api/geosubmit2.html At this page i read this is required:

• primaryScramblingCode
• serving
• signalToNoiseRatio
• age and other...

I don't have this information... Is there a way to send my database to mozilla so they can import it in the proper way?

[hannosch]

The extra fields aren't required. Almost all fields are actually optional. The example just mentions all of the possible fields.

For WiFi only the macAddress is required. For cell entries, radioType, mobile country and network code, location area code and cell id are required.

[Leproide]

Ok perfect, I'm not a real programmer but I'll try to make a converter in the next days. I think if mozilla makes a importer tool is better, wigle.net has a very big community. Thanks for the support!