Cteating waypoint file from several trips

Hi all,
I have several trips/routes that I'm going to do, and those trips are to certain waypoints/bonuses. Without copying and pasting every trip from the trip direction page is there a way to create a waypoint listing, for 10 trips, easily? The purpose is to list the bonuses individually so I can add up my score and to check for duplicates.
Ride Safe,
Robert
  • Former Member
    0 Former Member
    I suspect you're going to need to export the data and perform that action using a third party tool! ~ Hope I'm wrong!

    I had hoped you could first combine all the routes (into one big "mess"), select all the points in this "huge mess" (looking at the cumulative route's properties, & then right click to copy so all the points could be saved in a new folder.
    (Then finally "Swap views", sort on position and then visually scan the list for duplicate coordinates.)

    ~It turns out the entire route is what is copied to the clipboard, so that won't quite work. But if you have Excel, you could open an exported csv file and do this.
  • No need to combine the routes, I think. And something like this (a different "view" of the same data) is where the database approach of BC shines.

    1. Creat a new empty list.
    2. Select the list your 10 routes are in, and by click, shift-click or CTRL-click, select all 10 routes.
    3. Right click, "send to..." and send the routes to the list created in step 1.
    4. Select new list and swap data/map views so the data is in the large right pane.
    5. Filter to show only the waypoints.

    Now all the waypoints, and only those waypoints, that are in the 10 routes will show, once per waypoint regardless of how many times they are used in the routes, and can be sorted by name, or coordinates to check for locational duplicates, or whatever. The list could be exported to a spreadsheet to calc bonus points or whatever. Opening the properties of any waypoint and selecting the "references" tab, you could see in which routes the waypoint is used.

    Remember not to modify any of the routes here, doing so will change them in the original list as well since they are all just pointers to the original routes. If you want to be able to modify the routes you are studying, then in the steps above, insert:
    2a. Right click, select "Duplicate", and when asked about duplicating waypoints, answer "No". This will create 10 new routes with the same waypoints, with names identical to the originals except followed by a "1". In step 3 above, for some reason you will have to re-select the duplicated routes to be able to get the "send to..." command in the context menu.

    Not sure if this will do exactly what you want, but it might get you close.
  • No need to combine the routes, I think. And something like this (a different "view" of the same data) is where the database approach of BC shines.

    1. Creat a new empty list.
    2. Select the list your 10 routes are in, and by click, shift-click or CTRL-click, select all 10 routes.
    3. Right click, "send to..." and send the routes to the list created in step 1.
    4. Select new list and swap data/map views so the data is in the large right pane.
    5. Filter to show only the waypoints.

    Now all the waypoints, and only those waypoints, that are in the 10 routes will show, once per waypoint regardless of how many times they are used in the routes, and can be sorted by name, or coordinates to check for locational duplicates, or whatever. The list could be exported to a spreadsheet to calc bonus points or whatever. Opening the properties of any waypoint and selecting the "references" tab, you could see in which routes the waypoint is used.

    Remember not to modify any of the routes here, doing so will change them in the original list as well since they are all just pointers to the original routes. If you want to be able to modify the routes you are studying, then in the steps above, insert:
    2a. Right click, select "Duplicate", and when asked about duplicating waypoints, answer "No". This will create 10 new routes with the same waypoints, with names identical to the originals except followed by a "1". In step 3 above, for some reason you will have to re-select the duplicated routes to be able to get the "send to..." command in the context menu.

    Not sure if this will do exactly what you want, but it might get you close.


    THANKS, Sound reasonable and I will try it.

    It worked with a little work around:
    As you suggested I created a 'new list' and 'sent to' it all my routes. Next I used the 'view' in the tool bar to swap the map and data views, the data view listed my waypoints by name ie in a logical order. I highlighted the waypoints names I was interested in and 'exported' them as a txt file into Excel, and then filtered the data by tab. Not all data was in the same column BUT it was sequentially by name, so with a little cutting and pasting I have a listing of all my bonuses from all the routes.
    Your method is very easy and a dummy like me can do it!!! THANKS again.
    Ride Safe,
    Robert
  • Former Member
    0 Former Member
    Having spent little time with routes (mostly waypoints) I never realized that by default all instances of each waypoint (that make up a route) accompany the route when you replicate it to a different list. That makes it easy!
    I was messing around with "junk routes" I had created from "junk waypoints" in the 'Unlisted Data" folder. Working with them there I saw them. I just didn't think they would "accompany the route" throughout the folder tree...

    Notes:
    Even though the method presented by C14_RIDER works: You can only visualize the intersections as there is only one instance of each waypoint in the filtered NEW list. ~ I assumed the OP was trying to produce an actual list and not just a visual representation!

    Combining the routes into one big "junk route" does produce a list of all the points, including duplicates listed multiple times (when you open the route to look at the "junk route's" properties.) ~ But since you can't sort on the headers (looking at properties) this combined list with duplicates doesn't completely solve the problem for finding duplicates. That's why I was thinking about exporting this combined "junk route" and reading it in Excel. (And that does work when exported as csv.)

    PS: A neat little tool called "RouteConverter" at RouteConverter.com will give you a sortable neat little list (with duplicates shown) that you can view after exporting the combined "junk route" to a .gpx file from Basecamp. I suggest getting the "pre-release" version of RouteConverter as it includes a few worthwhile bug fixes. Also, once you figure things out: To sort you have to (in the convert tab of Route Converter after opening the file) first select either the route or the track rendition in the first dropdown list to see the multiple instances of each waypoint. Then (YOU MUST) first click on an actual kmz data field below, right click and then (and only then) right click on the header of the fields to find/use/select & apply the sort by descdription. (Just clicking on the header of the data fields doesn't enable the sort for some reason. And until you do this, it's initially visible but not selectable.)

    http://www.routeconverter.com/prereleases/en Voila, there is your list of organized duplicates.

    PS: RouteConverter runs as a standalone app, no install needed and there's even a "run off the web" version you don't have to save to run. (If you download,select the 32 bit version even if you're running 64bit windows, as the 64bit version of RouteConverter refers to having a 64bit java installed, which you most likely do not have. ~ even on 64bit windows. The web version may not have the bug fix (I found) that can cause trouble with weird characters used in your waypoiont names.)

    ~Kind of a neat tool!
  • Hi,
    The below in RED is my belief:


    Having spent little time with routes (mostly waypoints) I never realized that by default all instances of each waypoint (that make up a route) accompany the route when you replicate it to a different list. That makes it easy!
    I was messing around with "junk routes" I had created from "junk waypoints" in the 'Unlisted Data" folder. Working with them there I saw them. I just didn't think they would "accompany the route" throughout the folder tree...

    Notes:
    Even though the method presented by C14_RIDER works: You can only visualize the intersections as there is only one instance of each waypoint in the filtered NEW list. ~ I assumed the OP was trying to produce an actual list and not just a visual representation!

    Combining the routes into one big "junk route" I did not combine the routes into ONE route, they stayed as separate routes, not sure if that makes a difference or notdoes produce a list of all the points, including duplicates listed multiple times When I opened the entire list of routes, and swapped data/route views, their waypoints were in sequences which made it easy to 'select' the waypoints I wanted to sort/score. From there I 'exported' them because BC would not allow me to copy and paste in an Excel spreadsheet, BUT 'export' worked like I said with a little mutilation required.(when you open the route to look at the "junk route's" properties.) ~ But since you can't sort on the headers (looking at properties) this combined list with duplicates doesn't completely work Like I said a little data messing with, which was easy, gave me what I wanted.. That's why I was thinking about exporting them.Like I said coping did NOT work I had to 'export' the data to an Excel spreadsheet. I don't know why but right now I'm going with the flow and if it works I'm happy.


    Thanks for all the help and I have many more questions for sure before Garmin changes it!

    Robert
  • I highlighted the waypoints names I was interested in and 'exported' them as a txt file into Excel, and then filtered the data by tab. Not all data was in the same column BUT it was sequentially by name, so with a little cutting and pasting I have a listing of all my bonuses from all the routes.


    Actually if you export the list instead of the highlighted points, in .csv format, there is a section titled "wpt" that lists all the waypoints in that list all lined up nicely in the correct columns with column headings. You need only delete the other rows above and below and auto-width the columns and voila.
  • Former Member
    0 Former Member
    Actually if you export the list instead of the highlighted points, in .csv format, there is a section titled "wpt" that lists all the waypoints in that list all lined up nicely in the correct columns with column headings. You need only delete the other rows above and below and auto-width the columns and voila.


    True! But a simple export to a .gpx file from Basecamp, along with the "freebie" 3'rd party portable-app tool as described a few posts down: https://forums.garmin.com/showthread.php?66155-Cteating-waypoint-file-from-several-trips&p=236687#post236687 does exactly what he wants. (With only a few keystrokes after creating a seemingly meaningless collage of all the routes combined into one.)

    http://www.routeconverter.com/prereleases/en

    Note: This tool/solution should also works perfectly with combined tracks too. (RouteConverter considers a waypoint a waypoint, a track a direct line, and a route a "road-trip on pavement." (A simple way to differentiate between all 3 if you ask me!)
  • Actually if you export the list instead of the highlighted points, in .csv format, there is a section titled "wpt" that lists all the waypoints in that list all lined up nicely in the correct columns with column headings. You need only delete the other rows above and below and auto-width the columns and voila.


    I could not find 'wpt' I found 'wptID' but it was not the listing of the waypoint names? I converted to csv format as you said but when I pasted the data into Excel the waypoint 'names' were not under the 'wptID'. No sure why.
    Robert
  • I wonder if we are doing it the same way? You mention that you "pasted the data into Excel" but the way I did it there is no pasting to do. With the list selected, I went to File/Export/Export "listname" then selected csv in the file format, then Save. A file "listname.csv" is created, which can then be opened in Excel, and has multiple categories of data, one of which is headed "wpt", and all waypoints are listed in this section. I think if you select data and copy/paste it into Excel, it is less predictable what you'll get.

    I am running BC 4.1.2, not the latest, but I can't imagine they've changed the export format significantly between versions...
  • Hi,
    I am not as tech savy as you, please see my questions and comments below in RED.


    Having spent little time with routes (mostly waypoints) I never realized that by default all instances of each waypoint (that make up a route) accompany the route when you replicate it to a different list. That makes it easy!
    I was messing around with "junk routes" I had created from "junk waypoints" in the 'Unlisted Data" folder. Working with them there I saw them. I just didn't think they would "accompany the route" throughout the folder tree...

    Notes:
    Even though the method presented by C14_RIDER works: You can only visualize the intersections as there is only one instance of each waypoint in the filtered NEW list. ~ I assumed the OP was trying to produce an actual list and not just a visual representation!

    Combining the routes into one big "junk route" does produce a list of all the points, including duplicates listed multiple times (when you open the route to look at the "junk route's" properties.) ~ But since you can't sort on the headers (looking at properties) this combined list with duplicates doesn't completely solve the problem for finding duplicates. That's why I was thinking about exporting this combined "junk route" and reading it in Excel. (And that does work when exported as csv.)

    PS: A neat little tool called "RouteConverter" at RouteConverter.com will give you a sortable neat little list (with duplicates shown) that you can view after exporting the combined "junk route" to a .gpx file from Basecamp. I suggest getting the "pre-release" version of RouteConverter as it includes a few worthwhile bug fixes. Also, once you figure things out: To sort you have to (in the convert tab of Route Converter after opening the file) first select either the route or the track rendition in the first dropdown under the 'type' drop down menu there is a 'waypoint option? Can I use this?list to see the multiple instances of each waypoint. Then (YOU MUST) first click on an actual kmz data field below I have no idea what a kmz field is? sorry, right click and then (and only then) right click on the header of the fields by header fields do ou mean the column labeled 'description' etc?to find/use/select & apply the sort by description. (Just clicking on the header of the data fields doesn't enable the sort for some reason. And until you do this, it's initially visible but not selectable.)

    http://www.routeconverter.com/prereleases/en Voila, there is your list of organized duplicates.

    PS: RouteConverter runs as a standalone app, no install needed and there's even a "run off the web" version you don't have to save to run. (If you download,select the 32 bit version even if you're running 64bit windows, as the 64bit version of RouteConverter refers to having a 64bit java installed, which you most likely do not have. ~ even on 64bit windows. The web version may not have the bug fix (I found) that can cause trouble with weird characters used in your waypoiont names.)

    ~Kind of a neat tool!