Jump to content

Gsak - Keeping It Up To Date?


Recommended Posts

Ok - I've managed to creat PQ's to get all caches in the UK to date to populate GSAK. I read Mark & Lynn's excellent Paperless Caching Guide and they say they run a weekly PQ of just those caches updated in the last 7 days.

 

This was ok when they wrote their guide, but running it today returns over the max of 500 records.

 

My question is how do others get round this and ensure their GSAK database is up to date?

Link to comment

I find that if you do not run the full PQ's on a weekly basis it is harder to identify archived caches, as archive caches never appear in PQ's you have to filter them and mark them as such in the GSAK database. If you only run update caches then it is more difficult to identify archived as the last GPX update filter will not work as efficiently, because caches that have not been visited in that week or before will have last gpx dates of a week or more.

 

Moote

Link to comment
Ok - I've managed to creat PQ's to get all caches in the UK to date to populate GSAK. I read Mark & Lynn's excellent Paperless Caching Guide and they say they run a weekly PQ of just those caches updated in the last 7 days.

 

This was ok when they wrote their guide, but running it today returns over the max of 500 records.

 

My question is how do others get round this and ensure their GSAK database is up to date?

Could you answer the first part of this question too. (PQs for all uk)

 

Can GSAK handle all of the uk in one database?

Doesnt it slow up the pc if you have GSAK, Memorymap and a browser (or 2) open all at the same time.

Link to comment
Could you answer the first part of this question too. (PQs for all uk)

 

Can GSAK handle all of the uk in one database?

Doesnt it slow up the pc if you have GSAK, Memorymap and a browser (or 2) open all at the same time.

Manncubs

 

I think GSAK can handle many more records than the 9000+ UK caches, if you wish to download them all, then use dates to divide the data and not locations.

 

Moote

Link to comment

OK

21 PQ's obtains the UK database at present

 

I use updated in the last 7 days in the spare PQ slots to keep the database more up to date it has always returned more than 500 results.

 

I run the PQ xx date to december 2008 every day to obtain all new caches.

 

In addition it is necessary to find in GSAK caches that have not been updated recently (use the column Last GPX update) you then need to download these individually as they will be permanently archived caches.

 

EDit to add

GSAK can handle HUGE databases

Edit to add

You need to run all the pqs every week or delete you old database every time to remove stale data

Edited by markandlynn
Link to comment

Hi,

 

Well how I get around archive caches is by deleting any waypoint that hasn't been updated by a PQ in the last 14 days.

 

You will need a filter called "Old Caches (Over 14 days old)" which displays caches that haven't been updated for 14 days, Don't have corrected co-ords and I haven't found.

 

Also this works on a database called "England", so you don't purge the incorrect database.

 

I wrote a macro to do this which is here :-

 

>>

#

# This macro will delete old waypoints, based on the filter

#

 

# debug status=on

 

CANCELFILTER

DATABASE NAME="England" Action=select

FILTER Name="Old Caches (Over 14 days old)"

 

if $_filtercount=0

return

endif

 

INPUT msg="Are you sure you want to delete old waypoints? (y/n)" default="n" VarName=$answer

if $answer = "y"

DELETE Settings="items_in_filter"

endif

<<

 

Use at your own risk, whatever is in the filter will be removed. So make sure you have the filer correct before you run the macro.

 

I then get GSAK to run this macro at startup.

 

See ya...Gary

Link to comment

Hi

 

I've managed to get the database in 19 PQs, if that is any help - at least this way it falls into our weekly allowance!!! The only thing is, give it a couple of months and the database will exceed the 20 PQs allowed :wacko:

 

1. 01/01/00 – 29/07/02

2. 30/07/02 – 29/03/03

3. 30/03/03 – 18/08/03

4. 19/08/03 – 23/01/04

5. 24/01/04 – 19/04/04

6. 20/04/04 – 26/06/04

7. 27/06/04 – 03/09/04

8. 22/08/04 – 26/11/04

9. 27/11/04 – 05/02/05

10. 06/02/05 – 23/03/05

11. 24/03/05 – 21/04/05

12. 22/04/05 – 21/05/05

13. 22/05/05 – 04/07/05

14. 05/07/05 – 13/08/05

