The support forum is temporarily read-only. For urgent requests, please email contact[at]psyberia.net
[resolved] Cannot import csv waypoints
[resolved] Cannot import csv waypoints
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.
-
- Site Admin
- Posts: 6408
- Joined: Wed Apr 14, 2010 9:41 pm
Re: Cannot import csv waypoints
Hi,
What is the coordinate format of your X/Y. If it's UTM, then did you choose the correct UTM zone?
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 !
Re: Cannot import csv waypoints
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!
-
- Site Admin
- Posts: 6408
- Joined: Wed Apr 14, 2010 9:41 pm
Re: Cannot import csv waypoints
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:

If you give me the zone, I can tell you what coordinate format to use.
"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:

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 !
Re: Cannot import csv waypoints
They are UTM. It is zone11N (Nevada). The issue is how to format the csv file so that alpine can recognize it
-
- Site Admin
- Posts: 6408
- Joined: Wed Apr 14, 2010 9:41 pm
Re: Cannot import csv waypoints
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.
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 !
Re: Cannot import csv waypoints
Glory Hallelujah!! You did it! Thank you SO much =D =D
Re: [resolved] Cannot import csv waypoints
Where did you find the ID 32611 as indicating UTM zone 11? And where can I find additional ID'S for U.S. UTM zones?
Thanks
Thanks
-
- Site Admin
- Posts: 6408
- Joined: Wed Apr 14, 2010 9:41 pm
Re: [resolved] Cannot import csv waypoints
The EPSG gives a code to all coordinates systems so they can be distinguished easily.
I usually use this website to retrieve the codes: https://epsg.io/
It's not the official one, but it's a bit easier to use.
I usually use this website to retrieve the codes: https://epsg.io/
It's not the official one, but it's a bit easier to use.
Do you like AlpineQuest ? Leave a small comment on Google Play !
Re: [resolved] Cannot import csv waypoints
Thanks for sharing the link, official or unofficial I will take any one as long as it gets the work donePsyberia-Support wrote: ↑Wed Nov 16, 2022 11:25 am The EPSG gives a code to all coordinates systems so they can be distinguished easily.
I usually use this website to retrieve the codes: https://epsg.io/
It's not the official one, but it's a bit easier to use.