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.

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, 200619 yr by Guest

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

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...