15. 14/08/05 – 19/09/05

16. 20/09/05 – 28/10/05

17. 29/10/05 – 11/12/05

18. 12/12/05 - 21/01/06

19. 22/01/06 -

Link to comment

Hi

 

I've managed to get the database in 19 PQs, if that is any help - at least this way it falls into our weekly allowance!!! The only thing is, give it a couple of months and the database will exceed the 20 PQs allowed :D

 

1. 01/01/00 – 29/07/02

2. 30/07/02 – 29/03/03

3. 30/03/03 – 18/08/03

4. 19/08/03 – 23/01/04

5. 24/01/04 – 19/04/04

6. 20/04/04 – 26/06/04

7. 27/06/04 – 03/09/04

8. 22/08/04 – 26/11/04

9. 27/11/04 – 05/02/05

10. 06/02/05 – 23/03/05

11. 24/03/05 – 21/04/05

12. 22/04/05 – 21/05/05

13. 22/05/05 – 04/07/05

14. 05/07/05 – 13/08/05

15. 14/08/05 – 19/09/05

16. 20/09/05 – 28/10/05

17. 29/10/05 – 11/12/05

18. 12/12/05 - 21/01/06

19. 22/01/06 -

 

many thanks for this.

saved me hours of head scratching.

 

needs a little update from orig post:

 

19. 22/01/06 - 15/02/06

20. 16/02/06 -

 

out of interest how do you schedule these to run

and when do you do your import into gsak.

 

i was thinking of doing 4 blocks of 5, from monday thru thursday.

then an import on friday (using 'get data from email').

so i'm up-to-date and hot-to-trot for the weekend .

 

thanks again

Link to comment

I use the same setup - and run them Monday to Thursday (or rather Friday now - 21 queries) but I use the GETMAIL function to get them straight from my e-mail account - every time I load GSAK it checks for and imports PQs, then displays any that haven't been updated for a week - these are the likely archived caches, which I then download manually.

 

i then import these manual downloads and move these to an archived database. All very automated and trouble-free so far!

 

Dave

Link to comment

I use the same setup - and run them Monday to Thursday (or rather Friday now - 21 queries) but I use the GETMAIL function to get them straight from my e-mail account - every time I load GSAK it checks for and imports PQs, then displays any that haven't been updated for a week - these are the likely archived caches, which I then download manually.

 

i then import these manual downloads and move these to an archived database. All very automated and trouble-free so far!

 

Dave

 

John Stead has mentioned GETMAIL in GSAK to me before....

...sounds great.

 

How do I set it up?

Can I use it with Hotmail???

 

Cheers

Dave

Link to comment

I use the same setup - and run them Monday to Thursday (or rather Friday now - 21 queries) but I use the GETMAIL function to get them straight from my e-mail account - every time I load GSAK it checks for and imports PQs, then displays any that haven't been updated for a week - these are the likely archived caches, which I then download manually.

 

i then import these manual downloads and move these to an archived database. All very automated and trouble-free so far!

 

Dave

 

John Stead has mentioned GETMAIL in GSAK to me before....

...sounds great.

 

How do I set it up?

Can I use it with Hotmail???

 

Cheers

Dave

Information

 

Getmail downloads your pocket queries and processes them into GSAK automatically (One button click). You need to setup the email side with the various parameters required for logon and connection.

 

Now Hotmail does not use POP/SMTP (Unless you pay Microsoft for that privilege); there is a solution to this and that is HotPopper, but this can make the whole affair clumsy!

Link to comment

Quote from Moote

 

Now Hotmail does not use POP/SMTP (Unless you pay Microsoft for that privilege); there is a solution to this and that is HotPopper, but this can make the whole affair clumsy!

 

 

I googled hotmail and pop3 and saw an alternative to Hotpopper, viz Pop3Hot but looking at that find it has been superceded. Have a look at the website izysoft.com and you may find izymail is the answer. I have not tried it but there appears to be a free lite version. As Dave originally said I use Getmail all the time and have set it as a toobar button, initially it can be accessed from the GSAK files dropdown.

Edited by John Stead
Link to comment

i cant get the getmail feature to work for me on my work pc.

It works fine at home though.

