Penny Arcade Forums› Help / Advice Forum
The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.

zip+4 tool?

DiscoZombieDiscoZombie Registered User regular
edited October 2009 in Help / Advice Forum
So my company's switching to a new database system that requires accounts to use zip + 4 zip codes... so we need some way of taking the zips on all our current accounts and turning them into zip + 4... anyone know of a tool or utility (free or $$$) that you can pass a bunch of street addresses through and it spits out the zip + 4? Such a thing may not even exist, not sure...

DiscoZombie on

Posts

  • JoeUserJoeUser Forum Santa Registered User regular
    edited October 2009
    DiscoZombie wrote: »
    So my company's switching to a new database system that requires accounts to use zip + 4 zip codes... so we need some way of taking the zips on all our current accounts and turning them into zip + 4... anyone know of a tool or utility (free or $$$) that you can pass a bunch of street addresses through and it spits out the zip + 4? Such a thing may not even exist, not sure...

    Check here. The USPS has APIs to do the lookups you want.

    JoeUser on
  • DiscoZombieDiscoZombie Registered User regular
    edited October 2009
    Hm, we don't really need a web tool - just something to pass a database / list of addresses through and have it spit out the zip+4... but maybe I *could* build something like that myself using one of these APIs, even though they're designed for web interfaces... I'll take a look, thanks :D

    DiscoZombie on
  • JoeUserJoeUser Forum Santa Registered User regular
    edited October 2009
    DiscoZombie wrote: »
    Hm, we don't really need a web tool - just something to pass a database / list of addresses through and have it spit out the zip+4... but maybe I *could* build something like that myself using one of these APIs, even though they're designed for web interfaces... I'll take a look, thanks :D

    Right, I think it's really just a web service that you can call from a simple application you build.

    JoeUser on
  • PracticalProblemSolverPracticalProblemSolver Registered User regular
    edited October 2009
    what kind of database is it?

    PracticalProblemSolver on
  • DiscoZombieDiscoZombie Registered User regular
    edited October 2009
    PracticalProblemSolver wrote: »
    what kind of database is it?

    well, it's Oracle, but I can also download it to Access as needed, which is where I plan on making the zip changes, since we don't have direct write access to Oracle.

    DiscoZombie on
Sign In or Register to comment.
Penny Arcade Forums› Help / Advice Forum