[BaseCamp] from Excel xls to BaseCamp waypoint gpx

[Jerry White]

OK so now I've upgraded to GEPro. Why did I do it?

Jerry

On Mon, Mar 23, 2015 at 7: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
>
>