Friday, September 19, 2008

GSAK: restoring database and saving corrected coordinates and child waypoints

foundinthewild passed along to me this information he discovered about restoring your GSAK database while retaining changes you've made, such as corrected coordinates and child waypoints for puzzles.

I recently had a database error and ended up reloading my PQ's from gmail.

This should be no big deal, except for those of us who use either corrected waypoints or child waypoints to enter a solved puzzle location. It first appeared they were lost (momentary panic). I did some searching in gsak forums and info gathered might save either you or someone you know a lot of trouble.

Find your latest backup. I actually renamed my old messed up database and ended up using it to update the new one.

1) Two files are in the gsak data folder called correct.dbf and correct.nsx . They contain the corrected coords, and can be copied over the new data base files in the proper folder.

2) A macro called "CopyChildren.gsk" is available on the gsak forum macro page. It copies the child waypoints to a temporary file, then checks for existence of a row and only updates the matched caches.

It took some time to research this but not too long to implement.

Happy Caching.

Here's the link to the CopyChildren macro.

No comments: