Page 1 of 1
Import observed from multiple devices
Posted: Tue Oct 25, 2016 5:45 pm
by Giki_riki
I have gathered data using multiple android devices. It seems that the import observed function works only for the nets seen with the current device.
Any ideea how to import all data from all devices onto a single device?
Re: Import observed from multiple devices
Posted: Wed Oct 26, 2016 4:53 pm
by Giki_riki
I studied the database more carefully and it seems that all the MACs are imported but all other fields are filled with 0.
Re: Import observed from multiple devices
Posted: Thu Oct 27, 2016 5:57 am
by bobzilla
That is all it currently does, so it can accurately show if a network is new to you or not. We need to add chunking in order to download more data, it already is not the most stable operation. You can export the database to csv/kml. It's best to move the wiglewifi sqlite file from an old device to the new one to maintain the full local db.
Re: Import observed from multiple devices
Posted: Thu Oct 27, 2016 1:46 pm
by Giki_riki
Thx for the answer.
Is there any script to merge two wigle sqlite databases?
Re: Import observed from multiple devices
Posted: Fri Oct 28, 2016 4:39 am
by bobzilla
They are standard sqlite, there's not much wizardry in the schema, you can likely just dump the network and location tables from one of the db's and insert to the other. Googling around finds a few links, nothing I've tried though:
https://www.quora.com/How-can-I-use-sql ... each-other
https://stackoverflow.com/questions/934 ... -databases
Re: Import observed from multiple devices
Posted: Fri Oct 28, 2016 4:25 pm
by Giki_riki
Cool. I will try and post the method that worked.
Thanks for your advice!