[BaseCamp] populating cells in the BC properties box

[saddle sore]

Jerry

Thanks.  Oh, long answers are better than short -- for me.  I appreciate
the detail of the thought.  Don't assume that I intuitively know how to get
from A to C.  I appreciate the time taken to tell me there is a B in
between.  ;o)

As you suggested, I exported a fully populated waypoint.  Using Notepad, I
could see that all of the info from each cell was in the file.  I then
imported my waypoint back into BC.  I opened the properties box and all the
information in all the cells was there.

Perhaps you are correct that GPSVisualizer isn't the way to transfer all
the data from XLS to GPX.    I'll dig deeper into their tutorial, but will
also check GPSBabel.  I played with it a long time ago so I'll reacquaint
myself with it.  As for programming my own, HA.   The last programming I
did was when we used IBM punch cards back in the early 70s.  I had 4-5
languages down pat back then.  Oh my, that brings back so memories!!  LOL

Thanks, Joe



<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avg.com
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Fri, Dec 22, 2017 at 2:20 AM, Jerry White <jerrywhite518 at gmail.com>
wrote:

> I would first validate that those values can exist in a gpx file. Export a
> fully populated waypoint to gpx and open the file in a text editor.
>
> Then validate that basecamp can import them. Import your gpx back into
> basecamp and open it. See if that stuff survived the export/import process.
> Note: unless you rename the waypoint to a unique value, or delete the
> original one first, you’ll end up with a duplicate waypoint. BC will
> probably automatically rename it to _1 or something.
>
> So once you know for sure that basecamp can do what you want, now you have
> to figure out how to create a gpx file from your spreadsheet. I guess
> gpsvisualizer isn’t it. Gpsbabel maybe? Write your own in python or some
> other language?
>
> Sorry for the long answer. I don’t have a shorter one.
>
> Jerry
>
> On Thu, Dec 21, 2017 at 5:22 PM saddle sore <ironbutter at gmail.com> wrote:
>
> > I have a large XLS spreadsheet containing columns for Latitude,
> Longitude,
> > Name, Street, City, etc..... pretty much matching what you'd see BaseCamp
> > has as cells in the Properties tab when you click on a bonus site and
> open
> > it.
> >
> > To convert XLS to GPX, I am using GPSVisualizer. When I complete the
> > conversion, the only cells in the properties box in BaseCamp that contain
> > data are the Name, Display and Position.  The conversion seems to leave
> the
> > rest of the data behind.
> >
> > How can I get some of my other XLS info into the BC properties cells
> (like
> > Street, Cit, State, Phone)?
> >
> > Thanks,  Joe Y in western PA
> >
> >
> > <
> > http://www.avg.com/email-signature?utm_medium=email&
> utm_source=link&utm_campaign=sig-email&utm_content=webmail
> > >
> > Virus-free.
> > www.avg.com
> > <
> > http://www.avg.com/email-signature?utm_medium=email&
> utm_source=link&utm_campaign=sig-email&utm_content=webmail
> > >
> > <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
> >
> > 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
>
>