• Replies 5 replies
  • Subscribers 337 subscribers
  • Views 42 views
  • Users 0 members are here
Related

last two characters in Postal Code field dropped off

Former Member
Former Member $organization

Hello everyone,

Canadian postal codes are formatted LetterNumberLetter(space)NumberLetterNumber (ex. N6C 1R2).  When we create a new constituent, the Postal Code screen on this newly created general tab drops the last two characters (ex. It appears as N6C 1).  If the Postal Code is entered on the search screen with no space N6C1R2 it then formats correctly to N6C 1R2.

Has this happened with any other Canadian organizations?  Also I have attached a snapshot of my entries in the relevant fields under TR_COUNTRY.  Any errors there?

Thanks,

Duane

Parents
  • $organization

    We are not a Canadian organization, but are located nearby (Minnesota) and do get a steady trickle of new Canadian constituents. We experience something similar to your issue: every Canadian constituent that adds their address info via the Web has their Postal Code initially stored in t_address with an extra space, e.g. "N6C 1R2". So, when viewed in the client, it looks like "N6C 1R". (Please see attached graphic)

    These are easily fixed, but it would be nice if it didn't happen to begin with.

  • Former Member
    Former Member $organization in reply to Chris Jensen

    Hi Chris,

    Your screenshot is exactly how the postal code appears on a new record, both when entered by our staff and in online ticketing orders.  Our staff enter the postal code without the space and it then formats correctly, and our Box Office Manager corrects issues from online accounts each morning.

    I have attempted various format entries in TR_COUNTRY with no success.  I think I'm going to open a Help Desk ticket.

    Thanks Chris and Jeri for your testing and feedback on this.

    Duane

  • Former Member
    Former Member $organization in reply to Former Member
    Hi,
    We were also having issues with addresses created on the web so opened a help desk ticket.  FYI on the final response after testing and working with support:
     
    The root of it always is that there is a mask in place on your website that is causing the masked value to be returned to the method that is being called for the address data. What you need is a mask in place for input only so that your customers enter the correct data. However, that mask must return unformatted data to the API call. For example, you cannot return a Canadian postal code value of K1A 0B1 to the database; you must return a postal code value of K1A0B1 (no space).

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Duane Woods
    Sent: Thursday, March 04, 2010 12:47 PM
    To: Jeri Henderson
    Subject: Re: [Tessitura Technical Forum] last two characters in Postal Code field dropped off

    Hi Chris,

    Your screenshot is exactly how the postal code appears on a new record, both when entered by our staff and in online ticketing orders.  Our staff enter the postal code without the space and it then formats correctly, and our Box Office Manager corrects issues from online accounts each morning.

    I have attempted various format entries in TR_COUNTRY with no success.  I think I'm going to open a Help Desk ticket.

    Thanks Chris and Jeri for your testing and feedback on this.

    Duane

    From: Chris Jensen <bounce-chrisjensen8841@tessituranetwork.com>
    Sent: 3/4/2010 10:12:35 AM

    We are not a Canadian organization, but are located nearby (Minnesota) and do get a steady trickle of new Canadian constituents. We experience something similar to your issue: every Canadian constituent that adds their address info via the Web has their Postal Code initially stored in t_address with an extra space, e.g. "N6C 1R2". So, when viewed in the client, it looks like "N6C 1R". (Please see attached graphic)

    These are easily fixed, but it would be nice if it didn't happen to begin with.




    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!
  • Former Member
    Former Member $organization in reply to Former Member

    Thanks Jeri.  Good to know.

    Duane

     

Reply Children
No Data