[BaseCamp] from Excel xls to BaseCamp waypoint gpx

[saddle sore]

Joel

When I used the GEP browse option to locate the desired Excel file on my C
drive, I clicked on my Excel file just the same as I did when using the
GPSV browse.  Using that xls file, GEP then located each site (limited to
200 without a fee) on its globe/map.  It worked as an xls file imported to
GEP.

But since you mentioned saving as csv then importing to GEP, I tried that.
It too worked.  The GEP map of the sites looked the same as when I did it
using the xls file.  Then I noticed that even though all of my columns from
the xls file saved over to the csv file, not all of that data was saved by
GEP as kml.  GEP saved only the site name, latitude and longitude.  Opened
the BC waypoints properties box and only those three items were there.  At
least importing an xls file straight into BaseCamp brought in those three
items, plus what I had as a column titled Description (it put that info
into the Notes tab in the BC waypoint property box).

So I've found no advantage to taking on the extra steps of converting to
csv then opening GEP and creating kml files.  But that lack of advantage
could be operator error on my part.  Any idea what I might have done
wrong?  Please walk me through the steps from the point where I am seeing
the GEP map of the sites to then getting that into BaseCamp, as that is
where it goes fuzzy for me.

Thanks, Joe



On Mon, Mar 23, 2015 at 10:29 AM, Joel Tolbert <jjoeltolbert at gmail.com>
wrote:

