Is there a macro that will show which cachers in Maine actively have 3 different kinds of caches to find? TX.
Printable View
Is there a macro that will show which cachers in Maine actively have 3 different kinds of caches to find? TX.
I think this is a great idea! Dave where are you?!!Quote:
Originally Posted by dufzor
Clearly we need to make the web site content more visible...
On the top left of the front page is a widget "Articles"...
Under that heading is "Caching Help"...
Under that heading is "Maine Challenge Cache Help"...
In that article is a section named "Know Your Local Maine Cacher Challenge 2010"...
In that section is a hyperlink to a macro "LocalCacher.gsk"...
This will take you to appropriate thread on the GSAK website to download the macro. You will need to scroll down to the bottom of the thread to get the newest version.
Ok, maybe it would be easier to find if there were one or two less steps!
ya think?????Quote:
Originally Posted by brdad
I have that macro. What I am looking for is a macro that will go thru the 8000+ Maine caches and will pull out names up geocachers who have hidden 3 or more different kinds of hides, whether I have found them or not.Quote:
Originally Posted by brdad
Oooohhhhhhhhhhhhhhhh............. Neat idea.Quote:
Originally Posted by dufzor
And I thought it would be real easy but I realized one glitch, and that is if you do not have the archived caches you have found in your database of Maine caches you would not get a perfect result. But even than it could still be used to filter GSAK to show which cache hiders have 3 or more unique & active cache types. Let me see what I can do.
Ok, Sue and anyone else interested...
Try this macro out. I'm not 100% confident in it yet lol
This will (should) filter a database of all Maine caches for caches which:
Are hidden by hiders who have hidden more than 3 or more types of caches
AND
Are currently available OR are archived but you have found them.
So if all your finds and all available Maine caches are in your database you should be able to see what caches by which cachers you need to find to meet the requirement.
The list is sorted by Owner Name with secondary sort of Cache Type, so hopefully it makes it easy to see which ones you might need to do.
Click on the red "X" button to clear the macro filter.
EDIT: Macro deleted; I forgot the "All finds must be on or after January 1, 2010" part. :p:p:p Stay tuned...
What macro, Dave?
Mis-read the edit. My bad.
You'd think one date wouldn't have much effect on it, but I had to re-write the whole macro. :eek:
Give this a try....
This macro is now more about what caches are not allowed than which ones are allowed, so it effectively filters out:
Caches Which you own
Caches you never found and are archived (It's up to you to make sure GSAK knows these are archived)
Caches you have found (archived or available) which you found before 2010-01-01
From the caches that remain, it removes all caches by owners who have hidden less than 3 different cache types that meet the requirements.
Looking at the cache description, I am wondering if the different events do not count - meaning, can you claim a CITO and a regular event from the same hider? I'll have to verify that.
If anyone likes where this is going I should be able to also make it spit out a list you could put in your cache log.
Edit: Macro deleted, newer version below...
I looked at your SQL statement. You must use aggregate function on columns not included in GROUP BY.
Quote:
Originally Posted by brdad
Must or should? I think it's working. :p:pQuote:
Originally Posted by cano
Thanks Brdad, installing it now and will give it a whirl.
I've run it multiple times and it has pulled up cachers that have lost of placements, but only 1 or 2 types of caches, not the three different kinds. Am I missing something?Quote:
Originally Posted by dufzor
It should be only showing hiders who have hidden 3 or more types. I will double check...Quote:
Originally Posted by dufzor
It only shows owners with 3 or more cache types on mine, here is what my screenshot looks like. If you have a database of all Maine caches, it should look similar.
The only way I can think it would revert to showing owners with less than three is if there are none in your database (or it's having trouble finding them). I've edited the macro to Send a warning message Cannot find any hiders hiding 3 different types of caches! if that is the case. Try this update:
EDIT: Deleted Old version
Has anyone else tried this macro and had good or bad results?
Did this new version give you an error message Dufzor?
I had no idea this was going to cause such a commotion.
Tried it again. Works until I tell it to remove the benchmarks and waypoints, then it just gives me everything but them, even if a cacher has only placed one kind of cache, its in the list. However, I can deal with that and ignore the waypoints. Thanks Brdad
Ah, I think I can fix that. But it might be a day or two....
Sounds good but don't feel the need to rush. I only have 2 cachers completed so far! I tried removing the bnch and the ways before running the macro and after but it came up with the same result of just taking them out and putting everyone else back in!Quote:
Originally Posted by brdad
Ok, this one is the same but it does not allow any benchmarks or user-created waypoints. I hope.
Thanks Brdad! For the Macro and my bathing suit and shorts! Will do a post about that meetup we discused later in the week.Quote:
Originally Posted by brdad