Method import_wigle_csv

wardriving.py:1150–1312

Import a WiGLE-format CSV file into this session. Supports Piglet, HuginnESP, and standard WiGLE CSV exports. Returns dict with counts of imported records.

(self, csv_path_or_stream)

        Rows whose position was estimated via backfill_gps_from_track
        (gps_backfilled = 1) are excluded — they are interpolated coordinates,
        not real observations, and must not be submitted to WiGLE.

        Zigbee / 802.15.4 devices are excluded by default: WiGLE has no
        standard 802.15.4 record type, so those rows are only useful for the
        user's own tooling. Set `include_zigbee=True` (opt-in from the config
        tab) to append them with a `ZIGBEE` type token."""
        lines = []
        dn = device_name or 'Ragnar'
        lines.append(f'WigleWifi-1.4,appRelease=Ragnar,model=RaspberryPi,release=1.0,device={dn},display=EPD,board=RPi,brand=Ragnar')
        lines.append(','.join(WIGLE_HEADER))

        with self._lock:
            try:
                with sqlite3.connect(self.db_path) as conn:
                    conn.row_factory = sqlite3.Row
                    # WiFi networks (skip backfilled positions)
                    rows = conn.execute(
                        "SELECT * FROM networks WHERE COALESCE(gps_backfilled, 0) = 0 "
                        "ORDER BY first_seen"
                    ).fetchall()
                    for row in rows:
                        r = dict(row)
                        lines.append(','.join([
                            r.get('bssid', ''),
                            r.get('ssid', '').replace(',', '\\,'),
                            _map_security(r.get('security', '')),
                            r.get('first_seen', ''),
                            str(r.get('channel', 0)),
                            str(r.get('best_rssi', -100)),
                            str(r.get('best_lat', '') or ''),
                            str(r.get('best_lon', '') or ''),
                            str(r.get('altitude', '') or ''),
                            str(r.get('hdop', '') or ''),
                            'WIFI'
                        ]))
                    # Bluetooth devices
                    try:
                        bt_rows = conn.execute(
                            "SELECT * FROM bluetooth_devices WHERE COALESCE(gps_backfilled, 0) = 0 "
                            "ORDER BY first_seen"
                        ).fetchall()
                        for row in bt_rows:
                            r = dict(row)
                            lines.append(','.join([
                                r.get('mac', ''),
                                r.get('name', '').replace(',', '\\,'),
                                '[BT]',
                                r.get('first_seen', ''),
                                '0',
                                str(r.get('rssi', -100)),
                                str(r.get('latitude', '') or ''),
                                str(r.get('longitude', '') or ''),
                                str(r.get('altitude', '') or ''),
                                '',
                                'BT'
                            ]))
                    except Exception:
                        pass