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
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