Hi folks!
We are looking to try and 'integrate' specific CMS editable areas within the custom tab.
After asking around, I found that it is possible to have our CMS do this, but what I'm trying to figure out now is the limitations from Tessitura on what can be passed in the URL to the CMS.
According to some of the documentation I'm reading about the CMS, I can only pass:* current constituent id* current tessitura usergroup* current tessitura userid* company name from t_defaults* current sql login* a report server url (not sure what this is for)* ssrs folder path
Since we are looking to try to implement this in the custom tab for performances only (at this time), I see the need to also be able to pass at the least:* the performance code or id* the production id* production season(I mention production because of the way we are organizing our programs in tessitura, production/production season/performance all have a one-to-one relation in our setup. )
Is anyone aware if I can pass any of this information along as well as part of the querystring in the URL?
The <key> token will get you the appropriate value, depending on where in the system you are. So, for example a custom screen in performance setup will substitute perf_no, whereas a custom tab in production season setup will substitute prod_season_no. So if your url looks like this: http://www.mysite.org/season/performance.aspx?id=8863, then put this in TR_CUSTOM_TAB: http://www.mysite.org/season/performance.aspx?id=<key>
Thanks for getting back to me so quick Chuck. Great to hear that I can pass the id from the performance custom tab, but is it solely limited to the performance id? Is there any way to get the production id associated to the performance pushed to the URL?
Being that we are setting up our production and performances on a one-to-one relationship, each performance would only ever have one production.
I believe the <<key>> field of the query string changes based on what module the custom screen is in.
Jon / Chuck:
I did try this out in the custom tab using the following url as a sample:
http://www.92y.org/default.asp?id=<<key>>&u=<<user>>
When I tried this with only a single set of <> like <key>, that didn't work and Tessitura just ignored it and passed it over as part of the url. Only when I added the second pair of <> did it actually do a replacement.
This is great except for 2 things:
1) it still doesn't solve my other issue.. can I get production id to also be placed into the URL when I'm on the performance setup screen (where I also might want the performance id to be passed).
2) I actually got a nasty code error bug when I exited Tessitura when I had the url above loaded in the custom tabs. The error asked me to debug, which I did to take a look and it looked like there were some javascript functions that didn't quite like what I was doing.
After doing a little testing, I found that the only time this error triggers is after I visit a performance and click on the custom tab which brings up the browser. At that point, if I try to either leave the performance OR close Tessitura, I get the error.
However if I never go to the custom tab area on the performance setup, I never get the error.
It seems to me like perhaps the script is unable to process the << >> symbols. Also, I got the prompt 8 times in a row before it would finally let me exit Tessitura.
Something for your troubleshooting staff to look into perhaps.
If you have to go to the database for other data for you custom tab page, you can always get the production number there:
select prod_no = b.prod_nofrom t_perf a JOIN t_prod_season b ON a.prod_season_no = b.prod_season_nowhere a.perf_no = <your perf_no>
Thanks Chuck. It was pointed out to me a bit before your post that there is a SP that handles the pre-processing of the URL and that I might be able to use that to gather additional info for my querystring.
I guess I was wondering if there was something already pre-built but that works just as well.
Now, I still have this other problem from my last post re: the error messages that I'm getting when trying to utilize the << >> keywords that tessitura uses as the replacement keywords. Is this a known issue? I'm posting here a sample of what I actually have set up in t_custom_tab table.
Nevermind, I spoke with Fran Hoylman and she finally cleared up the issue with using this feature. Based on that info, I think the documentation for the custom tab browser feature needs to be re-written perhaps to be much clearer.
It turns out (at least based on her example) that I can't enter in the full URL with querystring containing replacement keywords and that I need to setup a partial identifier of some fashion like .. www.92y=<<key>> as an example and that I should utilize the lp_preprocess_url sp in order to then take that further to generate the final URL that I need to pass on to the inline browser.