Re: Too many Perf Nunmbers for theNSCAN_PROFILES table.

Jonathan,

 

Great to hear from you! 

Our table is already loaded with facility codes, 3 at the Huntington Avenue location and 9 at the Tremont Street location.

Are you saying that we should put [nothing] in the Perf No column? 

And that tickets with the correct facility, additionally filtered by the proper Doors Open/Doors Close (in Ticketing Setup > Production Elements > Performances > General) would be accepted?  That's brilliant!  I'm not the person who would need to restart the scanners daily, but that probably doable.

 

There is no local documentation on the LTR_NSCAN_PROFILES which I can find, or I might have come to your solution a long time ago. 

 

Please confirm that I understand what you are suggesting.

 

Best,

Jon

 

 

>>> bounce-jonathansmillie8578@tessituranetwork.com 2/25/2011 12:37 PM >>>

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

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

--
View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/4116/13591.aspx#13591 or reply to this message
--
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!