[resolved] Cannot import csv waypoints

You can post here if you have found a bug or if you are faced to a strange behavior.
CrystelM
Posts: 4
Joined: Mon May 17, 2021 3:51 pm

[resolved] Cannot import csv waypoints

Post by CrystelM » Tue May 18, 2021 1:08 am

Hi all, I’ve spent HOURS trying to import waypoints using csv file. I have version 2.2.8.c. My file is csv with the following columns; long (x) m, lat (y) m, name. I’ve following the directions precisely but nothing happens. I’m frazzled.

Psyberia-Support
Site Admin
Posts: 4884
Joined: Wed Apr 14, 2010 9:41 pm

Re: Cannot import csv waypoints

Post by Psyberia-Support » Tue May 18, 2021 6:59 am

Hi,
What is the coordinate format of your X/Y. If it's UTM, then did you choose the correct UTM zone?
Do you like AlpineQuest ? Leave a small comment on Google Play !

CrystelM
Posts: 4
Joined: Mon May 17, 2021 3:51 pm

Re: Cannot import csv waypoints

Post by CrystelM » Wed May 19, 2021 1:05 pm

Example: 286820, 4523024, A1 (next line) 286643, 4522116, A2 (etc). Then in the ‘import CSV file’ menu I choose my CSV folder, Charset equals UTF-8, Placemark equals Set of Waypoints, separator equals (,), Location Format equals UTM (WGS 84 meter), Headers in first row, Long (x) m, Lat (y) m, Name. Then I click ‘OK’ ...and nothing happens. I choose the UTM for the US. I’m on the West Coast in the US and I also place screen center near where I want the placemarks. Thank you so much for taking time to consider this!

Psyberia-Support
Site Admin
Posts: 4884
Joined: Wed Apr 14, 2010 9:41 pm

Re: Cannot import csv waypoints

Post by Psyberia-Support » Thu May 20, 2021 1:34 pm

Hi again,
"286820, 4523024" is not an UTM coordinate. UTM coordinates are like this: http://www.mibsar.com/LandNav/UTM/UTMco ... Detail.jpg

It looks like a TM coordinates (transverse mercator, but not universal). So you must choose the correct coordinate system, depending on your zone.
For the US, the zones are defined like this:
Image

If you give me the zone, I can tell you what coordinate format to use.
Do you like AlpineQuest ? Leave a small comment on Google Play !

CrystelM
Posts: 4
Joined: Mon May 17, 2021 3:51 pm

Re: Cannot import csv waypoints

Post by CrystelM » Sat May 22, 2021 2:30 am

They are UTM. It is zone11N (Nevada). The issue is how to format the csv file so that alpine can recognize it

Psyberia-Support
Site Admin
Posts: 4884
Joined: Wed Apr 14, 2010 9:41 pm

Re: Cannot import csv waypoints

Post by Psyberia-Support » Sun May 23, 2021 6:57 am

Thank you for the details.
So in the "CSV import" dialog, click on the "Location format" button, at the bottom of the menu click on "Import" and type Id "32611" (which is UTM zone 11).
Then assign your E to "X" and N to "Y" as you did.
Do you like AlpineQuest ? Leave a small comment on Google Play !

CrystelM
Posts: 4
Joined: Mon May 17, 2021 3:51 pm

Re: Cannot import csv waypoints

Post by CrystelM » Sun May 23, 2021 5:55 pm

Glory Hallelujah!! You did it! Thank you SO much =D =D

Post Reply