The Hull Truth - Boating and Fishing Forum


Go Back   The Hull Truth - Boating and Fishing Forum > REGIONAL BOATING & FISHING GROUPS > The Carolinas

Notices

Random Quote: Why would women want a man with a 'six pack' when she could have me and the whole KEG!
Reply
 
Thread Tools Search this Thread
Old 07-19-2007, 11:18 AM
  #1    
Senior MemberCaptains Club Member
PLEDGER
 
Join Date: Aug 2003
Location: NC
Posts: 12,395
Default Waypoint Management Tip

A lot of us use Excel to keep a master log of waypoints and this format is also easy to share. So, how do you get way points from Excel into a format your GPS can use?

First of all, make sure your spreadsheet has the following column headers in this order:

1: Name (required)
2: Description (optional)
3: Latitude (required)
4: Longitude (required)
5: Symbol (optional, ex. fishing area, waypoint, reef, ship wreck)

Be sure the file is saved once you are done.

Next, in Excel, click on File Save As and in the file type drop down, select Comma Separated Values (CSV) and either use the same file name or enter a new one and click save.

Once the CSV file is created, got to this site: http://www.gpsvisualizer.com/convert

Click browse and navigate to the CSV file you created.

In the Output Format area, select GPX for the file type. GPX is a universal standard for most all GPSs programs.

In the Plain text delimiter area, select comma.

Click on Convert and wait a few seconds.

You will see a new screen that hopefully says Your data has been converted.

Right click on the file and select Save Target As and save the file to you computer.

The file is actually and XML file and can be opened by most all GPS software programs.

Hope this helps.
__________________
HOTSPOT is offline   Reply With Quote
Old 07-19-2007, 11:56 AM
  #2    
Senior MemberCaptains Club Member
 
Join Date: Jun 2003
Location: Charlotte / Southport
Posts: 1,498
Default Re: Waypoint Management Tip

YOU DA MAN !
Weekend-Hooker is offline   Reply With Quote
 
Old 07-19-2007, 12:24 PM
  #3    
Senior MemberCaptains Club MemberPLEDGER
 
Join Date: Oct 2003
Location: Broadway/Snead's Ferry,NC
Posts: 4,123
Default Re: Waypoint Management Tip

Ahhh.....what? Just kidding....your IT skills are too beyond me....been thinking of staying at a Holiday Inn Express, though
__________________

Cape Horn 31, Yamaha 350's
Intruder 198, 140 Suzuki
Greg Manning is offline   Reply With Quote
Old 07-19-2007, 03:00 PM
  #4    
Junior Member
 
Join Date: Jul 2007
Location: Portland, OR
Posts: 2
Send a message via AIM to adamschneider
Default Re: Waypoint Management Tip

Hi, I'm the creator of GPS Visualizer. Just wanted to let you know that it's actually a little easier than Hotspot has described, because you can also either:

1) Copy and paste your data from Excel directly into the text box on the conversion (or map) input form.

2) Upload your .xls file. If your points are in the first sheet of the workbook and formatted properly (with a header row), GPS Visualizer should be able to read them.
adamschneider is offline   Reply With Quote
Old 07-19-2007, 04:21 PM
  #5    
Senior MemberCaptains Club Member
PLEDGER
 
Join Date: Aug 2003
Location: NC
Posts: 12,395
Default Re: Waypoint Management Tip

Well I'll be dipped, it sure does, no CSV file required!!

Adam, would it be possible to add the field DEPTH ??
__________________
HOTSPOT is offline   Reply With Quote
Old 07-19-2007, 07:53 PM
  #6    
Junior Member
 
Join Date: Jul 2007
Location: Portland, OR
Posts: 2
Send a message via AIM to adamschneider
Default Re: Waypoint Management Tip

Quote:
HOTSPOT - 7/19/2007 12:21 PM

Adam, would it be possible to add the field DEPTH ??
You can add as many fields as you want, but I don't think GPX supports a tag, so it wouldn't end up in your output file. If you want depth, either add it as a negative altitude, or somehow include it in the "desc" field.
adamschneider is offline   Reply With Quote
Old 07-19-2007, 11:08 PM
  #7    
Senior MemberCaptains Club Member
 
Join Date: Apr 2006
Location: Sanford, NC
Posts: 407
Default Re: Waypoint Management Tip

Quote:
Greg Manning - 7/19/2007 11:24 AM

Ahhh.....what? :

__________________

Sea Pro 238 CC
BuzoDe45 is offline   Reply With Quote
Old 07-20-2007, 10:48 AM
  #8    
Senior MemberCaptains Club Member
 
Join Date: Dec 2003
Location: Minnesott Beach, NC
Posts: 556
Default Re: Waypoint Management Tip

Anyone figured out how to get it to work with cmap pc planner. I converted my garmin numbers to csv, and mached the header rows for cmap, but I do not seem to be able to get it to work.
__________________

Killin' Time
2008 Southport 28 TE
2008 Twin F250 Yamaha's
killintimeinnc is offline   Reply With Quote
Old 07-20-2007, 03:41 PM
  #9    
Admirals Club
 
Join Date: Jul 2007
Location:
Posts: 196
Default Re: Waypoint Management Tip

Adam:

Good to see more of FOSS working to help the fishing crowd! Keep up the good work! I tip my Red Hat to you...
bigfishhooker is offline   Reply With Quote
Old 07-20-2007, 04:56 PM
  #10    
Senior MemberCaptains Club Member
 
Join Date: Feb 2004
Location: Wilson, NC/Goose Creek Landing
Posts: 1,004
Default Re: Waypoint Management Tip

Damn, a computer guru too!!!
__________________
~
~~
~~~ ><((((:> LADDitude
~~
~
rdsrb5 is offline   Reply With Quote
 
 
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Waypoint Management Software Options??? phin Marine Electronics Forum 19 03-26-2010 09:25 AM
Raymarine C series waypoint management wellv20 Marine Electronics Forum 3 12-28-2008 03:49 PM
C-Series Waypoint Management HDRyder999 Marine Electronics Forum 5 07-27-2004 08:21 PM
Raymarine C Series Waypoint Management CharlieS Marine Electronics Forum 29 07-18-2004 02:39 PM
waypoint management questions MKM Marine Electronics Forum 12 01-04-2003 04:19 PM

 



©2009 TheHullTruth.com

Powered by vBulletin® Version 3.7.6
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0