search

danielfett / advancedcaching

Advanced Geocaching Tool for Linux
http://www.danielfett.de/internet-und-opensource,software,agtl
31 stars 13 forks source link

GPX file import #186

Open Laturi opened 8 years ago

Laturi commented 8 years ago

Onnistuisiko mitenkään saamaan GPX tiedostoja ladattua ohjelmaan? Tai edes tietokoneella tekemään yhteensopivan caches.db tiedoston?

How difficult it is to customize the program in order to get the downloaded GPX file?

aapo commented 8 years ago

caches.db is standard sqlite3-database, you can edit it with any sqlite-tool.

This is the schema of table: CREATE TABLE geocaches (last_viewed INTEGER, logs TEXT, vars TEXT, terrain INTEGER, waypoints text, marked INTEGER, logas INTEGER, owner TEXT, alter_lat REAL, images text, websitelink TEXT, size INTEGER, title TEXT, lon REAL, logdate TEXT, user_coordinates TEXT, desc TEXT, type TEXT, status INTEGER, updated INTEGER, upload_as INTEGER, difficulty INTEGER, attributes TEXT, lat REAL, hints TEXT, alter_lon REAL, name TEXT PRIMARY KEY, fieldnotes TEXT, notes TEXT, shortdesc TEXT, found INTEGER);

In maemo5, you can install sqlite3 and run:

sqlite3 /home/user/.agtl/caches.db 'SELECT * FROM geocaches LIMIT 5'

to check couple of examples how data is stored.

What kind of gpx you are planning to import? There are couple of different examples: http://wiki.openstreetmap.org/wiki/GPX