I was lost, but now I’ve found my way.

I have been spending the last couple of days playing around with the Magellan GPS software. A long time ago . . you know way back in time, like two years ago… I created a custom POI file for all the sites at the company for which I work. Now when I travel to them I can just select a “Custom POI” file and go! Also helps getting there from hotels, airports, etc.

Then last weekend we went for a drive to see the fall foliage, and had a hunger for a Starbucks coffee. Even with 9,000 or so of them in the US it isn’t always easy to find one. When we got back home I did an internet search and found a POI file for all the Starbucks in the US! Perfect, just what I wanted, a complete list to upload into the GPS!

BUT…., isn’t there always a “but” . . . there is a problem in getting them from the standard downloadable file format into the Magellan. Downloading a .CSV file works okay, and the Magellan POI program imports them okay. The first time I did this, I immediately imported it into the Magellan GPS and it worked like a charm. Then I saw the crazy descriptions for each location in the unit and decided I would clean them up. Since many of the descriptive names are longer (I think the Magellan limits it to about 16 spaces.) it would truncate the description in the unit and look strange and of no real help anyway. So I opened the .CSV file in Excel and changed all the names to “Starbucks”, nice and simple. Reimported into the Magellan POI software, saved everything and closed down for the night.

The next day getting ready to upload to the GPS unit, I opened my file again, and crap . . . it only had about four locations in it, when it should have had thousands! What the heck, well I must have saved it wrong, or maybe with the wrong name, or I opened the wrong file and so on. So I recreated the file again, carefully saving it as an ASCII .CSV file in a known location. Everything looks great now. So closed things down until I got the GPS unit to upload to later. Okay, now I am again ready to update the unit, so I open the Magellan POI software, open the carefully saved .MGLN file (special Magellan format they create within the software) and . . . . CRAP!! It is missing all the data except the same stinking four locations. Okay, go through the whole process again, check the locations before and after the ones that show up… they look fine. No strange characters, no extra commas (comma delimited .CSV file) everything is perfect, so save the file, reopen it and look at the beautiful work that I did . . . . CRAP! Gone again. Now being a fast learner and all I went through this process about 8 times with the exact same results everytime. (Insanity = doing the same thing you have always done and expecting different results. ) Finally gave up on it and went back to reading a book. Couldn’t get this out of my mind though…. so kept thinking about it… what is different this time than before…. first time I saved it, and then immediately uploaded into the Garmin… but why should that make a difference? Oh, the other thing I did was “clean up” all the long descriptive file names. . . . hmmm. . . . If every name is now just “Starbucks” and originally they were “Starbucks at the corner of 5th and 27th Street in Madison Wiscon….” what is the difference… okay now ALL the descriptions are exactly the same…. hmmm…. Back to Excel, import the .CSV file, delete all the descriptions, put in “Starbucks 000001” and then drag down the column changing each description to “Starbucks 00001”, “Starbucks 00002”, “Starbuck 00003” and so on….. now save it in Excel. Open it in Magellan POI editor, save it, exit and reopen the MGLN file again. Hot Dang… there they all are!


Magellan POI Software

The interface for the Magellan POI software is pretty simplistic. When you load up a file it shows all the locations… and if you have reversed the latitude and longitude it shows up real quick! What a DQ in the middle of the South Atlantic! Must be one they opened on an cruise ship going to Antartica.

The other thing I realized as I went through all of this, when I tried the GPS with the original downloaded points it did not find some that I thought for sure should be there… like right down the street from the house. Again I assumed the file would be correct, and there must be some reason they were not included, like it is inside of a store, not a stand alone building or it is to new to be included, and so on. What I now realize is that all the descriptive names that ended up being truncated leaving the exact same description were skipped from the file. Maybe it is thinking that location is already in the file so is attempting to be helpful by not saving duplicates….. so a lot of locations ended up with similar descriptions and therefore not included.

With this great success I looked up the next most important, or actually maybe even THE most important locations to find on a trip…. ALL the Dairy Queen’s in the USA! I now have a file loaded into the GPS so we can immediately locate a DQ for a quick sugar fix whenever we need it on the road! WOOT! Instant ice cream locations, all 5,332 of them!

Next project: Programming all the Parks, lodges and major attraction at Disney World in Orlando… the only “ready made” file I found only has the theme park locations in it. I want the Disney resorts, lodges and other things like International Village and the “Shops”, along with nearby attractions of interest… and the hotel we like there.

Until the final satellite burns up on reentry,

George

Software and Running = Part 3

Continuing review of the equipment I use to create, track and record my workout efforts.
Here is a review of SportTracks software.

While I really like the Runners Studio software for tracking all the workouts, races and planned races when I started it did not do quite everything I wanted, such as data import from Garmin, create maps of routes, etc. Even though many of those items are available now, I still put the data into another program, SportTracks. The approach taken with this software is a little different, it is open for the user community to create “plug-ins” much like the WordPress blog software allows. This allows the creativity of the entire user community to think up ways to enhance and improve the basic software. (Not that it is particularly lacking, just that 5,000 heads are better than one.)

The software with all its plugins (currently there is something like 42 different ones listed) makes for a lot of options! The downside to all this is, for me anyway, not as intuitive use as Runners Studio. Using a series of views, each one which can do different things requires some clicking around to get it to show what you desire it to. Then within the view there are options also. You have to pay attention to all the “triangles” which you use to open up the different options. I wrote in to the forums asking about editing an event after searching for some time, the answer, which was polite, but made me feel sort of dumb, just click on the triangle after the “Event” and make your choice. D’oh.

After months of use I still find the ability to download data from a GPS you wear on your wrist and create a map of the activity accurate to within feet of where you walk on the entire planet to be pretty amazing. ????? ?????? (maybe I am just easily impressed or amazed.)

Sport Tracks is really good, but have not found a good way to schedule future races in it. There are some plug in’s that will let you do it, but not the way I want it, and even if you get it, you have to dig down through several menus to find it. Conversely Runners Studio puts them right on the home page so you can see them quite easily. Actually there is not a good “home page” for Sport Tracks, maybe something that could be considered. ??????????? ??????? A simple overview of the major things tracked. Weekly mileage, shoe use, upcoming races, even maybe a way to check which things the user would like to see. Sort of how iGoogle page creation works.

You can check out what they have to say about Sport Tracks and download an evaluation version from https://www.zonefivesoftware.com/SportTracks/.

There are several other solutions, most of which are web based. These have the advantage of access from anywhere, or any computer, the down side of not being able to access from behind a firewall (like at work) or if the site decides to go to a paid version, or worse close the doors. ????? ??? ???? Your years of data could be gone. They may be nice and allow an export of all the data, but then again . . . or even if they do would it be in a format compatible with another program.

Until the final waypoint is created,
George

Next TCX Converter.