Is it possible to export a database (home) and then import it into another gsak installation (work)?

Fact

 

Some email services only allow an email to be downloaded once, this is to preserve bandwidth and server loading. Is this the reason?

Link to comment

Quote from Moote

 

Now Hotmail does not use POP/SMTP (Unless you pay Microsoft for that privilege); there is a solution to this and that is HotPopper, but this can make the whole affair clumsy!

 

 

I googled hotmail and pop3 and saw an alternative to Hotpopper, viz Pop3Hot but looking at that find it has been superceded. Have a look at the website izysoft.com and you may find izymail is the answer. I have not tried it but there appears to be a free lite version. As Dave originally said I use Getmail all the time and have set it as a toobar button, initially it can be accessed from the GSAK files dropdown.

 

Had a look at both HotPopper :) (way too complicated for me) and izysoft.com which carges for its services.

MS has an upgrade product called Hotmail plus for £14.99 per year, says it will work with MS Outlook Express etc. would that be suitable for GetMail purposes?

 

Cheers

Dave

Link to comment

I created a gmail (now googlemail, I believe) specifically for PQs. GSAK accesses that without problem and with 2Gb of mail box space, you can easily keep a months worth of PQs in case you ever need them.

 

Limited Beta test I'm affraid and no date for general release as yet!

 

So does Hotmail Plus work or not?

 

Cheers

Dave

Opinion

 

Why pay £14.99 for facilities that others give for free? If you want a GMail account I can give you one of mine if you like; that is far better than paying £14.99

Link to comment

I created a gmail (now googlemail, I believe) specifically for PQs. GSAK accesses that without problem and with 2Gb of mail box space, you can easily keep a months worth of PQs in case you ever need them.

 

Limited Beta test I'm affraid and no date for general release as yet!

 

So does Hotmail Plus work or not?

 

Cheers

Dave

 

I can send you a invite if you want one

Link to comment

Quote from Moote

 

Now Hotmail does not use POP/SMTP (Unless you pay Microsoft for that privilege); there is a solution to this and that is HotPopper, but this can make the whole affair clumsy!

 

 

I googled hotmail and pop3 and saw an alternative to Hotpopper, viz Pop3Hot but looking at that find it has been superceded. Have a look at the website izysoft.com and you may find izymail is the answer. I have not tried it but there appears to be a free lite version. As Dave originally said I use Getmail all the time and have set it as a toobar button, initially it can be accessed from the GSAK files dropdown.

 

Had a look at both HotPopper :) (way too complicated for me) and izysoft.com which carges for its services.

MS has an upgrade product called Hotmail plus for £14.99 per year, says it will work with MS Outlook Express etc. would that be suitable for GetMail purposes?

 

Cheers

Dave

 

If you go through to the izysoft.com download you will find that there is an option for a limited free version which will only work with a single email account - I did not download it so can't say how it works but it MAY fulfill your need.

Link to comment

Why would you need all 9000ish caches in the UK continually updated? :)

 

I travel with my job and have various PQ's for my regular haunts.

 

If I am going somewhere other than that I set up one a day or so before.

 

I have one for 50 miles around my home which updates daily, and that pretty much does the trick.

 

Cheers

Dave

 

mainly cos I'm not forward thinking or planned enough to either know where I'm going to be, or to set up a PQ to cover it, so its easy to have them all in GSAK. Also, I can do interesting (??) stats if I like, and if we're going on a long journey, I can use arc filters to get me all the caches within a mile or so of the route - otherwise I'd need PQs to cover all the area between home and destination, and I'm sure I'd miss some!

 

This way, It needs no input from me at all, and I can go caching at the last minute, just by bunging a few caches on the GPS.

 

each to their own though!

Link to comment

Why would you need all 9000ish caches in the UK continually updated? :)

 

I travel with my job and have various PQ's for my regular haunts.

 

If I am going somewhere other than that I set up one a day or so before.

 

I have one for 50 miles around my home which updates daily, and that pretty much does the trick.

 

Cheers

Dave

 

mainly cos I'm not forward thinking or planned enough to either know where I'm going to be, or to set up a PQ to cover it, so its easy to have them all in GSAK. Also, I can do interesting (??) stats if I like, and if we're going on a long journey, I can use arc filters to get me all the caches within a mile or so of the route - otherwise I'd need PQs to cover all the area between home and destination, and I'm sure I'd miss some!

 

