Timed Entry Facility Share

Here you go!

I think the easiest way to get the values you need for the EXEC is to run a trace while you apply the map through season manager to one event. Shoot me an email if you want to walk through any of it! aabernathy@sheddaquarium.org

--Trace:
--TP_APPLY_HC_MAP @m_perf_no = 113213, @m_hcmap_no = 39, @m_date_appl_mode = 3, @m_end_date = '2019-10-23 00:00:00', @m_repl_mode = 1, @m_session_no = 11169


DECLARE @item_id INT 
DECLARE ITEM_CURSOR CURSOR  -- Create the cursor

FOR --contents of the cursor, selecting the value you're gonna mess with
SELECT p.perf_no
FROM dbo.T_PERF p
WHERE p.prod_season_no IN (112850,136718,112851,112852,112853) -- 2020 4D Shows
 
OPEN ITEM_CURSOR -- Opens the cursor
FETCH NEXT FROM ITEM_CURSOR into @Item_ID -- Fetch the first value from selection into variable

WHILE @@FETCH_STATUS = 0 -- start a loop for all the values within the selection 
BEGIN

--actions taken for each row:-- stored procedure to apply hold code map
	EXEC dbo.TP_APPLY_HC_MAP 
	@m_perf_no = @item_id, 
	@m_hcmap_no = 39, 
	@m_date_appl_mode = 3, 
	@m_end_date = '2019-10-23 00:00:00', 
	@m_repl_mode = 1 ,
	@m_session_no = 11198

	FETCH NEXT FROM ITEM_CURSOR INTO @ITEM_ID -- We fetch the next value

END

-- We arrive here when @@FETCH_STATUS shows there are no more results to treat
CLOSE ITEM_CURSOR  
DEALLOCATE ITEM_CURSOR -- CLOSE and DEALLOCATE remove the data from memory and clean up the process


-- single test exec: 

--EXEC TP_APPLY_HC_MAP 
--@m_perf_no = 113053, 
--@m_hcmap_no = 39, 
--@m_date_appl_mode = 3, 
--@m_end_date = '2019-10-23 00:00:00', 
--@m_repl_mode = 1, 
--@m_session_no = 11192

--SELECT * FROM dbo.T_NEXT_ID

--SELECT TOP 10 * FROM t_session

--Trace:
--TP_APPLY_HC_MAP @m_perf_no = 113213, @m_hcmap_no = 39, @m_date_appl_mode = 3, @m_end_date = '2019-10-23 00:00:00', @m_repl_mode = 1, @m_session_no = 11169


DECLARE @item_id INT 
DECLARE ITEM_CURSOR CURSOR  -- Create the cursor

FOR --contents of the cursor, selecting the value you're gonna mess with
SELECT p.perf_no
FROM dbo.T_PERF p
WHERE p.prod_season_no IN (112850,136718,112851,112852,112853) -- 2020 4D Shows
 
OPEN ITEM_CURSOR -- Opens the cursor
FETCH NEXT FROM ITEM_CURSOR into @Item_ID -- Fetch the first value from selection into variable

WHILE @@FETCH_STATUS = 0 -- start a loop for all the values within the selection 
BEGIN

--actions taken for each row:-- stored procedure to apply hold code map
	EXEC dbo.TP_APPLY_HC_MAP 
	@m_perf_no = @item_id, 
	@m_hcmap_no = 39, 
	@m_date_appl_mode = 3, 
	@m_end_date = '2019-10-23 00:00:00', 
	@m_repl_mode = 1 ,
	@m_session_no = 11198

	FETCH NEXT FROM ITEM_CURSOR INTO @ITEM_ID -- We fetch the next value

END

-- We arrive here when @@FETCH_STATUS shows there are no more results to treat
CLOSE ITEM_CURSOR  
DEALLOCATE ITEM_CURSOR -- CLOSE and DEALLOCATE remove the data from memory and clean up the process


-- single test exec: 

--EXEC TP_APPLY_HC_MAP 
--@m_perf_no = 113053, 
--@m_hcmap_no = 39, 
--@m_date_appl_mode = 3, 
--@m_end_date = '2019-10-23 00:00:00', 
--@m_repl_mode = 1, 
--@m_session_no = 11192

--SELECT * FROM dbo.T_NEXT_ID

--SELECT TOP 10 * FROM t_session

Hello Mark!

We're going to be implementing timed admission (purchased online), with restrictions- we'd like a certain amount to be just comps, a certain amount to be reserved for members, and the rest for general admission.

Could you explain a bit more how you set up your online visible/invisible tickets? We've done timed general admission once before, for a reduced set of exhibits, but we've never we reserved seats for our GA.

How would we have timed zones for admission, while reserving a certain number for comps, members, and general, while having this available online, while having a way to make sure only the correct types of guests are getting the right types of tickets?  I'm not sure how the zones, the price types, the TNEW setup (we're on TNEW 7, which gives us alot of control, which is good), and the N-Scanning all come together.

Any help would be appreciated!

Just wanted to say THANK YOU for this thread. We are looking at the same thing, and I am not quite there yet, but this will be ultra helpful soon :) 

Adding on, I've got some scripts for those of you using packages that need to swap the performances in your perf groups from the standard to the timed event. If you keep the first part of your perf codes the same- ours went from "SAmmdd" to "SAmmddT" -they should be pretty easy to re-use. Let me know if anyone wants them and I'll add in more helpful comments and share!

That would be amazing Amanda, derrek.bentley@humanrights.ca if you don't mind sharing.

Good morning-

Sorry for the delay. We are also working a quick path to an opening date!

I think the high-level answer to your question is that it is all about what tickets are exposed to your Web API (Price Type/User Group Tab in Ticketing Set-up) and the Price Type/MOS Tab. I have two Zones Per Hour - one for Public and one for General Admission. From there, I can Enable/Disable the appropriate Price Types by Zone so they show up. The Member Tickets are only in the Web-member MOS.

I'm not sure what exactly you mean by Comps. We don't have any Comps on the Web and honestly Comps, plus discounts, and pre-purchased vouchers and also CityPASS all cause grief, too. As I mentioned above, we have an "Untimed Zone" with tickets that are NOT exposed to the web available so that the Guest Services Team has some flexibility to take care of any situation (outside of the hourly zone limits) so their hands are not completely tied.

Hope this helps some!

Thank you! I appreciate you taking the time.

You ended up being right- we'll be using Modes of Sale to cordon off price types. We're still tweaking the end results, but we're getting very close to go-live functional. 

Hi folks! This has been my project all day.  And I am almost there...but now I am stuck with a whole bunch of stuff being greyed out.  I haven't worked in Facilities at all really, so I think I am missing someone that is probably obvious, but alas, I can't figure it out.  How do I get these to be 'not greyed out'...

NEVERMIND.  I have to click the 'Enabled' box under detailed view.  Ughhhh haha.  Found it the second I hit 'Reply'.

Hi everyone. We are almost ready with timed ticketing (miracle!). The one last piece I am stuck on is, I created a zone that is a 'Flex zone' that I only want available for our ticketing staff...but it is still being shown online.  Is there a way to just hide this specific zone online?  

We don't currently use allocation codes, and I am assuming we could do it that way? I am just trying to avoid going there if I don't have to ;)