5
Posts: 332
Threads: 39
Joined: February 27, 2006
Reputation:
0
I'm trying to import a large number of waypoints into MacENC. However, it seems the csv file I have doesn't match up correctly with MacENC's format (two may decimals, and seems to use a different ascii character for the ° symbol. Thought I could use GPSBable, but there is no simple 'csv' file option - they all seem associated with a specific program. Can someone tell me which file option in GPSBable will match with the MacENC csv file?
Scot
5
Posts: 1,947
Threads: 284
Joined: April 22, 2005
Reputation:
0
If possible use KML or GPX format to import waypoints, routes or tracks. Much easier to work with.
Scott Dillon
Sydney Australia
North Shore 38
CYCA
5
Posts: 332
Threads: 39
Joined: February 27, 2006
Reputation:
0
OK, making progress. Now see how I can get waypoints from MacENC into GPSBable, using gpx format. From there I can export to all sorts of formats. Where I'm having trouble is going the other direction. I can see where exporting from GPSBable to MacENC using gpx will work fine, but I'm having trouble getting the text file of waypoints I have into a format that GPSBable can import. I've tried all there apparently text import formats and they all have the coordinates in a +/- xxx.xxxxx rather than a (for example) 122° 48.123 N, which is what the waypoints I have are. Any suggestions? I can manualy modify them in Excel or Word, but then what's the point of using GPSBable? Any suggestions?
Scot
5
Posts: 769
Threads: 15
Joined: May 14, 2005
Reputation:
4
If you decide to use Excel, this formula will convert Latitudes (ddº mm.mmm' N) in cell A1 to decimal format (±nn.nnnnn)
=(LEFT(A1,2)*1+MID(A1,5,6)/60)*IF(RIGHT(A1,1) = "N",1,-1)
and for Longitudes (dddº mm.mmm' W) in cell A2:
=(LEFT(A2,3)*1+MID(A2,6,6)/60)*IF(RIGHT(A2,1) = "E",1,-1)
— —••• •••— —
Jon Longworth
5
Posts: 332
Threads: 39
Joined: February 27, 2006
Reputation:
0
Ahh thanks - That could be VERY helpful!!!
Scot
5
Posts: 769
Threads: 15
Joined: May 14, 2005
Reputation:
4
If you don't use Excel often, remember that you can apply the formula to the entire column by selecting the column containing the formula in the top cell and choosing Edit>Fill>Down.
I should also change the column/cell to B1 instead of A2 in the longitude formula:
=(LEFT(B1,3)*1+MID(B1,6,6 )/60)*IF(RIGHT(B1,1) = "E",1,-1
— —••• •••— —
Jon Longworth
1
Posts: 46
Threads: 13
Joined: February 24, 2010
Reputation:
0
I was able to do this, importing a large data base from Nobeltec VNS, using the GPS Babel web site. I uploaded the data base to the web site an the site converted it to files that could be read by the MacENC demo I had downloaded. I tied to do the same using the downloaded program version on my computer but ran into the same problem you did. I've now purchased the MacENC program and am awaiting delivery.
5
Posts: 332
Threads: 39
Joined: February 27, 2006
Reputation:
0
Thanks for the link - I was about to ask that question.
5
Posts: 332
Threads: 39
Joined: February 27, 2006
Reputation:
0
Wow, tried the website to convert the data and worked great! Thanks.
Scot
