• 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

    Hi Kevin,

    We just updated the table in SQL Server Management Studio and it hasn’t updated in Tessitura yet.  Is there something that needs to be run for it to update, or does it just take time?  Or should it have been instant and we just didn’t do it correctly?  Here’s the query that we used to update the table:

    INSERT INTO dbo.TR_CITYSTATE (zip5, city, state, usps_code) VALUES (‘98311’, ‘Bremerton’,’WA’,’Bremerton’)

     

    Thanks for your help!

    Kanani

     

    Kanani Knudson| Sales and Database Coordinator | Ticket Office: (206) 441-3322
    Seattle Children's Theatre |    www.sct.org| 201 Thomas St. Seattle WA, 98109

     

    From: Tessitura Customer Service Forum [mailto:forums-cust.serv@tessituranetwork.com] On Behalf Of Kevin Sheehan
    Sent: Wednesday, November 14, 2012 11:30 AM
    To: Kanani Knudson
    Subject: RE: [Tessitura Customer Service Forum] Zip Codes in Tessitura

     

    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

    From: Kanani Knudson <bounce-kananiknudson2364@tessituranetwork.com>
    Sent: 11/14/2012 12:53:10 PM

    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




    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!

  • $organization in reply to Kanani Reichlin

    Unknown said:
    We just updated the table in SQL Server Management Studio and it hasn’t updated in Tessitura yet.  Is there something that needs to be run for it to update, or does it just take time? 

    We truncate and reload TR_CITYSTATE monthly, and in my experience updates do not take time. New Zips should work immediately. I think you may need to populate more columns than that, though.

    I'm not sure what you're missing that the client wants, but when we do a reload, we populate all of the columns below:

    (zip5, city, state, country, area_code, usps_code, time_zone, geo_area, inactive, default_ind)

Reply
  • $organization in reply to Kanani Reichlin

    Unknown said:
    We just updated the table in SQL Server Management Studio and it hasn’t updated in Tessitura yet.  Is there something that needs to be run for it to update, or does it just take time? 

    We truncate and reload TR_CITYSTATE monthly, and in my experience updates do not take time. New Zips should work immediately. I think you may need to populate more columns than that, though.

    I'm not sure what you're missing that the client wants, but when we do a reload, we populate all of the columns below:

    (zip5, city, state, country, area_code, usps_code, time_zone, geo_area, inactive, default_ind)

Children
No Data