> Joe,
>
> KML has become synonymous with Google Earth.  The pro version of Google
> Earth is now free, and removes a lot of the limitations of the previous
> "public" versions.  You will need to save your Excel files as "CSV" files
> from Excel to import.
>
> For license information in Google Earth Pro, enter your email address, and
> the license key is
>
> *GEPFREE*https://www.google.com/earth/explore/products/desktop.html
>
>
> Joel Tolbert
> Bethlehem, PA
> http://www.BubblerGPS.com
>
>
> > I've never played with a KML.
> >
> >
> >
> >
> >
> > On Sun, Mar 22, 2015 at 8:25 PM, Lynne Carey <gijane42104 at gmail.com>
> > wrote:
> >
> > > I believe you can import the KML file into basecamp and it brings that
> > with
> > > it doesn't it?  I seem to remember playing with it last year.  I then
> > > exported as GPX file
> > >
> > > On Sun, Mar 22, 2015 at 7:00 PM, saddle sore <ironbutter at gmail.com>
> > wrote:
> > >
> > > > Maura
> > > >
> > > > I have City location info already filling the Notes portion of the BC
> > > > waypoint.  I've been playng with column names in the Excel file prior
> > to
> > > > running GPSV, as well as shifting what is in the Excel columns so
> that
> > > GPSV
> > > > sees the info at different times in the conversion process.  I was
> > hoping
> > > > to match the Excel columns with the BC columns, but haven't figured
> > that
> > > > out yet.  The ordering of the columns in Excel does not seem to make
> > > > much/any difference in the way it comes out in BaseCamp.  Thus, I
> > haven't
> > > > been able to get the columns aligned (yet).
> > > >
> > > > BTW, when sorting waypoints in BC for an entire List of waypoints,
> why
> > > are
> > > > the columns not the same as when opening BC waypoint properties box
> > for a
> > > > single waypoint?  For a List, there is a column for Notes right after
> > the
> > > > column for waypoint name, but for an individual waypoint properties
> box
> > > the
> > > > Notes is a tab rather than a line item category.  Not a big issue,
> just
> > > > noticed it.
> > > >
> > > > Joe
> > > >
> > > >
> > > >
> > > > On Sun, Mar 22, 2015 at 7:38 PM, -=maura=- <moteramaura at gmail.com>
> > > wrote:
> > > >
> > > > > Put the state in the NOTES column. Put the state alone, or first,
> > > before
> > > > > any other info.
> > > > > You must match the columns in BaseCamp and Excel- BC has limited
> and
> > > > > specific columns, you must have those columns in excel for GPSV
> > > convert
> > > > >
> > > > > Give this a try,
> > > > > I have not done it and am unable to test at the moment.
> > > > >
> > > > > Maura
> > > > >
> > > > >
> > > > >  On 22/03/2015 4:23 PM, saddle sore wrote:
> > > > >
> > > > >> Hi
> > > > >>
> > > > >> I'm getting ready for 2015 Tour of Honor.  I want to make a gpx
> file
> > > of
> > > > >> the
> > > > >> 2015 info when it is all posted on April 1st, so I'm practicing
> with
> > > the
> > > > >> 2014 data.  I did a lot of cutting and pasting from the 2014 map
> to
> > > make
> > > > >> an
> > > > >> Excel spreadsheet containing columns of:  memorial name, city,
> > state,
> > > > lat,
> > > > >> long.
> > > > >>
> > > > >> I initiated GPSVisualizer for the conversion from xls to gpx.  I
> > read
> > > > >> through the tutorial at
> > > > >> http://www.gpsvisualizer.com/tutorials/waypoints.html and figured
> > out
> > > > >> some
> > > > >> of the column names MUST be specific names.  Then I used the
> > > conversion
> > > > >> box
> > > > >> on http://www.gpsvisualizer.com/convert_input?convert_format=gpx
> to
> > > > have
> > > > >> GPSVisualizer create a gpx file that I could download and then
> open
> > in
> > > > >> BaseCamp.
> > > > >>
> > > > >> I want to be able to be in BaseCamp and sort the waypoints by
> state.
> > > I
> > > > >> have one Excel column for State, and BaseCamp waypoint properties
> > box
> > > > has
> > > > >> a
> > > > >> place for State, but when converting to gpx from xls using
> > > > GPSVisualizer,
> > > > >> that State information is not coming over.  All I get from
> > > GPSVisualizer
> > > > >> is
> > > > >> name, desc, lat, and long.
> > > > >>
> > > > >> Does anyone have any hints on how I get the State information to
> be
> > > > >> converted from the Excel file to the BaseCamp waypoint properties
> > box?
> > > > >>  (I
> > > > >> realize that after the BaseCamp waypoints are created that I can
> > > > highlight
> > > > >> certain waypoints and give them all the same State abbreviations
> > > > manually.
> > > > >> But since I already have this in the Excel file along with the
> lat,
> > > long
> > > > >> and name, I'm thinking that the conversion process should include
> > the
> > > > >> State
> > > > >> info, not just name, lat and long.  The GPSVisualizer conversion
> > > process
> > > > >> places the City info into the BaseCamp waypoints' Notes properties
> > > line
> > > > >> since I have the Excel column header as Desc.  Why can't I pick up
> > the
> > > > >> State from Excel and have that show up in the BaseCamp waypoint
> > > > >> properties?
> > > > >> )  Any ideas?  Any better ways than using GPSVisualizer?
> > > > >>
> > > > >> Thanks, Joe Y
> > > > >> western PA
> > > > >>
> > > > >> To make _ANY_ changes, including unsubscribing from this list,
> click
> > > > >> ----->http://micapeak.com/mailman/listinfo/basecamp
> > > > >>
> > > > >>
> > > > >>
> > > > >
> > > > > To make _ANY_ changes, including unsubscribing from this list,
> click
> > > > ----->
> > > > > http://micapeak.com/mailman/listinfo/basecamp
> > > > >
> > > > >
> > > >
> > > > To make _ANY_ changes, including unsubscribing from this list, click
> > > ----->
> > > > http://micapeak.com/mailman/listinfo/basecamp
> > > >
> > > >
> > >
> > > To make _ANY_ changes, including unsubscribing from this list, click
> > ----->
> > > http://micapeak.com/mailman/listinfo/basecamp
> > >
> > >
> >
> > To make _ANY_ changes, including unsubscribing from this list, click
> ----->
> > http://micapeak.com/mailman/listinfo/basecamp
> >
> >
>
> To make _ANY_ changes, including unsubscribing from this list, click ----->
> http://micapeak.com/mailman/listinfo/basecamp
>
>