[BaseCamp] from Excel xls to BaseCamp waypoint gpx
Lynne Carey
gijane42104 at gmail.com
Sun Mar 22 17:25:04 PDT 2015
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
>
>
More information about the Basecamp
mailing list