MnGCA Home MnGCA
Minnesota Geocaching Association
 
 FAQFAQ   SearchSearch   User listUser list   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

GSAK and DeLorme
Goto page 1, 2, 3  Next
 
Post new topic   Reply to topic    MnGCA Forum Index -> Tech Talk
View previous topic :: View next topic  
Author Message
Bus&Betty
Geocacher


Joined: 07 Sep 2007

Posts: 328

PostPosted: Wed Nov 14, 2007 9:52 am    Post subject: GSAK and DeLorme Reply with quote

We are using the User Data 2 field in GSAK for our counties. It's working great.

Does anyone know if we can:
1. Create another User Data x field.
2. Use [?] to automatically correlate the cache location to the number from the DeLorme Atlas.
3. Populate the User Data x field with the DeLorme Atlas number.

So, in other words, for a cache in Blaine, I'd like a User Data x field that reads 41, along with my User Data 2 field that reads Anoka.

Thanks,
Patty
Back to top
View user's profile Send private message
merkman
Past MnGCA Board


Joined: 03 Jun 2006

Posts: 2032

PostPosted: Wed Nov 14, 2007 12:09 pm    Post subject: Reply with quote

I am not sure.
I can check on that.

If you don't get two fields it may be possible to append the data to one field like this.

Anoka - 41
or
41 - Anoka

That is just a thought

I would require GSAK macro programming though.
Back to top
View user's profile Send private message
merkman
Past MnGCA Board


Joined: 03 Jun 2006

Posts: 2032

PostPosted: Wed Nov 14, 2007 12:35 pm    Post subject: Reply with quote

The first thing you would need are the shape files for the Delorme pages.
I don't know much about shape files but I don't see them at http://www.gpsbabel.org/download.html

One way that I can think of doing it (it is pretty ugly) is

1) Run the county macro as it is.
2) Make a copy of xcsv.dir in the shape files directory
3) Change the shape files from counties to Delorme files (if you can find them)
4) Run the county macro (it should populate User2 with Delorme page#)
5) Make a copy of xcsv.dir in the shape files directory
6) Open the 2 xcsv.dir and update the data in the User2 field on one of the files so it is in the Anoka - 41 or 41 - Anoka format. (This can be done in excel with a vlookup and a concatination)
7) Modify the macro to pause just before GoSub Name=ProcessSingleXCSVFile
8) Replace the xcsv.dir in the shape files directory with the one you modified.
9) Resume the macro.
10) That should fill in User2 with what you modified it with.

This is total untested but you could test it out by pausing the macro to just before GoSub Name=ProcessSingleXCSVFile then modify the xcsv.dir file in excel. Overwrite the existing xcsv.dir file and resume the macro and see what User2 gets filled in with.

Of course there is probably some one here who knows a better way.
Back to top
View user's profile Send private message
Bus&Betty
Geocacher


Joined: 07 Sep 2007

Posts: 328

PostPosted: Wed Nov 14, 2007 2:14 pm    Post subject: Reply with quote

Bob's got an idea brewing Idea If anything comes of it, we'll post it here.
Back to top
View user's profile Send private message
RubberToes
Geocacher


Joined: 13 Feb 2005

Posts: 222

PostPosted: Wed Nov 14, 2007 4:45 pm    Post subject: Reply with quote

A little more than a year ago, I made this post in which I made available text files that describe each of Minnesota's counties for GSAK's polygon filter.

I also have text files for the DeLorme pages. I'd be happy to post them if you're interested.
Back to top
View user's profile Send private message
merkman
Past MnGCA Board


Joined: 03 Jun 2006

Posts: 2032

PostPosted: Wed Nov 14, 2007 7:18 pm    Post subject: Reply with quote

I have been waiting for your post Laughing

I am interested in the delorme pages text file
Back to top
View user's profile Send private message
RubberToes
Geocacher


Joined: 13 Feb 2005

Posts: 222

PostPosted: Wed Nov 14, 2007 8:14 pm    Post subject: Reply with quote

Sorry for the delay. I got involved with cooking dinner and lost track of the important stuff.

A link to the file is on the bottom of my Minnesota Counties page.

Let me know how this works for you.
Back to top
View user's profile Send private message
Pear Head
Past MnGCA President


Joined: 04 Apr 2004

Posts: 5703

PostPosted: Wed Nov 14, 2007 8:23 pm    Post subject: Reply with quote

I have access to the GSAK macro that Oklahoma uses for their Delorme Challenge. If someone wants it to look at let me know via PM or email and I'll email it to you.
_________________
Hmm...
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
Bus&Betty
Geocacher


