Is there a way to make ebase automatically insert the city and state if I
enter the zip code? I heard vauge reference to this ability in the user
manual and it is an appealing feature if it is possible. does anyone know?
Ebase is set up this way as delivered. You will note that as you
tab through the data entry screen, it jumps to zip, then to city,
state, etc. When you enter a zip, ebase looks up the city, state,
county, and area code from the zipcode file.
What's probably missing is data in the zip_.103 file. Ebase is
delivered with limited data in the zip file. You can obtain zip code
information from commercial sources, or use this trick posted by Trey
Beck a while back to collect the zip code information from your
existing names file.
--------------
> >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,
>
> 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,
--
--
Dave Shaw H4 Consulting
tel: 206-954-7526 fax: 206-625-1338
------------------ --
Dave Shaw H4 Consulting
tel: 206-954-7526 fax: 206-625-1338
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
