Hi, first time caller. I was just wondering, I have a few large lists of lists of addresses (one is my contacts list, another is one I got from the internet, etc.) and I was hoping there was a simple way to geocode them (I think that's the right term) and set them up into a format I can use without having to add each individual one by hand.
If I *have* to do it all by hand, I can, it's just a pain. Surely someone's come up with something that can do a batch job by now, right?
Does your list includes the coordinates? If not, you'll have to get them from Google Map or other map services. That's very time consuming. If there is a batch job out there to do this, I'd be interested to know as well.
See http://www.gpsvisualizer.com/geocoding.html .
Also Extra Poi Editor http://turboccc.wikispaces.com/Extra_POI_Editor
Thank you for the reminder. I had forgotten the GPS Visualizer site (although I have it as one of my too many a bookmarks!!!)
A lot of how easily accomplished depends on how familiar you are with other tools. Perhaps the easiest method (although there are many along with their proponents) is using Excel or another spreadsheet program and Extra_POI_Editor or EPE. EPE is a free download and the tips on setting it up and getting it running are under the blue LEARN tab on the top right.
Build your list in Excel (the columns make it easy to get the data in the right places) leaving columns A & B empty. Put a name for the location (like the customer's name) and then the street address, city, and state in columns C & D. You can add zip codes and phone numbers to the address just be certain you have a comma between the different elements. Save the file and then load EPE. Tell EPE to read the file and it will complain about missing data. Just tell it to IGNORE the missing data for all records. Press F5, and EPE will geocode the locations letting you know if it couldn't locate an address. Once it has geocoded the locations, select SAVE AS and save your file as a Garmin CSV. This file is what POI Loader needs to read to create the list for your GPS.
When I copy from a website and paste to Excel, how do I prevent Excel from posting the column 4 data in different rows?
It's the nature of the beast. You need to use formulas and functions to reformat the data into the columns you need. The functions used will change depending on the website data so you can't necessarily say do this or that.
While some of the copying is a simple copy cell X to cell Y, depending on what you are building, you will need to use what are referred to as string manipulation commands or functions where you extract information from some and join others together. Perhaps the simplest string command to use is the concatenate used to join two cells into one. That's a simple =X&" "&Y where the & says join this to that and the " " says put a space between them. Two other string commands I use frequently are LEFT(X,n) and RIGHT(X,n) where X is the cell and n is the number of characters you want counting either from the left or the right. One of the more difficult string commands to master is when you want something out of the middle of a string. You do that with a MID command MID(X,n,y) where X is the cell, n is the starting point and y is the number of characters to extract.
There are a lot of other functions used to manipulate data, these are just a few of the ones I happen to use in building my GPX files.
@ Dave, are you referring to Favorites? or Customized POI's?
terms | privacy | contactCopyright © 2006-2020