This way, It needs no input from me at all, and I can go caching at the last minute, just by bunging a few caches on the GPS.

 

each to their own though!

 

 

 

 

No, no a fine answer....

 

My ignorance regarding the automatic GETMAIL script led me to believe that continually updating GSAK

would be a real time consuming business......

 

I may now have to have a real re-think. B)

 

Cheers

Dave

Link to comment

Why would you need all 9000ish caches in the UK continually updated? B)

 

I travel with my job and have various PQ's for my regular haunts.

 

If I am going somewhere other than that I set up one a day or so before.

 

I have one for 50 miles around my home which updates daily, and that pretty much does the trick.

 

Cheers

Dave

 

mainly cos I'm not forward thinking or planned enough to either know where I'm going to be, or to set up a PQ to cover it, so its easy to have them all in GSAK. Also, I can do interesting (??) stats if I like, and if we're going on a long journey, I can use arc filters to get me all the caches within a mile or so of the route - otherwise I'd need PQs to cover all the area between home and destination, and I'm sure I'd miss some!

 

This way, It needs no input from me at all, and I can go caching at the last minute, just by bunging a few caches on the GPS.

 

each to their own though!

 

 

 

 

No, no a fine answer....

 

My ignorance regarding the automatic GETMAIL script led me to believe that continually updating GSAK

would be a real time consuming business......

 

I may now have to have a real re-think. :laughing:

 

Cheers

Dave

 

Sorry Dave, obviously I was too vague about Getmail last time we had pints in our hands - maybe do better next week? :)

Link to comment

Fact

 

Getmail settings for Googlemail accounts

 

Username: YourUserName@googlemail.com

Password: YourPassword

Pop3 server: pop.googlemail.com

Port#: 995

SSL Login: Ticked

Only Check New messages: Unticked

After Download: leave on server

If Attachment Exists: Rename

Folder To Save Attachements: C:\GSAKImports (Or where ever you wish really)

 

Subject Contains: [GEO] Pocket Query:

Ignore Case: Ticked

Load folder of current attachments....... ticked

 

All other fields as you wish :)

Link to comment

I created a gmail (now googlemail, I believe) specifically for PQs. GSAK accesses that without problem and with 2Gb of mail box space, you can easily keep a months worth of PQs in case you ever need them.

 

Limited Beta test I'm affraid and no date for general release as yet!

 

So does Hotmail Plus work or not?

 

Cheers

Dave

 

Invites for gmail are dime a dozen, so that really throws out the window the idea of a limited beta and it is very stable for a beta release.

Link to comment

I created a gmail (now googlemail, I believe) specifically for PQs. GSAK accesses that without problem and with 2Gb of mail box space, you can easily keep a months worth of PQs in case you ever need them.

 

Limited Beta test I'm affraid and no date for general release as yet!

 

So does Hotmail Plus work or not?

 

Cheers

Dave

 

Invites for gmail are dime a dozen, so that really throws out the window the idea of a limited beta and it is very stable for a beta release.

If anyone wants an invite, just send me a PM, I have 99 of them to get rid of.

Link to comment

 

 

Sorry Dave, obviously I was too vague about Getmail last time we had pints in our hands - maybe do better next week? :)

 

No prob's John, got it sorted now....

 

......dedicated googlemail account just for PQ's so I don't even have to see them! GSAK all set up now.

 

Just have to decide on new all encompassing stategy for my PQ's.

 

See you in the Griffin. B)

 

Dave

Link to comment

Fact

 

Getmail settings for Googlemail accounts

 

Username: YourUserName@googlemail.com

Password: YourPassword

Pop3 server: pop.googlemail.com

Port#: 995

SSL Login: Ticked

Only Check New messages: Unticked

After Download: leave on server

If Attachment Exists: Rename

Folder To Save Attachements: C:\GSAKImports (Or where ever you wish really)

 

Subject Contains: [GEO] Pocket Query:

Ignore Case: Ticked

Load folder of current attachments....... ticked

 

All other fields as you wish :)

 

