View Full Version : Macro for Know Your Local Maine Cacher Challenge 2010



dufzor
07-11-2011, 12:16 AM
Is there a macro that will show which cachers in Maine actively have 3 different kinds of caches to find? TX.

shuman road searchers
07-11-2011, 05:27 AM
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?!!

brdad
07-11-2011, 06:35 AM
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!

JustPJ66
07-11-2011, 07:12 AM
clearly we need to make the web site content more visible...

Ok, maybe it would be easier to find if there were one or two less steps!

ya think?????

dufzor
07-13-2011, 01:27 AM
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!

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.

brdad
07-13-2011, 06:59 AM
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.

Oooohhhhhhhhhhhhhhhh............. Neat idea.

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.

brdad
07-13-2011, 01:18 PM
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...

JustKev
07-13-2011, 07:59 PM
What macro, Dave?

Mis-read the edit. My bad.

brdad
07-15-2011, 01:56 PM
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...

cano
07-15-2011, 02:21 PM
I looked at your SQL statement. You must use aggregate function on columns not included in GROUP BY.


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.

brdad
07-15-2011, 03:20 PM
I looked at your SQL statement. You must use aggregate function on columns not included in GROUP BY.

Must or should? I think it's working. :p:p

dufzor
07-15-2011, 05:06 PM
Thanks Brdad, installing it now and will give it a whirl.

dufzor
07-15-2011, 05:25 PM
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?

brdad
07-15-2011, 07:56 PM
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?

It should be only showing hiders who have hidden 3 or more types. I will double check...

brdad
07-15-2011, 08:06 PM
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.

brdad
07-15-2011, 08:10 PM
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

brdad
07-18-2011, 05:43 AM
Has anyone else tried this macro and had good or bad results?
Did this new version give you an error message Dufzor?

Ekidokai
07-20-2011, 06:41 PM
I had no idea this was going to cause such a commotion.

dufzor
07-22-2011, 07:08 PM
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

brdad
07-22-2011, 07:42 PM
Ah, I think I can fix that. But it might be a day or two....

dufzor
07-22-2011, 08:35 PM
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!

brdad
07-25-2011, 07:54 PM
Ok, this one is the same but it does not allow any benchmarks or user-created waypoints. I hope.

dufzor
07-25-2011, 07:57 PM
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.