This topic contains 31 replies, has 6 voices, and was last updated by 
gotta run 16 years ago.
-
Posts
-
@gotta run wrote:
Hey B Squared, how do you clear ARCHIVED caches from your database using your method? Archived caches won’t show up in the PQ so how do you know to drop them? Are you filtering by “last GPX date” or something?
Easy to answer this one, I already answered this earlier in the thread. 😆
Here you go…this is the easiest way I have found to do it. I know there are macros out there that handle this as well, but I prefer to do it by hand.
@Team B Squared wrote:
One more thing you will have to do if you are maintaining a database that will build over time. Caches that get archived will not automatically delete from your gsak database, you will have to delete them yourself. What happens is when a cache gets archived it will no longer be included in the gpx file from geocaching.com, but it will still be in your database. An easy way to find the caches that have been archived is to (in gsak) click “Search” and select “filter” from the drop down menu. In the filter dialog click on the “Dates” tab at the top. For “Last Updated gpx”, change the “not applicable” to “on or before”. When you do this a date dialog will appear to the right of the drop down. You will need to select a date for this that falls between the two days that you received your newest gpx file and the last time you received the gpx file before that. So if your last two gpx downloads were on 7/14/09 and 7/18/09, you would want to select 7/17/09. After selecting the date click “go”. This will show you all the caches that were not updated in your newest gpx download and were probably archived (I say probably because if you select the 500 closest to home and more new caches get published than were archived it will cause some of the caches the farthest from you center point to not get downloaded as well).
Hopefully this all helps and makes sense, since I am watching a baseball game while typing this. Feel free to send me a message if you have any questions. Good luck!
@Team B Squared wrote:
Easy to answer this one, I already answered this earlier in the thread. :l
Yeah well it was easier for me to ask you to repeat it! 😛
On the Left Side of the Road...
You must be logged in to reply to this topic.