It's not necessary to have "After Download: leave on server" selected as googlemail will keep deleted items in the trash folder for 30 days. B)

Link to comment

Fact

 

Getmail settings for Googlemail accounts

 

Username: YourUserName@googlemail.com

Password: YourPassword

Pop3 server: pop.googlemail.com

Port#: 995

SSL Login: Ticked

Only Check New messages: Unticked

After Download: leave on server

If Attachment Exists: Rename

Folder To Save Attachements: C:\GSAKImports (Or where ever you wish really)

 

Subject Contains: [GEO] Pocket Query:

Ignore Case: Ticked

Load folder of current attachments....... ticked

 

All other fields as you wish :)

 

It's not necessary to have "After Download: leave on server" selected as googlemail will keep deleted items in the trash folder for 30 days. B)

Fact

 

If I don't they get binned completely i.e. no getting them back! checked Googlemail settings and all is OK

 

Rather play it safe just in case things go wrong

Edited by Moote
Link to comment

Fact

 

Getmail settings for Googlemail accounts

 

Username: YourUserName@googlemail.com

Password: YourPassword

Pop3 server: pop.googlemail.com

Port#: 995

SSL Login: Ticked

Only Check New messages: Unticked

After Download: leave on server

If Attachment Exists: Rename

Folder To Save Attachements: C:\GSAKImports (Or where ever you wish really)

 

Subject Contains: [GEO] Pocket Query:

Ignore Case: Ticked

Load folder of current attachments....... ticked

 

All other fields as you wish :laughing:

 

It's not necessary to have "After Download: leave on server" selected as googlemail will keep deleted items in the trash folder for 30 days. :blink:

Fact

 

If I don't they get binned completely i.e. no getting them back! checked Googlemail settings and all is OK

 

Rather play it safe just in case things go wrong

 

I'm with Hi-Tek.... I've got the 'Delete' option checked. Gmail moves the PQs out of the 'Inbox' and into the

'Deleted Items' folder. Currently, that's holding 687 PQ's dating back to..... oh, a long time ago :rolleyes:

Link to comment

Fact

 

Getmail settings for Googlemail accounts

 

Username: YourUserName@googlemail.com

Password: YourPassword

Pop3 server: pop.googlemail.com

Port#: 995

SSL Login: Ticked

Only Check New messages: Unticked

After Download: leave on server

If Attachment Exists: Rename

Folder To Save Attachements: C:\GSAKImports (Or where ever you wish really)

 

Subject Contains: [GEO] Pocket Query:

Ignore Case: Ticked

Load folder of current attachments....... ticked

 

All other fields as you wish :laughing:

 

It's not necessary to have "After Download: leave on server" selected as googlemail will keep deleted items in the trash folder for 30 days. :blink:

Fact

 

If I don't they get binned completely i.e. no getting them back! checked Googlemail settings and all is OK

 

Rather play it safe just in case things go wrong

 

I'm with Hi-Tek.... I've got the 'Delete' option checked. Gmail moves the PQs out of the 'Inbox' and into the

'Deleted Items' folder. Currently, that's holding 687 PQ's dating back to..... oh, a long time ago :rolleyes:

 

Fact ...

 

It seems Mootes 'facts' would seem to be at odds to normal googlemail useage. A deleted email will stay in the the trash folder for 30+ days. Thanks for the confirmation Pharisee.

 

Further Fact ...

 

Just checked my Googlemail trash folder and there are Pq's there going back to 22nd Jan 2005 :(

Edited by Hi-Tek
Link to comment

Fact

 

Getmail settings for Googlemail accounts

 

Username: YourUserName@googlemail.com

Password: YourPassword

Pop3 server: pop.googlemail.com

Port#: 995

SSL Login: Ticked

Only Check New messages: Unticked

After Download: leave on server

If Attachment Exists: Rename

Folder To Save Attachements: C:\GSAKImports (Or where ever you wish really)

 

Subject Contains: [GEO] Pocket Query:

Ignore Case: Ticked

Load folder of current attachments....... ticked

 

All other fields as you wish :laughing:

 

It's not necessary to have "After Download: leave on server" selected as googlemail will keep deleted items in the trash folder for 30 days. :rolleyes:

