BaseCamp / excel and Extra Poi Editor

 

looking to discuss how to do a few very different things with my Garmin(s)

currently i have access to 765 / 56 / 2495 and a few more that i do not know the numbers of.

-the setup -
I use a excel file to setup my run(s) for the day, typically 15-34 stops. Thru the magic of excel i can pull out GPS cords and thru excel -> csv -> Extra Poi Editor -> BaseCamp load them into my Garmin as a GPX file.

-Issues (2)-

1) Routing - BaseCamp will not always route via roads even though it is set to route as per trucking needs. It will, at times, just draw a straight line for 15 miles to the next stop. had this happen after i just routed my 30 stops (correctly using the local roads), got told i had help and to split it up, then both routes had the straight lines issue. I have also had the Garmin them selves give me the same issue. Today i had a customer which i got a straight line to, but after i got closer and routed again, found the right roads.

2)Easy removal of stops - as we hit different customers at different times, some of them are ran 2 times a week and others every 4-5 weeks. Thru my use of excel, the names of the stops are slightly changed due to where they are on the manifest, but have the exact same cords as previous trips. This leads to having MANY POI's at the exact same spot, and adds 1 more "POI" to the Garmin. so for 1,000 customers i might have 3,000 POI's or more... What i would like to do is to remove either a file (GPX on SD card..?) or to somehow be able to mass clear a certain category on the GPS w/o having to reset or remove 1 by 1.

All in all i really like my excel setup for pulling out the specific info that i need from a list of over 7K locations and being able to deal with just the ones of the day. With a few tweaks, this system is very handy and user friendly.

Thoughts?? Ideas??

thank you for reading it all smile

Taz

1 more thing

Sorry i forgot 1 thing.

on some customers, i do not have GPS cords, but i do have a good address (tested as i hand entered it into the GPS). For some reason, BaseCamp will NOT pick up the address and route it correctly. While usually this is not many, it happens enough that i need a way have BaseCamp work thru address as well.

Ideas??

Taz

EPE

Tazrunner wrote:

Sorry i forgot 1 thing.

on some customers, i do not have GPS cords, but i do have a good address (tested as i hand entered it into the GPS). For some reason, BaseCamp will NOT pick up the address and route it correctly. While usually this is not many, it happens enough that i need a way have BaseCamp work thru address as well.

Ideas??

Taz

Not being a user of BaseCamp, I do not know if this suggestion will help or not.

But, I would use EPE to get coordinates for this subset of customers.

I assume you are aware of the "Merge Open" capability of EPE. It sounds like you have one Excel file but you might want to have several - based on different factors.

Note that EPE has a "Find Duplicates" function under the "Edit" tab. Use this to get rid of duplicates.

I think that you are getting duplicates on the device because you are sending "routes" to your devices that wind up in "Favorites/Saved Places". From time to time, you could attach the device and manually delete the .gpx files so that you get a fresh start.

Even though you sound quite knowledgeable, we usually recommend the following to those new to the site.

There is a "Learn" button in the upper right of this page next to "red light cameras" that takes you to a Getting Started page. It is worthwhile visiting this page.

To make navigation easy, most browsers provide the following option. When you want to follow a link - but still keep your current page open - you can hold down the "Ctrl" key as you left-click on a link. That action will open a new "Tab" in your browser up on the "Tab" bar. When you then left-click on that new "Tab", you will follow the link - leaving the "Tab" you are now reading open and available to click on and return here.

So, using the "Learn" link, you might try the "Ctrl" - left-click sequence and then return here. You can return by either "X-ing" out of the "Getting Started" page (using the "X" on the "Tab" itself) or just left-clicking on the "Tab" for the page you are on right now.

Note that the Learn Button will give you access to two valuable reference pages -
the "Index" to all of the FAQs (Frequently Asked Questions) and the Glossary of Terms and Links.

Since you are new here, I encourage you to go through a couple of the Tutorials.

The first link makes sure the settings on your computer are such that you can do more advanced POI loading.
http://www.poi-factory.com/node/30393

The next link helps you make a backup of your GPS by attaching it to your computer. (NEVER do anything to your GPS until you have a backup). It also assures that you put your (newer) unit into a state where you can see all of the folders there.
http://www.poi-factory.com/node/30394

Still working on it..

Quote:

But, I would use EPE to get coordinates for this subset of customers.

i agree that EPE will grab the coords (1 by 1) but...
as the number of customers w/o GPS coords are over 1,000 and the main 2 files i use for my excel are updated every 30 days or so, this is a time consuming option that i would rather not do. I personally cannot go into the main system and update the GPS coords, even though they need to be done.. smile

yes there are duplicates, but they are on the Garmin, NOT in my excel file. they only happen as i upload newer routes, but i think i found a way around that now.

merge open will not help me as i get a custom list of stops each day, and those are the only ones i put on a new route.

Quote:

Note that the Learn Button will give you access to two valuable reference pages -
the "Index" to all of the FAQs (Frequently Asked Questions) and the Glossary of Terms and Links.

