My museum has been trying to figure out how to track volunteer hours in Tessitura. Long story short, another institution sent me the zip file for the custom screen that Tessitura built for them to input volunteer hours. The two SQL files (that now appear as PDF after downloading) within the zip drive need to be loaded into SSMS and then execute (according to the instruction in the README doc). However, I do not know how to do that. I am brand new to the SSMS world (just had Tessitura give me permission for it today).
Can someone show me step-by-step of how to do that, or give me the link to where instructions might be in the Help Desk or somewhere? My supervisors want this done asap. Thanks and much appreciated! :)
Step 1) start in Test.
Step 2) start in Test.
Steps 3)
The SQL files should be text files (and openable in Notepad...you're on Windows?). You can open files on your local machine, you just have to hunt around for them a bit when you try to open a file is SSMS, as it will start you out in directories for the virtual machine that Citrix is hosting. Look on the side of the open file window to find "Local Disk" and navigate from there.
Alternatively you can open the file in Notepad, then copy the code and paste it into a new query window in SSMS.
Once the SQL code file is up on your SSMS screen, you'll see the green arrow Execute button is active in the top bar. Beside that is a heavy checkmark button. Try that first (it does a preliminary check of the code), and if it comes back clear you can click on the Execute button. Ideally this will provide some output in the results pane.
However, this is not (I think!) the end of configuration necessary for a custom screen. At least in the bad old days of Infomaker, you needed to upload special formatting files that described how the window was to be built into your Tessitura file system in an appropriate location. I think SSRS custom screens require files also. Where those go may be specific to your installation.
Lastly, you'll have to configure these screens to be available to the Security Tool so that you can assign them to user groups.
Step 4) start in Test.
All that said, even with my past experience doing this, I'd be inclined (if this is an option for you) to look into getting help from Tessitura support. They may charge you a little bit.
Ask John for help. In the meantime, here's some documentation to look at. There doesn't appear to be a v16 version.
www.tessituranetwork.com/.../Custom-Screens-v150
Yeah, my museum is trying to avoid paying for it (you know being non-profit we have no budget for stuff like this). So we are trying to figure out how to build it ourselves.
Thank you for the instructions. I will play around with it and see what happens.