• Replies 12 replies
  • Subscribers 416 subscribers
  • Views 88 views
  • Users 0 members are here
Related

Zip Codes in Tessitura

Former Member
Former Member $organization

Good morning to you! J

One of my data specialists gave me a list of zip codes that do not show up in Tessitura. Who would we forward this to?

I did confirm these zip codes on http://zip4.usps.com/zip4/citytown_zip.jsp

72631        Eureka Springs, AK

95757       Elk Grove, CA

92867       Orange, CA

95377       Tracy, CA

59602      Helena, MT

30297      Forest Park, GA

89044      Henderson, NV

95811        Sacramento, CA 



[edited by: Bobbie Felser at 12:57 PM (GMT -6) on 30 Jun 2009]
Parents
  • $organization

    The table where you would add those is TR_CITYSTATE.  Due to the size of this table you cannot access it from the System Tables screen.  Updates to this table must be made from SQL Server.

     

    New zip codes must be manually added to the table; they are not automatically added as they are used in the application.  Existing entries may be edited if desired. The following columns in this table are required: zip5 (5 digit zip code), city, and state (postal abbreviation).

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com

     

Reply
  • $organization

    The table where you would add those is TR_CITYSTATE.  Due to the size of this table you cannot access it from the System Tables screen.  Updates to this table must be made from SQL Server.

     

    New zip codes must be manually added to the table; they are not automatically added as they are used in the application.  Existing entries may be edited if desired. The following columns in this table are required: zip5 (5 digit zip code), city, and state (postal abbreviation).

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com

     

Children
  • Former Member
    Former Member $organization in reply to Kevin Sheehan

    Thank you Kevin! Al doesn't let me play around in the SQL Server so I will email him the information and ask him to add them for me!

    I appreciate you help! Will you be in San Antonio?

  • Former Member
    Former Member $organization in reply to Kevin Sheehan

    Kevin,

    Is there any additional documentation on TR_CITYSTATE?  The Constituent_Records_Basic_Features document only mentions the three columns you mentioned (zip5, city and state).  Before I start mucking about in the table, I'd like to know what the other columns are used for (I can assume, but....)

    Thanks.

     -steve carlock

    Santa Barbara Center for the Performing Arts/The Granada

     

  • $organization in reply to Former Member

    Hi Steve,

     

    There is not.  But you could open a help ticket to ask any questions you may have.

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com

     

    From: Tessitura Customer Service Forum [mailto:forums-cust.serv@tessituranetwork.com] On Behalf Of Steve Carlock
    Sent: Thursday, October 01, 2009 7:31 PM
    To: Kevin Sheehan
    Subject: Re: [Tessitura Customer Service Forum] RE: Zip Codes in Tessitura

     

    Kevin,

    Is there any additional documentation on TR_CITYSTATE?  The Constituent_Records_Basic_Features document only mentions the three columns you mentioned (zip5, city and state).  Before I start mucking about in the table, I'd like to know what the other columns are used for (I can assume, but....)

    Thanks.

     -steve carlock

    Santa Barbara Center for the Performing Arts/The Granada

     

    From: Kevin Sheehan <bounce-kevinsheehan4372@tessituranetwork.com>
    Sent: 6/30/2009 12:57:23 PM

    The table where you would add those is TR_CITYSTATE.  Due to the size of this table you cannot access it from the System Tables screen.  Updates to this table must be made from SQL Server.

     

    New zip codes must be manually added to the table; they are not automatically added as they are used in the application.  Existing entries may be edited if desired. The following columns in this table are required: zip5 (5 digit zip code), city, and state (postal abbreviation).

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Customer Service Forum. You may reply to this message to post to the Customer Service 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!

    No virus found in this incoming message.
    Checked by AVG - www.avg.com
    Version: 8.5.409 / Virus Database: 270.14.1/2407 - Release Date: 10/01/09 06:34:00

  • $organization in reply to Kevin Sheehan

    Hi Kevin,

    I know I'm replying to a super old post, but I'm having the same problem and it seems the table is not called TR_Citystate anymore.  I'm on version 10.  Can you tell me what it is called now?

    Thanks,

    Kanani

  • $organization in reply to Kanani Reichlin

    Hi Kanani,

    The table name has not changed, but it is not accessible from within the Tessitura application (i.e. the System Tables screen).  You will need to have someone with database access update the table on the back end using SQL Server Management Studio.

    Kevin