Location: Bark River, MI
Fri Aug 14, 2009 8:19 pm
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!
_________________ "Show me a man who is a good loser, and I will show you a man who is playing golf with his boss."
gotta run WGA Member
Fri Aug 14, 2009 9:30 pm
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!
View next topic View previous topic
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum