• Replies 4 replies
  • Subscribers 338 subscribers
  • Views 88 views
  • Users 0 members are here
Related

Address Correction procedure

Levi Sauerbrei
$organization

It is apparently my week for goofy questions.

A user enters "State Farm Insurance" into the Opt. Address field (street2 in t_address) and after the record is saved, it is auto-corrected to "State FaRoom Insurance".

I know there is a stored procedure somewhere that controls the specific corrections and is triggered anytime there are changes made on the constituent's record. About a year a go I had to modify it so that "Ste." was changed to "Suite" instead of "Streete".  But the intervening months have erased the name of the procedure from my memory. Searching for Address Correction on the site doesn't give me anything.

Does anyone know where the procedure is located?

  • $organization

    If you are using Brian Wilbur Grundstrom's report it is a function, LF_TITLECASE.
    I Believe that is where you update it.

  • $organization in reply to Ryan Rowell

    Also if you need more information it is solution 99 in reference materials on TASK online.

  • $organization in reply to Ryan Rowell

    Thanks Ryan! That was it exactly. 

     

    Ok, no more odd questions this week, I promise.  I'll even try to contribute something useful to some other threads.

    So glad I have this forum to bounce things off of.  I'd drive myself crazy otherwise.

  • Former Member
    Former Member $organization

    Lf_titlecase

     

     -steve carlock

    Information Technology Manager

    The Granada

    jsc@granadasb.org

    (805) 879-3681x111 (office)

    (805) 899-3002 (fax)

    (562) 239-7075 (cell)

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Tuesday, November 03, 2009 12:31 PM
    To: Steve Carlock
    Subject: [Tessitura Technical Forum] Address Correction procedure

     

    It is apparently my week for goofy questions.

    A user enters "State Farm Insurance" into the Opt. Address field (street2 in t_address) and after the record is saved, it is auto-corrected to "State FaRoom Insurance".

    I know there is a stored procedure somewhere that controls the specific corrections and is triggered anytime there are changes made on the constituent's record. About a year a go I had to modify it so that "Ste." was changed to "Suite" instead of "Streete".  But the intervening months have erased the name of the procedure from my memory. Searching for Address Correction on the site doesn't give me anything.

    Does anyone know where the procedure is located?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!