Import observed from multiple devices

[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?

[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.

[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.

[Giki_riki]

Thx for the answer.
Is there any script to merge two wigle sqlite databases?

[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

[Giki_riki]

Cool. I will try and post the method that worked.
Thanks for your advice!