Ok, maybe somebody can help me here... I'll tell you what I'd like to do, then maybe you can tell me the easiest way to pull it off.
I sell advertising for an auto magazine.
I would like to take search results from yahoo or google, for example "auto uphostery" and create a gpx or csv file with all of the poi's so that I can visit some of the businesses. Is there a way to do this without having to manually enter in each result one by one?
Try a search on "batch convert" and you should find plenty of suggestions.
Take a look at POI Harvester.
Here are the steps I use to create a map and save the files.
1. Go to Google maps http://maps.google.com/maps and click on sign in.Now create an account.
2.Once signed in go to create new map on left.Fill in title and description.Under privacy settings mark public or unlisted.Then click done.
3.It will now show under my maps make sure you have check mark in title.The map will always be there unless you delete it.
4.Now go to top and click on either search the map(single address) or find business(listing by name).I will use business search for my example.
5.Once you make the search you will see results on left
6.Click one marker on left you want .Popup will come up click save to my map.Next popup which map you want to save it to click on save.Next popup should show info click on save.
7.Now go back to search results on left and click on search again to get the listings again.You will have to repeat this each time you complete one.
8.Once all your locations are entered go to link to this page on right near top and click on it.The top highlighted paste link in email right click mouse and save it.
9.Now go to site http://www.takitwithme.com/ and paste in the url you copied where it says paste in your google my maps url.Now click load my map.
10.You will have a choice to upload to garmin gps or download gpx.Click download gpx and remember where you saved it at on your computer.Now if you want to convert to a csv file go to step 11.If not put the gpx file in the correct folder and run the Garmin poi loader.
11.Go to http://www.gpsvisualizer.com/convert to convert the file to csv file.Under browse upload the gpx file you saved and under Plain text delimiter click on comma.Now click on convert top right.Once the data comes up right click and copy all the columns.
12.Now pull up your excel sheet and paste the info to it.You will have to switch longitude and latitude and delete column a.Now clean up what you don't need.
13.Now go to file on excel sheet at top and click save as then save as type find csv(comma delimited) and click save.You now have csv file.
Tried POI Harvester and the CSV files were considered invalid by my Nuvi 200
The thread referenced by MM above says that POI Harvester provides latitude and longitude; if it does so in that order, you will have to reverse the columns. I've never used it, so I'm not sure.
Yep. Just open it in Excel and swap the columns.
Holy Crap! That worked! Thanks a million! Now... how do I get the phone number to show up on the details?
Actually... only the address is coming out... not the city state zip or phone number. Is there a way to merge all of the info from those colums together?
I believe GeePeeEx Editor will do what you want. Check out the trial version and see.
You also can use the concatenate function in Excel to merge data from different columns.
It took a little working, but I was able to come up with usable csv files to use on the road during my sales trips. Thanks a million to everyone. Now let's see if I can close some deals!
terms | privacy | contactCopyright © 2006 - 2015