Home » Garmin talk

Best way make a nationwide poi from a website?

 
Sun, 04/27/2008 - 12:32am

There is a store that I want to make a POI of but I would have to pull each address seperately from the website which would be very time consuming. Is there a way to find them a import the data to make a POI or is just one of those things that you have to put in the time to make?

‹ Project Bobcat 2.0.0.4 Beta need a Cabela's icon ›
Sun, 04/27/2008 - 2:12am

depends on the store chain

depends on the store chain there is a commercial poi website that has most restaurant chains etc might be worth it to buy if not available here or at another site.

Sun, 04/27/2008 - 11:00pm

Try Excel

I use an Excel web query. If there are not too many items, I simply copy and paste each address. If not, I take the time to write Excel macro code to parse the data automatically. After downloading the addresses I usually have to compare the info to the store's official web site.

Sun, 04/27/2008 - 11:33pm

EXCEL

ajf1958 wrote:

I use an Excel web query. If there are not too many items, I simply copy and paste each address. If not, I take the time to write Excel macro code to parse the data automatically. After downloading the addresses I usually have to compare the info to the store's official web site.

would it be possibe to get a copy of that templet!!

thanks

--
Everyday is a GREAT day :)
Mon, 04/28/2008 - 2:18am

Way over my head!!!!

Way over my head!!!!

Mon, 04/28/2008 - 6:57am

I would like a copy of the

I would like a copy of the excel template as well...I'm still looking for a 24hr fitness for the whole country poi

Sat, 05/10/2008 - 9:50pm

Excel

I would be glad to send you the code. Realize that you would have to modify it to look for "key" phrases that identify the start of each store or location.
Are you familiar with Excel VBA? If not, let me know your particulars (which web search engine, what store, etc) and I could write something for you.

(Sorry it took so long to respond to your post.)

Sat, 05/10/2008 - 9:51pm

Excel

I would be glad to send you the code. Realize that you would have to modify it to look for "key" phrases that identify the start of each store or location.
Are you familiar with Excel VBA? If not, let me know your particulars (which web search engine, what store, etc) and I could write something for you.

(Sorry it took so long to respond to your post.)

Also, my queries work best for a known store name. A generic search for all "24hr fitness" locations would be pretty hard to code.