WiGLE.net

Hi,

I have two phones for Wardiving, how can i combine two wiglewifi.sqlite in to one big wiglewifi.sqlite file?
I already have tried to load wiglewifi.sqlite with SQLite Database Browser and that import the oder phones wiglewifi.sqlite without success

Any help is welcome

Thanks in advance,
Vaako

You'd have to select from one and insert into the other, probably with a small program in your favorite scripting language. The network table would have conflicts on duplicate bssid (mac's), those errors would have to be captured. The id's on the location table are auto-generated, would just have to not specify the id on the insert. That schema is kept very simple

you can also use the sqlite3 commandline tool, attach to multiple files, and do the select into that way.

Thanks for the help, i wil look into this.