Automated Zip Code Retrival

[tbnlp]

Does anyone know how I could set up to retrive zips from a website? I have addresses in a database, but no zip codes, I would like to be able to automate going to the usps.com site, where you can enter an address and get the zip code. I have thousands that need done and doing them by hand will take forever. Is there a way to set this up?

I have seen where you can do a similar thing with maps, entering data and it will retrive the map from a web site.

Any help would be appreciated.

[Lee Smith]

Hi tbnlp, and welcome to the Forum.

Wouldn't it be easier to use a related file with the city and zips. There are several example files here on the Forum (do a search for Zip Code or Zipcode and City and you will find about 220 hits), Recently, someone also posted a current list of Zip Codes. If you do a search for zipcode, you will see a thread about Map Quest also.

HTH

Lee

Edited June 16, 2006 by Guest

[ralph.nusser]

Yahoo and Google have an xml service where you get not only the zip code but longitude and latitude as well:

"http://api.local.yahoo.com/MapsService/V1/geocode?appid=YahooDemo&street=356+Salem+Tpke&city=Bozrah&state=CT"

Answer of yahoo:

<?xml version="1.0" ?>

-

-

41.506255

-72.136271

356 SALEM TPKE

BOZRAH

CT

06334-1518

US

-

An example how you can put the data into FileMaker [you need the Troi URL-Plugin: URL-Plugin ]

and parse it I uploaded here:

Thread of German FileMaker Magazine

With Google:

"http://maps.google.com/maps/geo?q=356+Salem+Tpke,Bozrah+CT&output=xml&key=YOUR_API_KEY_HERE"

Answer of Google:

<?xml version="1.0" encoding="UTF-8" ?>

-

-

356 Salem Tpke,Bozrah CT

-

200

geocode

-

356 Salem Tpke, CT 06334, USA

-

-

US

-

CT

-

New London

-

356 Salem Tpke

-

06334

-

-72.139170,41.506223,0

You see you can get the zip codes as well.

Happy FileMaking Ralph Nusser

[Genx]

THEY'RE ALWAYS LIMITED TO AMERICA!!! I get so annoyed about that some times, having access to proper google maps from aus would make my life so much easier.

Oh well...