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 

Setting up GSAK for a statewide database
Goto page 1, 2, 3, 4  Next
 
Post new topic   Reply to topic    MnGCA Forum Index -> Tech Talk
View previous topic :: View next topic  
Author Message
ghost640
Geocacher


Joined: 03 Nov 2006

Posts: 270

PostPosted: Mon Mar 17, 2008 10:21 am    Post subject: Reply with quote

Is there a published GSAK script to do statewide queries? (or could some generous soul post one?) I've been wanting to move over to this approach for awhile now, as my multiple-database system is not very efficient.
Back to top
View user's profile Send private message
Pear Head
Past MnGCA President


Joined: 04 Apr 2004

Posts: 5700

PostPosted: Mon Mar 17, 2008 10:27 am    Post subject: Reply with quote

ghost640 wrote:
Is there a published GSAK script to do statewide queries? (or could some generous soul post one?)


I don't understand the question. Queries are generated at gc.com, not GSAK.

You can filter your GSAK database by state.
_________________
Hmm...
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
ghost640
Geocacher


Joined: 03 Nov 2006

Posts: 270

PostPosted: Mon Mar 17, 2008 11:06 am    Post subject: Reply with quote

Pear Head wrote:
ghost640 wrote:
Is there a published GSAK script to do statewide queries? (or could some generous soul post one?)


I don't understand the question. Queries are generated at gc.com, not GSAK.

You can filter your GSAK database by state.


You're right, the question doesn't make sense to me either now Rolling Eyes But I was trying to piece together a semi-automated procedure for doing the statewide query.

If I have this right, the process seems to be:

1) create a series of pocket queries with time brackets
2) run 5 per day untill you get the 14-15 files you need
3) load the 15 zip files into a single GSAK database
4) run filters to select sets of caches for uploading to GPS

Is that about it? Also, for step 3 - it seems like GC.COM always uses the same filename for the same query - is there a way to run a macro on the GSAK side to bring in the files?

Yes - it does seem awfully inefficient for GC to process the same requests for each user...


Last edited by ghost640 on Mon Mar 17, 2008 8:37 pm; edited 1 time in total
Back to top
View user's profile Send private message
Pear Head
Past MnGCA President


Joined: 04 Apr 2004

Posts: 5700

PostPosted: Mon Mar 17, 2008 5:55 pm    Post subject: Reply with quote

ghost640 wrote:
Pear Head wrote:
ghost640 wrote:
Is there a published GSAK script to do statewide queries? (or could some generous soul post one?)


I don't understand the question. Queries are generated at gc.com, not GSAK.

You can filter your GSAK database by state.


You're right, the question doesn't make sense to me either now Rolling Eyes But I was trying to piece together a semi-automated procedure for doing the statewide query.

If I have this right, the process seems to be:

1) create a series of pocket queries with time brackets
2) run 5 per day untill you get a 14-15
3) load the 15 zip files into a single GSAK database
4) run filters to select sets of caches for uploading to GPS

Is that about it? Also, for step 3 - it seems like GC.COM always uses the same filename for the same query - is there a way to run a macro on the GSAK side to bring in the files?


What I do is send my PQs to a different email account that I have with gmail that I set up to just receive PQs. You can set the different email address near the bottom of the PQ setup page for each PQ.

I then direct GSAK to grab PQs from that email address (GSAK has an option to get it directly from an email server - I believe it's the third option down on the file menu).

GSAK takes care of the downloading and importing into the database. There is an option in the email setup in GSAK to make it so that if the file name matches one that already exists that GSAK will make the new one have a unique name - make sure you check that. It's really only a worry if you try and download two versions of the same PQ.

I then just continually update my database - I don't delete anything.

I consider a cache to be "archived" and don't upload it to the GPS if I haven't received a GPX update for it in 7 days (this is a filter option).

Hopefully this makes sense - let me know if I need to clarify anything for you (or anyone else).

There are other ways to do it, this is just the way I do it.
_________________
Hmm...
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
ghost640
Geocacher


Joined: 03 Nov 2006

Posts: 270

PostPosted: Mon Mar 17, 2008 8:35 pm    Post subject: Reply with quote

Thanks Pear Head - great tips! I didn't expect that GSAK could fetch mail off a server, its a pretty amazing program. I'll try this out.
Back to top
View user's profile Send private message
andrewmcc
Past MnGCA Board


Joined: 29 Jul 2007

Posts: 996

PostPosted: Mon Mar 17, 2008 8:51 pm    Post subject: Reply with quote

Are you still in need of someone to donate their state wide querys?
I don,t do the whole state so I can't help but I have seen another thread on this forum that people have set up for the whole state.
_________________
Dinnae fash yersel (don't worry yourself)
Back to top
View user's profile Send private message
pfalstad
Geocacher


Joined: 02 Feb 2006

Posts: 1013

PostPosted: Wed Mar 26, 2008 7:16 pm    Post subject: Reply with quote

Pear Head wrote:
What I do is send my PQs to a different email account that I have with gmail that I set up to just receive PQs.... I then direct GSAK to grab PQs from that email address (GSAK has an option to get it directly from an email server - I believe it's the third option down on the file menu).

Great idea that saves a ton of time, thanks.. I wish I'd done that sooner.
Back to top
View user's profile Send private message Visit poster's website
speedysk1
Past MnGCA Board


Joined: 29 Oct 2007

Posts: 1991

PostPosted: Fri Apr 04, 2008 12:16 pm    Post subject: Reply with quote

ghost640 wrote:


If I have this right, the process seems to be:

1) create a series of pocket queries with time brackets
2) run 5 per day untill you get the 14-15 files you need
3) load the 15 zip files into a single GSAK database
4) run filters to select sets of caches for uploading to GPS


