Carl,
I was going to give you a call for help. I kept looking into what was implied; got
brave and jumped in - after making a backup. Jack's solution worked and in working.
No more S St's. I was surprised to find 5 label layouts. I changed all five, because
it seemed to me that all five somehow supported labels.
Thanks for your offer. We may need help yet, but for the moment things are looking
good.
John
At 10:12 AM 8/6/2001 -0400, you wrote:
>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
>---------------------------------------------------------------------
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
---------------------------------------------------------------------
