Loading puzzle cache coordinates in bulk into gsak

[+paulemma]

Hi there

 

I am sure i have done this in the past but have just got back into puzzle caches after a long break and need a little bit of help please.

 

I have solved a series of puzzle caches, 360 in total and have the solved coords on an excel file.  Is there a way i can load these onto GSAK in one go rather than individually, so i can then download them onto my etrex?

 

Thanks for any help.

 

 

[+ecanderson]

GSAK won't import what you've got natively (just *.gpx and *.loc), and I was about to point you to a macro on the site, but gsak.net is currently showing

 

[NEVER MIND previous.  GSAK is fine.]

 

Edited March 6, 2021 by ecanderson

[+ecanderson]

All better now. 

 

If I understand your needs...

 

You'll want to load all of those puzzles into a GSAK database first, then update the coordinates.

 

Here's what you want to look at.  You can turn your Excel file into a *.csv and with some minor tweaking, use this >> https://gsak.net/board/index.php?s=7a8fabc6c508ffd5194836c2c49af3f0&showtopic=19266&st=0&#entry156236

 

[+paulemma]

Thank you very much for your help HHL and ecanderson.  I have now managed to do it with you help.

[+ham fam]

So to confirm, there is NO way to take a "corrected coordinate" that is corrected on GC.com only, and sending that to GSAK?  So I can then send to my GPSr.  Is this true?

[+The lost wanderers]

On 6/5/2021 at 5:22 PM, HHL said:

No, that's not true. (your so-called "confirming" is just a non understanding)

1. Do an Advanced Search and filter for "Updates coordinates only".

2. Put the resulting caches to a Bookmark List.

3. Download that Bookmark List to GSAK

Is there a reversal to this? I have corrected caches in GSAK and want to upload them into GC.com