Does anyone have the PQ settings for this that they could share? My method, not using dates, failed.

Thanks!
_________________
Beer is proof that God loves us and wants us to be happy.
Back to top
View user's profile Send private message
Pear Head
Past MnGCA President


Joined: 04 Apr 2004

Posts: 5700

PostPosted: Fri Apr 04, 2008 9:49 pm    Post subject: Reply with quote

speedysk1 wrote:
Does anyone have the PQ settings for this that they could share? My method, not using dates, failed.


You can't do it without using dates.
_________________
Hmm...
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
MNSearchers
Geocacher


Joined: 27 Apr 2006

Posts: 45

PostPosted: Fri Apr 04, 2008 10:14 pm    Post subject: Try this Reply with quote

Derived using my database and GSAK + GSAK macro called "Placed PQ by date" or something to that effect:

Placed by date PQ Generation
PQ From To Count Done
01 11/5/2000 12/17/2003 490
02 12/18/2003 1/21/2005 490
03 1/22/2005 9/9/2005 490
04 9/10/2005 3/31/2006 485
05 4/1/2006 7/2/2006 463
06 7/3/2006 9/16/2006 487
07 9/17/2006 12/15/2006 486
08 12/16/2006 4/5/2007 488
09 4/6/2007 5/31/2007 485
10 6/1/2007 7/25/2007 485
11 7/26/2007 9/8/2007 485
12 9/9/2007 10/21/2007 490
13 10/22/2007 12/21/2007 487
14 12/22/2007 3/13/2008 487
15 3/14/2008 Maximum date 207


That should get you close, better than my original guess method. I do not keep archived other than ones we have found... that may skew the numbers a little bit, but play with the numbers above and tweek the dates slightly and you will be there.

Brian
_________________
Warning: Objects in mirror are dumber than they appear...
Back to top
View user's profile Send private message
speedysk1
Past MnGCA Board


Joined: 29 Oct 2007

Posts: 1991

PostPosted: Fri Apr 04, 2008 10:57 pm    Post subject: Re: Try this Reply with quote

MNSearchers wrote:
Derived using my database and GSAK + GSAK macro called "Placed PQ by date" or something to that effect:
.....
Brian


Thanks MNSearchers. That's why I love this forum. There's always someone on here that willing to share their experiences or help out.
_________________
Beer is proof that God loves us and wants us to be happy.
Back to top
View user's profile Send private message
LucidOndine
Past MnGCA President


Joined: 17 Jan 2006

Posts: 1931

PostPosted: Sat May 03, 2008 1:10 pm    Post subject: Reply with quote

http://spreadsheets.google.com/pub?key=p_WfZoOFOiRZSjGW7KxhDLQ

I will be using this in the future. If you use google apps and are updating, please let me know via PM and I'll give you edit access.
_________________
The Lucid Network (tm)-- More Bars in More Places!
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
LucidOndine
Past MnGCA President


Joined: 17 Jan 2006

Posts: 1931

PostPosted: Thu May 08, 2008 8:05 pm    Post subject: Reply with quote

Just hit PQ #16.
_________________
The Lucid Network (tm)-- More Bars in More Places!
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
speedysk1
Past MnGCA Board


Joined: 29 Oct 2007

Posts: 1991

PostPosted: Thu May 08, 2008 8:44 pm    Post subject: Reply with quote

LucidOndine wrote:
Just hit PQ #16.

I see in your spread sheet a PQ for disabled caches that you list runs everyday. How did you set that up exactly?
_________________
Beer is proof that God loves us and wants us to be happy.
Back to top
View user's profile Send private message
LucidOndine
Past MnGCA President


Joined: 17 Jan 2006

Posts: 1931

PostPosted: Thu May 08, 2008 9:03 pm    Post subject: Reply with quote

'Is not Active' option will pull down temp disabled.
_________________
The Lucid Network (tm)-- More Bars in More Places!
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
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, 4  Next
Page 1 of 4

 
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.