The Wisconsin Geocaching Association

  Login or Register

Website Navigation

62.png Home

49.png Information Center
26.png WGA Newsletters
24.png Reviewer's Words
53.png Presentation Resources
39.png Geocaching Files
27.png Bookmarks
56.png Location Rules and Regs
49.png BOD Info Center

17.png Forums
16.png New Posts
20.png Unanswered Posts

calendar_day.png Upcoming Events
mapicon.png Map
29.png Calendar
11.png Submit Event

mapicon.png WGA State Park CachesNew content !

shield_star.png Cache of the Month
mapicon.png Past Winners Map

LonelyCache.png Lonely Cache Game
mapicon.png Current Map
26.png Scoreboard
11.png Submit Report

rescueiconsm.png Cache Rescue
11.png Submit a Mission

icon_community.gif Members
27.png Your Account
47.png Private Messages
contact_blue.png WGA Member Map
Geocaching_LIVE_poweredby_16.png GC.COM Authorization

icon_members.gif News
tree-T.gif Topics
tree-T.gif Archives
tree-L.gif Submit News

image_cultured.png Photo Gallery
tree-T.gif Updates
tree-L.gif Popular

shield.png Fun Stuff
28.png Recent Logs
TB.gif Picnic to Picnic TB Race Standings
TB.gif WGA Hauler

49.png Board of Directors
Contact Us


Wisconsin Geocaching Association

Follow Us

Twitter Button

Subscribe to Newsletter

Subscribe to our mailing list

* indicates required Search
View Search Syntax
Winner -
September 2014 Northern Zone:
Bunyan's Bowling Ball

Winner -
September 2014 Northeast Zone:
Gardner Swamp Thing

Winner -
September 2014 West Central Zone:
Upper Dells SNA

Winner -
September 2014 South Central Zone:
Old Meets New

Winner -
September 2014 Southeast Zone:

Winner -
September 2014 Series of the Month:
Meet the WGA series

More Info >>>

Wisconsin Geocaching Association: Forums


View next topic
View previous topic
Post new topic   Reply to topic
Author Message
Team B Squared
WGA Friend

Joined: 2005-11-20
Posts: 257
Location: Bark River, MI

PostPosted: Fri Aug 14, 2009 8:19 pm Reply with quote Back to top

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. Laughing

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, 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."
--Jim Murray
View user's profile Send private message
gotta run
WGA Member

Joined: 2007-11-26
Posts: 3306

PostPosted: Fri Aug 14, 2009 9:30 pm Reply with quote Back to top

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! Razz
View user's profile Send private message
Display posts from previous:       
Post new topic   Reply to topic

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

Powered by phpBB © 2001-2008 phpBB Group
:: Theme & Graphics by Daz :: Ported for PHP-Nuke by ::
All times are GMT - 6 Hours
Forums ©
Legal Notice | Privacy Policy | Terms of Use | Parental Consent Form | contact | Comments ]

All content © 2013 Wisconsin Geocaching Association, except comments and forum entries which are property of their posters.

The Groundspeak Geocaching Logo is a registered trademark of Groundspeak, Inc. Used with permission.

Use of this Web site constitutes acceptance of the WGA Terms of Use

Distributed by Raven PHP Scripts
New code written and maintained by the RavenNuke™ TEAM

(Original PHP-Nuke Code Copyright © 2004 by Francisco Burzi)
Page Generation: 0.10 Seconds

:: fisubice phpbb2 style by Daz :: PHP-Nuke theme by ::
:: fisubice Theme Recoded To 100% W3C CSS & HTML 4.01 Transitional & XHTML 1.0 Transitional Compliance by RavenNuke™ TEAM ::

:: W3C CSS Compliance Validation :: W3C HTML 4.01 Transitional Compliance Validation :: W3C XHTML 1.0 Transitional Compliance Validation ::