John,
I'm just back from a conference and short vacation and saw this
exchange. Jack's solution really isn't that hard to implement, so make
a backup and give it a try. If you need help, feel free to call and I
can walk you through it. It'd be quick and, of course, I wouldn't
charge for a little assistance like that... especially since Jack was
the one to offer the solution.
To implement Jack's second solution (which is better, I think, than
Gary's), you'll need to find the ADDRESS LINE/LABEL field (you don't
have to mess with any of the layouts to do this solution). You'd need
to go into File->Define->Fields, select the ADDRESS LINE/LABEL field,
then enter the changes as suggested. Also, create the field Jack
mentioned, then place it on the Data Entry 1 screen in layout mode.
Jack's first solution (which is less than optimal b/c of the formatting
issues such as stripping out periods, etc.), you'd need to replace the
ADDRESS LINE/LABEL field on each of the label layouts and replace it
with the ADDRESS LINE/LETTER field. You need to do this b/c ebase uses
several different label layouts to deal with such issues as householding
and "loading" the label with lots of membership data (such as expiration
date).
Carl
John Andrews wrote:
>
> Jack,
> thanks for the news that there's a way to overcome the abbreviation substitution.
>And thanks for a software solution. As an ebase/FileMaker novice, I'm not sure I'm
>up for this patch. With a good backup, I might see how far I can get. At the very
>least, I'll stop looking in the manuals for a way out.
> Thanks,
> John Andrews
>
> At 08:48 AM 7/26/2001 -0600, you wrote:
> >The problem lies in the parsing fields that build the "ADDRESS\USPS FORMAT" field.
>This field, in turn, is used in the "ADDRESS LINE\LABEL" field, which appears on
>mailing labels. There is another field, named "ADDRESS LINE\LETTER", which is used
>on envelopes and appears on your HOME screen. The "ADDRESS LINE\LETTER" field uses
>whatever you've typed into the "ADDRESS\SUPPLEMENTARY" and "ADDRESS\DELIVERY" fields
>without doing any manipulations.
> >
> >So, the simplest fix is to change the label layouts so that they reference the
>"ADDRESS LINE\LETTER" field instead of the "ADDRESS LINE\LABEL" field.
> >
> >Another solution is to create a text field named "UseUSPS?" that would contain
>either an "N" or nothing at all. Put that field onto the data entry screen. Only
>mark "N" in those records that you know will be problematic. You'd then change the
>calculation for the field named "ADDRESS LINE\LABEL".
> >
> >It currently reads:
> >
> > If(IsEmpty(ADDRESS\SUPPLEMENTARY),"",ADDRESS\SUPPLEMENTARY & "�") &
>ADDRESS\USPS FORMAT
> >
> >Change it to:
> > If (UseUSPS? = "N",
> > ADDRESS LINE\LETTER,
> > If(IsEmpty(ADDRESS\SUPPLEMENTARY),"",ADDRESS\SUPPLEMENTARY & "�") &
>ADDRESS\USPS FORMAT)
> >
> >The benefit of this second solution is that you get the use of ebase's address
>standardization where you want it, but you can override it where you know it breaks.
> >
> >>I'm a new user with lots of progress, but I'm stuck on an automated abbreviation
>problem.
> >>
> >>When the words East or West appear in an address, ebase automatically changes them
>to E and W.
> >>
> >>One of our members lives on West Street. The ebase label reads W ST. I tried
>quotes, but the quotes are printed.
> >>
> >>Has anyone overcome this quirk?
> >
> >---------------------------------------------------------------------
> >Jack Noll - ebase consultant and wildlife advocate
> >
> >Check out a *great* program at www.beardogs.org
> >---------------------------------------------------------------------
> >
> >
> >------------------ 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
> >---------------------------------------------------------------------
> >
> >
>
> John Andrews
> P.O. Box 852
> Saco, Maine 04072
>
> www.EasternTrail.Org
> www.SacoBayTrails.Org
> 207-282-1979
>
> ------------------
> 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
> ---------------------------------------------------------------------
--
Carl Paulsen
New Hampshire Rivers Council
54 Portsmouth Street
Concord, NH 03301
603-228-6472
603-228-0423 Fax
[EMAIL PROTECTED]
------------------
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
---------------------------------------------------------------------
