[BaseCamp] from Excel xls to BaseCamp waypoint gpx

[John Zabelle]

I upgraded to Google Earth Pro several weeks ago, but my copy of BaseCamp still uses the regular Google Earth.  I'm on a MacBook if that matters.

John Zabelle
Molino, FL
Sent from my iPad



> On Mar 23, 2015, at 9:45 AM, Jerry White <jerrywhite518 at gmail.com> wrote:
> 
> 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
> 
> To make _ANY_ changes, including unsubscribing from this list, click ----->http://micapeak.com/mailman/listinfo/basecamp
>