Since you are new here, I encourage you to go through a couple of the Tutorials.

The first link makes sure the settings on your computer are such that you can do more advanced POI loading.
http://www.poi-factory.com/node/30393

The next link helps you make a backup of your GPS by attaching it to your computer. (NEVER do anything to your GPS until you have a backup). It also assures that you put your (newer) unit into a state where you can see all of the folders there.
http://www.poi-factory.com/node/30394

Very good links, but saddly most of that i knew with 1 or 2 small tidbits that might be helpful for different projects down the road smile

Thank you for pointing this out.

I have been a lurker here for several years - just decided to register last night smile

Thank you for your help jgermann - greatly appreciated smile

--Update---
i did make up my route today on basecamp, and saved the file in to the SD card ( must be put in a sub folder named GPX) and with that was able to get my route. i then made a dummy file to test in the same manner and none of those showed up on my Fav tab, which is good. This means that i can save a massive customer list on the Garmin and still be able to have a route GPX file taht can be removed as per needed. This seems to have solved 1 issue for me. Now if i can get the routing to work better.

Today i had several customers with ok route to them and then suddenly i was going straight lines again. i can get around this by going in a editing the route to remove the ones done, and "start over" again with the new #1 stop and it will route me there just fine. then a stop or 2 later it will straight line again.

Straight line woes and database issue.

In BaseCamp (using Windows), if you double click the route, a properties window will open... in upper right corner if it say "Direct" you have a straight line...use the dropdown choice and select your activity profile..(trucking?) (Automobile) assuming you have set up that profile in EDIT>OPTIONS>Activity Profile... Choosing one will re calculate, the Direct route.

Stops and Database... I am not sure with your GPS, but with my Zumo 660, there is an Extra folder or Icon, you may have catagory...I see where you have them saved on the GPS. When you select one...it may be saved then in your My Favorite or Recently found or both. With the EXTRA the data remains there until I change it via Garmin POI Loader. So after your day stops or at end of week you can delete your Favorites and it will remain in the EXTRA folder. Again I can only delete data in my EXTRAS by using POI Loader to reload new or edited data.

Under the LEARN tab I have this:
http://www.poi-factory.com/node/41134

Lesson 17, I use POI loader.

I hope this helps!

--
DGN MTF, IBA, MOA, BMW 1200GSA My picture...I was doing a charity ride in Georgia, got my picture with my bike and mural required...then a nice lady ask if she could take my picture...I agreed...when I downloaded this is what I got... just call me M

@taz

Tazrunner wrote:

...
I use a excel file to setup my run(s) for the day, typically 15-34 stops. Thru the magic of excel i can pull out GPS cords and thru excel -> csv -> Extra Poi Editor -> BaseCamp load them into my Garmin as a GPX file.
...

I am trying to understand exactly what is meant by
Thru the magic of excel i can pull out GPS cords

This seems to imply that Excel is used to get "coordinates" of locations. Is that what you meant?

If not, how are the coordinates derived?

excel magic explained :)

Quote:

I am trying to understand exactly what is meant by
Thru the magic of excel i can pull out GPS cords

currently I get 2 files that i have to use together in order to pull out the info that i need into 1 tab. i then turn that tab into a CSV file and then it goes thru EPE. One has the GPS coords and the other has all other needed info.

Still going :)

Norwood wrote:

In BaseCamp (using Windows), if you double click the route, a properties window will open... in upper right corner if it say "Direct" you have a straight line...use the drop down choice and select your activity profile..(trucking?)

It is set to trucking now. I believe that the issue has to do with points it is trying to calculate to -- see my note above where i had a good route, then had to split it up and got straight lines after i split up the route into to 2 different routes using the exact same points.

Quote:

Stops and Database... I am not sure with your GPS, but with my Zumo 660, there is an Extra folder or Icon, you may have catagory...I see where you have them saved on the GPS. When you select one...it may be saved then in your My Favorite or Recently found or both. With the EXTRA the data remains there until I change it via Garmin POI Loader. So after your day stops or at end of week you can delete your Favorites and it will remain in the EXTRA folder. Again I can only delete data in my EXTRAS by using POI Loader to reload new or edited data.

noted - i will take a look at this - currently as of Friday when i tried this.. If i placed the file in the SD card in a GPX folder it did NOT load it into the Garmin. if this holds, then i can use that method to make up routes, while keeping the Garmin "clean" for my personal use ( as it is my personal device)

thank you for the ideas and help smile

Taz

More Tidbits You May or May Not Know

Very good links, but saddly most of that i knew with 1 or 2 small tidbits that might be helpful for different projects down the road smile

Thank you for pointing this out.

I have been a lurker here for several years - just decided to register last night smile

Thank you for your help jgermann - greatly appreciated smile

--Update---
i did make up my route today on basecamp, and saved the file in to the SD card ( must be put in a sub folder named GPX) and with that was able to get my route. i then made a dummy file to test in the same manner and none of those showed up on my Fav tab, which is good. This means that i can save a massive customer list on the Garmin and still be able to have a route GPX file taht can be removed as per needed. This seems to have solved 1 issue for me. Now if i can get the routing to work better.

