Getting GSAK to output decimal degrees to 5 decimal places

[+admo1972]

Problem: I have a Mio C230 for my car, and I want to put a bunch of caches on it so I can seem them on the map as I drive around. I can enter POI's one by one using various formats, but sending them to the unit in batch has to adhere to decimal degrees in 5 decimal places. For example, N40.65000 is okay, but N40.65 won't. The POI loader just refuses to send any POI's that don't adhere to having exactly 5 decimal places.

 

I can get GSAK to display the coordinates in decimal degrees, but some are 3 digits, other 4, etc. Is there any way to force GSAK to have every cache at 5 decimal places?

 

My current work around is to export the caches as a csv, open said file in excel and then format the coordinates to 5 decimal places, then resave the csv, and then upload it to the Mio. I'm looking to see if there is a way to eliminate the excel step. To confuse this further, I have GSAK on my windows partition on my mac, but only have excel for my Mac OS. So I would have to export the csv from GSAK, reboot into MacOS, open the csv in excel, format the longitude/latitude columns, save the csv to the windows partition, reboot into XP, and then upload the csv to the mio. I should look get open office on my Windows partition... That will solve the reboot problem...

[+Red90]

It could be done with a macro.

 

I would suggest going to the GSAK forums. Some keen person will write you up the macro code......

[+GPSlug]

The POI loader will also accept GPX files. Does it work if you export as that?

[Dosido]

The POI loader will also accept GPX files. Does it work if you export as that?

Garmin POI Loader may accept GPX, but not the Mio POI Loader. Two different animals.

[Dosido]

I don't think you're correct when you say the Mio POI Loader will only accept 5 digits after the decimal. However, it may depend on whether you're enclosing the lat/lon in quotes.

 

Try this - I just uploaded these 'caches along a route' to the Mio C230 without a problem:

 

-72.593783,42.076217,"Agawam's Old Red Barn","Traditional Cache"

-72.6044,41.953917,"A Soldiers Sunset Cache","Traditional Cache"

-72.690117,41.861433,"Barber Pond Dam #17","Traditional Cache"

-72.557967,42.11935,"Colleges of Springfield Tour - AIC","Traditional Cache"

-72.555433,42.10065,"Colleges of Springfield Tour - Springfield College","Traditional Cache"

-72.583167,42.109033,"Colleges of Springfield Tour - STCC","Traditional Cache"

-72.664083,41.750583,"Colt Revolver: Second Chamber","Traditional Cache"

-72.662667,41.756,"Colt Revolver: Target","Unknown Cache"

-72.66395,41.752567,"Colt Revolver: Third Chamber","Traditional Cache"

-72.645833,41.932217,"Happy Heart day Cache","Traditional Cache"

-72.606383,41.955583,"Kings Island Cache","Traditional Cache"

-72.597883,42.124967,"Peligro!","Traditional Cache"

-72.679283,41.799067,"Scary in Several Ways","Traditional Cache"

-72.67715,41.7075,"SMK-25 Wintergreen Dash","Traditional Cache"

-72.674767,41.706683,"SMK-26 Wintergreen Stash","Traditional Cache"

-72.666617,41.693117,"SMK-27 Mill Woods Memories","Unknown Cache"

-72.665433,41.6883,"SMK-29 Firepit","Traditional Cache"

-72.687117,41.874767,"SMK-85 The Trip & PicklesMcGee","Traditional Cache"

-72.550833,42.142283,"SpringVille - 3 -- Baby Machine #1","Traditional Cache"

-72.587067,42.083683,"Team S&M Pocket Park #9","Traditional Cache"

-72.58545,42.081167,"Western Mass Scale Solar System - Mercury","Traditional Cache"

-72.677367,41.705867,"Wintergreen Cache","Traditional Cache"

 

GSAK exported the lat/lon with quotes around them, and it failed. I removed the quotes, and was good to go.

 

Oh - I see you used "N" in front of your lat - only use the numbers...click on the ? on the POI Loader to get more info on what's acceptable (very little)

Edited April 5, 2008 by Dosido

[Dosido]

With the standard GSAK csv export, as stated, the file created contains quotes around the lat & long figures. The Mio POI Loader chokes on those. Fortunately, Clyde is a genius and gave us the TEXTOUT macro function.

 

The macro that GSAK shows as the example is very close to what we need for the Mio output. A couple of quick edits and this should give you what you're looking for:

Goto Position=Top
while not($_eol)
$_txt1 = $d_longitude
$_txt2 = $d_latitude
$_txt3 = Quote($d_name)
$_txt4 = Quote($d_container)
$result = TextOut("C:\Documents and Settings\The Whites\Desktop\miocaches.csv","none","comma")
# Just in case file permission error or something test for error
IF Left($result,7) = "*Error*"
  Pause Msg=$result
  Cancel
EndIf  
Goto position=next
Endwhile