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

 
Facebook

Wisconsin Geocaching Association

 
Follow Us

Twitter Button

 
Subscribe to Newsletter

Subscribe to our mailing list

* indicates required
 
Geocaching.com Search
View Search Syntax
 
COTM
Winner -
August 2014 Northern Zone:
WSQ Gordon Cemetery

Winner -
August 2014 Northeast Zone:
Trout Haven

Winner -
August 2014 West Central Zone:
WISCONSIN DELORME CHALLENGE

Winner -
August 2014 South Central Zone:
Capitol Punishment

Winner -
August 2014 Southeast Zone:
Wisconsin Homestead - Emslie Farm

Winner -
August 2014 Series of the Month:
Classic Childrens Books


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 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."
--Jim Murray
[img]http://img.geocaching.com/stats/img.aspx?txt=Brian,+Lynn,+and+CJ&uid=0841d9ba-2750-42ac-a7c9-50cf6c75fa6c&bg=2[/img] 
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 nukemods.com ::
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.11 Seconds

:: fisubice phpbb2 style by Daz :: PHP-Nuke theme by www.nukemods.com ::
:: 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 ::