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
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
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?
Absolutely. I hope to see you there!
I am registered, booked and excited!
I love the Tessitura Conferences! Everything is always so organized and the people are absolutely wonderful!
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
Hi Steve,
There is not. But you could open a help ticket to ask any questions you may have.
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
From: Kevin Sheehan <bounce-kevinsheehan4372@tessituranetwork.com> Sent: 6/30/2009 12:57:23 PM
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
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
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
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 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
From: Kanani Knudson <bounce-kananiknudson2364@tessituranetwork.com> Sent: 11/14/2012 12:53:10 PM
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)
I think you may be missing the country in you insert. For us we have zip5, city, state, country, uspscode populated. We have some geo_area, but most of it is null. You can get the country id (int) from TR_Country. Time_zone is null for us. But the other fields all have default constraints that populates them.
If all the advice from the others doesn’t help, I suggest opening a help ticket. I also want to clarify, just in case, that making additions to the table will not affect existing addresses. The new entries will only be used when adding a new address.
Senior Technical Writer & Consultant
+1 888 643 5778 x 329