At the request of someone in Marketing, I created a table to certain specifications so that it would be "in Tessitura". Did that, no big deal.
He later called and said "I don't see it", and after much back and forth I finally understood that he basically meant "Can you make it show up in Tessitura's System Tables module so I can insert data into it readily?" to which I replied, "Sure", assuming I can figure out what makes a given table appear in said module.
So, I ask you fine Tessiturians, is such a thing possible? Do you simply make a corresponding entry in some table to make tables appear in System Tables? Or is it not possible? I suspect it's not possible, but that's why I'm here...
BONUS TRIVIA DESSERT: The buttons on a man's cuffs were originally intended to discourage manservants from wiping their noses on the sleeves of their uniforms
Hi Matt,
There’s a SP called UP_POPULATE_REFTABLES_TABLE that populates system table. It will look for any custom table starting with the LTR prefix.
Like the trivia!
David
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Gonzales Sent: 22 July 2009 22:56 To: David Taylor Subject: [Tessitura Technical Forum] System Tables
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!
Just stumbled on this for a similar reason (Education rather than Marketing). I'm assuming in the intervening 9 years that T_REFERENCE_TABLES became TR_REFERENCE_TABLE and TR_REFERENCE_COLUMN
Yep. They are mostly pre-populated by UP_POPULATE_REFTABLES_TABLE after you create the LTR table.
Important update: was just copy/pasting blindly (hadn't had my morning tea): the utility has changed to: UP_POPULATE_REFERENCE_METADATA.
www.tessituranetwork.com/.../Local Tables.htm
Hi Heath,
We're still on 12.5.1 and the procedure is UP_POPULATE_REFERENCE_METADATA . Be warned, you can add your table name as a parameter:
Execute UP_POPULATE_REFERENCE_METADATA ltr_nida_fund_extended
This stops (possibly) unwanted tables (like the mail2 tables) being automatically included as the SP (basically) recreates the System Tables area in its entirety if you don't specify a table as a parameter.
Also, you might want to update TR_REFERENCE_COLUMN so that the columns appear as you'd like them to.
Martin
Legendary - Thanks Martin. Great advice
It's for a large scale Education Tracker which I hope to migrate in from Excel. It'll mean writing the SP to update the data from orders and constituents and lets the Edu team fill in the bits they need to acquittals etc. I'm thinking I'll spend a lot of time in TR_REFERENCE_COLUMN.
Heath,
I'm not sure what you mean when you refer to the "Education Tracker" - and oh those Excel spreadsheets!
We're using Plans (very successfully) - with some custom fields - so that our Corporate team can track the progress of their discussions with organisations regarding the delivery of in-house programs. This got rid of the dreaded "Project Pipeline" spreadsheet.
Happy to share more detail if you'd like to email me directly martin.keen@nida.edu.au
My Ed department has a huge line by line Activity Tracker that they use for Workshop bookings including acquittal info, contacts and the like. One of my next big projects is to get workshop bookings into Tess and one of their requests is to be able to pull the table data out of Tessitura as a report. In order to pull that info out in some coherent way I'm thinking of creating a System Table (local table) so they can add the additional data that they want in a similar manner to the spreadsheet they're familiar with. I might be able to just co-opt Custom Order Fields depending on how the project rolls out. but this could also be an option. To be honest I've been keen on this since Hannah Schneiders presentation at our ANZTRUC session.