Jump to content

Automated Zip Code Retrival


tbnlp
 Share

This topic is 5650 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5650 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.