Fact

 

If I don't they get binned completely i.e. no getting them back! checked Googlemail settings and all is OK

 

Rather play it safe just in case things go wrong

 

I'm with Hi-Tek.... I've got the 'Delete' option checked. Gmail moves the PQs out of the 'Inbox' and into the

'Deleted Items' folder. Currently, that's holding 687 PQ's dating back to..... oh, a long time ago :(

 

Fact ...

 

It seems Mootes 'facts' would seem to be at odds to normal googlemail useage. A deleted email will stay in the the trash folder for 30+ days. Thanks for the confirmation Pharisee.

 

Further Fact ...

 

Just checked my Googlemail trash folder and there are Pq's there going back to 22nd Jan 2005 :blink:

Fact

 

Just run in this mornings PQ's without the flag "After Download: leave on server", and these have gone completely they are not in any folder including the Deleted folder.

 

As far as I see it if the option "After Download: leave on server" is used it will prevent this happening. I have checked the Googlemail settings and nothing in there appears to be causeing this behaviour.

 

Also, what issue do you have with this being set? Looks like this is a whine for whining sake.

 

Further Fact ...

 

Better set than not set, as what harm will it cause! QED

Edited by Moote
Link to comment

 

Also, what issue do you have with this being set? Looks like this is a whine for whining sake.

 

Further Fact ...

 

Better set than not set, as what harm will it cause! QED

 

Not a whine, Moote.... You do it your way and I'll do it mine. I was merely refuting your earlier statement of 'fact' that if you have that particular option set, then the PQs are lost forever. For me and Hi-Tek, this is clearly not the case.

As for why I do it... If I didn't, then the e-mails with their PQ attachments would remain in the 'Inbox'. It's just the way I work, I don't like old emails 'cluttering up' the Inbox (on any of my email accounts) so I choose to have GSAK / G-mail move them to the Deleted Items folder once they've been downloaded.

 

Happy now? :laughing:

Link to comment

 

Also, what issue do you have with this being set? Looks like this is a whine for whining sake.

 

Further Fact ...

 

Better set than not set, as what harm will it cause! QED

 

Not a whine, Moote.... You do it your way and I'll do it mine. I was merely refuting your earlier statement of 'fact' that if you have that particular option set, then the PQs are lost forever. For me and Hi-Tek, this is clearly not the case.

As for why I do it... If I didn't, then the e-mails with their PQ attachments would remain in the 'Inbox'. It's just the way I work, I don't like old emails 'cluttering up' the Inbox (on any of my email accounts) so I choose to have GSAK / G-mail move them to the Deleted Items folder once they've been downloaded.

 

Happy now? :rolleyes:

 

Well I'm up and running with GetMail updating GSAK automatically from PQ's delivered to my new googlemail account (thanks Milton).

 

BTW....My googlemail seems to work just as Pharasee says. Getmail retrieves the PQ and deletes it from the inbox but I can still see it in googlemail in the deleted items folder.

 

I have followed Mark and Lynns instructions and have got the date PQ's all set.

 

However like the OP, I find running and update a bit pointless as it will only update a maximum of 500 waypoints.

 

I have tried creating numerous update files but this is getting out of hand. :blink:

 

So it seems that the database is only accurate to within a week...... :laughing:

 

So be confident that the information is correct I still need to download a further PQ of the area I intend to visit, which is what I did prior to setting up for a complete download of the UK database. :(

 

Unless anyone has a better way of working?

 

Cheers

Dave

Link to comment

apart from the gmail part, thats exactly how I do it. You are right that it is technically only up to date within a week. I'm not too fussed, but you could run an update file for local caches daily - your call! If I'm going away for a week, I might do a local PQ for the destination on the last day before I go.

 

I do get archive notifications and new cachje notifications for my local area, so that stops me hunting for archived caches!

Link to comment

i cant get the getmail feature to work for me on my work pc.

It works fine at home though.

Is it possible to export a database (home) and then import it into another gsak installation (work)?

Fact

 

Some email services only allow an email to be downloaded once, this is to preserve bandwidth and server loading. Is this the reason?

 

I'm using Gmail.

The error is a socket error # 10060 - whatever that is ?!?

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...