Joined: 07 Sep 2007

Posts: 328

PostPosted: Thu Nov 15, 2007 11:21 am    Post subject: Anybody want a macro named DeLorme.gsx??? Reply with quote

Very Happy

Thank you RubberToes for the DeLorme shape files! They saved Betty and I many hours of data translation and entry. I had to modify a few of the shape files, but they seem to be working fine.

I used County.gsk as a starting point for the new DeLorme.gsx macro. The setup is the same, you just use a different directory to keep the "county" and "page" shape files seperate.

The DeLorme.gsk macro places the results in two places. It populates the "User Data" field with results like "Pg 42". The macro also prepends the "User Data 2" field (currently used by County.gsk to hold the county data) with results like this: "41-Anoka". 41 is the DeLorme page number and Anoka is the County name. If there is no County information in "User Data 2", then it will be populated the same as "User Data". For the latter (User Data 2) to be populated correctly with both County and DeLorme page number, run thte county.gsx macro first and then run the DeLorme.gsx macro.

I only have shape files for Minnesota. However, the macro does support the possibility of adding additional states by simply creating the state directory containing the appropriate shape files.
Back to top
View user's profile Send private message
merkman
Past MnGCA Board


Joined: 03 Jun 2006

Posts: 2032

PostPosted: Thu Nov 15, 2007 11:50 am    Post subject: Reply with quote

So lets see it!!!
Back to top
View user's profile Send private message
RubberToes
Geocacher


Joined: 13 Feb 2005

Posts: 222

PostPosted: Thu Nov 15, 2007 11:56 am    Post subject: Reply with quote

Cool. Glad I was able to help you out. I'd love to see a copy of your DeLorme macro even though I probably don't need it at this point. I only have a few DeLorme pages left to do and I already have filters set up for all pages.

What I do when getting ready for a trip is run a macro that chains together as many of these filters as I need, and that pretty quickly gets me all the caches that will be in play for that trip. Then I run one more macro to output to the GPS, Cachemate, and Mapsource and I'm out the door.
Back to top
View user's profile Send private message
Bus&Betty
Geocacher


Joined: 07 Sep 2007

Posts: 328

PostPosted: Thu Nov 15, 2007 12:24 pm    Post subject: Reply with quote

I've received several offers to host the files.

Thanks everyone.

Happy Cachin' Smile
Back to top
View user's profile Send private message
Pear Head
Past MnGCA President


Joined: 04 Apr 2004

Posts: 5703

PostPosted: Thu Nov 15, 2007 6:46 pm    Post subject: Reply with quote

Bus&Betty wrote:
I've received several offers to host the files.

Thanks everyone.

Happy Cachin' Smile


Macro:
http://www.pearhead.org/DeLorme.gsk

edit to remove shapefile link as the shapefiles are now built into the macro
_________________
Hmm...


Last edited by Pear Head on Sun Nov 25, 2007 9:31 pm; edited 1 time in total
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
Jonas
Past MnGCA Board


Joined: 30 Nov 2005

Posts: 672

PostPosted: Thu Nov 15, 2007 9:02 pm    Post subject: Re: Anybody want a macro named DeLorme.gsx??? Reply with quote

Bus&Betty wrote:
Thank you RubberToes for the DeLorme shape files! They saved Betty and I many hours of data translation and entry. I had to modify a few of the shape files, but they seem to be working fine.


This is excellent. Thanks for sharing, RubberToes. If we would have had this information when we did the challenges we would not have had to second guess ourselves on "Pendaren Church".

-Jonas
Back to top
View user's profile Send private message
Bus&Betty
Geocacher


Joined: 07 Sep 2007

Posts: 328

PostPosted: Fri Nov 16, 2007 8:32 am    Post subject: Reply with quote

I've submitted the first change request to Bob Confused

I would like the DeLorme number after the county name, not before. That way, the User Data 2 field sorts by county name, not DeLorme number.

I've also found a page number discrepancy between the User Data and User Data 2 fields for 24, 25, and 26. The User Data 2 field is correct, the User Data field is not. Bob will look at this too.

Patty

Yes Dear. Cool

--Bus
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    MnGCA Forum Index -> Tech Talk All times are GMT - 6 Hours
Goto page 1, 2, 3  Next
Page 1 of 3

 
Jump to:  
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


Powered by phpBB © 2001, 2002 phpBB Group
Geocaching Cache Icons, Copyright 2009, Groundspeak Inc. All rights reserved. Used with Permission.