Here's one low-tech way to create the zip files from your own data. It
needs to be re-run every once in a while to keep it up-to-date. Posted
by another ebase user some time ago:
Here's a trick posted by Tandra Ericson and elaborated on by Trey Beck.
Beware that if you have a zip code that applies to more than one town
(as is the case in some New England states), it will auto enter
whichever came out in the sort first. You'll still have to manually fix
some towns:
>1) Find all in the Names file
This, obviously, finds all records. If you have records in your database
that may not have zip codes, you might omit those that are blank. The
Filemaker and ebase manuals have good sections on finds that are worth
committing to memory.
>2) sort by zipcode
Mode -> Sort -> Select Zip\Postal Code and "Move"
Choose "Sort"
>3) export zipcode, city st, county area code
File -> Import/Export -> Export Records
Enter the name of the file to be saved to a tab-delimited file.
Something
like "zipxfer".
Now you will be asked which fields should be exported. You might choose
the
following:
Zip\Postal Code
Home Phone AC
City
State\Province
Select "Summarize by" and highlight Zip\Postal Code. This ensures that
if
you have multiple records corresponding to "80202 Denver Colorado", for
example, that only one will be exported.
>5) Then import the file into the zip_100 file
Minimize the names file and maximize the zip_.10x file.
Choose File -> Import/Export -> Import Records
Browse to find your "zipxfer.tab" file and select it.
In the resulting dialog box, match the fields that you're importing with
their counterparts in the zip_.10x file. To do this, clear arrows, align
fields as appropriate, then reset the arrows (no arrows, no import). Use
the
scan buttons to make sure that the correct values are where they should
be.
Hit "Import".
And there you go. Return to the names_.10x file and change your tab
order
to
hit the zip code field before the city or state. For a new record, on
entering a zip code that exists in the new zip_.10x file, your
city/state/ac
info should be completed for you.
Ciao,
Trey Beck
Sally Zaino wrote:
>
> Where does one get the zip code files for ebase to use? I've always wished
> this would work.
>
> Thanks.
>
> Sally
>
> >Date: Mon, 09 Oct 2000 23:20:02 -0400
> >From: Colin Cooler <[EMAIL PROTECTED]>
> >To: ebase-Support <[EMAIL PROTECTED]>
> >X-Processed-By: HSKT 1.0 by Joshua Baer
> >Subject: Re: [SUPPORT] Tabs in data entry screen
> >
> >er uh.....I meant to say it will paste the corresponding city and state in
> >those fields.
> >
> >Colin
> >Thicker, Not Slicker
> >
> >
> >
> > > ....then ebase will lookup the zipcode in the zipcode file (duh)
> > > and paste it for you into the city and state fields.
> >
> >
> > >Colin
> > >Smarter, Not Harder ;)
>
> Sally Zaino
> The Manada Conservancy
> http://www.manada.org
>
> "The first rule of intelligent tinkering is to keep all the pieces." --Aldo
> Leopold
--
Carl Paulsen
New Hampshire Rivers Council
54 Portsmouth Street
Concord, NH 03301
603-228-6472
603-228-0423 Fax
[EMAIL PROTECTED]