Today i had several customers with ok route to them and then suddenly i was going straight lines again. i can get around this by going in a editing the route to remove the ones done, and "start over" again with the new #1 stop and it will route me there just fine. then a stop or 2 later it will straight line again.
[/quote]

The route point limitations of your GPSr may be a factor here. Garmin offers the following FAQ on the subject:

https://support.garmin.com/support/searchSupport/case.faces?...

Along with route creation instructions, the following FAQ describes the units that will accept 200 route points and those that will only accept 30.

https://support.garmin.com/support/searchSupport/case.faces?caseId={27edcdb0-0c86-11dd-dc9c-000000000000}

In spite of what Garmin says about route points in these FAQ’s, I also have the same issue with “straight lining” part way through a route. The problem occurs on both my 265 and 1490 GPSr’s after navigating beyond 9 route points even though the units routing preferences and map sets are identical to those set in Base Camp. I solve the issue by creating and importing multiple routes not exceeding 9 points. I realize this may not be a practical solution for you considering the size of your database.

I came across this article on “Bad GPS Data” which may also be contributing to the problem. In any case, it’s an interesting read:

https://strava.zendesk.com/entries/22645314-Bad-GPS-Data-Wha...

and it goes on..

bdhsfz6 wrote:

The route point limitations of your GPSr may be a factor here. Garmin offers the following FAQ on the subject:

https://support.garmin.com/support/searchSupport/case.faces?...

Along with route creation instructions, the following FAQ describes the units that will accept 200 route points and those that will only accept 30.

https://support.garmin.com/support/searchSupport/case.faces?caseId={27edcdb0-0c86-11dd-dc9c-000000000000}

In spite of what Garmin says about route points in these FAQ’s, I also have the same issue with “straight lining” part way through a route. The problem occurs on both my 265 and 1490 GPSr’s after navigating beyond 9 route points even though the units routing preferences and map sets are identical to those set in Base Camp. I solve the issue by creating and importing multiple routes not exceeding 9 points. I realize this may not be a practical solution for you considering the size of your database.

I came across this article on “Bad GPS Data” which may also be contributing to the problem. In any case, it’s an interesting read:

https://strava.zendesk.com/entries/22645314-Bad-GPS-Data-Wha...

you are correct in the 30 (actually 29) limit as i have had a couple of routes at 34-35, but it just split it into 2 runs. no biggie.

as to the bad data idea, i am not trying to Track where i am, only where i am going based upon a set of gps coords that are in a data base, placed there after it gets 3 readings to set the area.

my straight line issue i when i and trying to plot out the roads i need to take in order to hit all my stops for the day.

--today's update--
my route went to the straight line mapping right away, even with trucking (auto) option selected. today i had to hit them in a slightly different way, so i clicked on the reverse order option, and WOW it used the roads to route me... no straight lines..
will play more tomorrow..

sadly i do not have a bunch of time in the AM to try a lot of different approaches, so i do a little at a time. Also i got maybe a month before i have to have this working smoothly. at that point i will be running hard all winter smile

thanks again to all who have ideas and thoughts - and are willing to throw something out there. never know where the solution is going to come from smile

Taz

EPE and geocoding

EPE has a batch geocode function which will attempt to geocode any address with blank entries in the LON & LAT fields. (They need to be blank, not zero. Ask me how I know...) It's pretty slick. I've used it a bunch of times with mixed results. The failures usually occur because the address provided doesn't match the database that EPE is using closely enough to get a hit. I usually get 90%+ good results.

--
Striving to make the NYC Metro area project the best.

cool!

camerabob wrote:

EPE has a batch geocode function which will attempt to geocode any address with blank entries in the LON & LAT fields. (They need to be blank, not zero. Ask me how I know...) It's pretty slick. I've used it a bunch of times with mixed results. The failures usually occur because the address provided doesn't match the database that EPE is using closely enough to get a hit. I usually get 90%+ good results.

i just looked at the tab tools and saw it listed as the last item - new to me smile thank you for pointing that out smile
as to making sure its empty - that is ok, easy since i start out in excel smile

thank you.

-update-
i was able to make up a .GPI file and upload it to the SD card. When it asks if i want to load it into the Garmin, if i say no and let it read from the SD card only, i cannot press the "go" button to go to a location (but they do show up on the map as i drive around). IF i say yes, then it will allow me to route to a location.

the same number of locations in the GPI file when placed in a GPX file makes the Garmin sit at the loading map screen - sat that way for 2 hours before i forced a reboot. I know the locations are good as Basecamp will show all the locations. (1500 or so)

next step for me is to split up the 1500 and see if i can get it to load into the GPX side of things, as with GPX it will allow me to put the points in under saved favs in a specific category. easier to find that way then the GPI but i can go either way at the end of the day.

this is going to take a bit i think, but once i get it all figured out, i will have a great way to control the information that i need and might need at any given point.

thanks again for all the help smile