Tessiturians, hello!
I think this may be an easy question: What to do if I have more performance numbers than will "fit" in the Perf No column in LTR_NSCAN_PROFILES? Usually I can update this table on Mondays for an entire week's worth of performances at a multi-facility venue. But there are weeks where we have more than the approx. 10 perf numbers (separated by commas) which will fit in this column. The simple answer of course is to update the data mid-week with the numbers needed for the remainder of the week, but I don't always remind myself until it is too late. And sometimes we even have too many performances over a 2-day weekend when I'm not working. I'd prefer not to burden the weekend staff with this chore, but it may be my only option. The situation is slightly worse since we have recently crossed the 10,000 performances threshold and perf numbers are now 5 digits!
I appreciate your advice!
Jon Slater - Huntington Theatre Company, Boston
Hi Jon,
Just to clarify, what's the rationale for populating the perf_no column instead of using the facility column and restarting the scanners daily to pick up that day's performances?
I might have an idea to address the question, but wanted to make sure I understood the situation.
Thanks,
Jonathan
Hi Jon -
This is probably not something you can do in your set up, but we use facility (we have multiple venues as well) and then doors open/close to indicate which performance to pull for which day. That way the scanners automatically grab what performances they want.
Is that something that might work for your organization?
You have to set LTR_NSCAN_DEFAULTS to 'Use Performance Door Times' = Yes and you have to make sure to set all the door times which you can usually easily do with a sql update.
Heather