GPX file import

[Laturi]

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]

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