Combine two wiglewifi.sqlite files?

Suggestions for WiGLE/JiGLE/DiGLE

4 posts • Page 1 of 1
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 :wink:

Thanks in advance,
Vaako
Regards, WiFi-Freak
Image
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 :)
-bobzilla - WiGLE.net just a little bit
Image

Postby uhtu » Sat Jul 23, 2011 2:47 pm

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.
Regards, WiFi-Freak
Image

4 posts • Page 1 of 1

Return to “WiGLE Project Suggestions”

Who is online

Users browsing this forum: Bing [Bot] and 12 guests