Reporting on the number of PAH patrons

Although, what I sent you can work.

Please note the other instructions / warning in this thread. This is used in conjunction with a number of other order specific keywords.

It would be much better if this were actually used a separate secured view.

If someone else has a better keyword. Please share. I'd love to copy.

--Tom

On Thu, Jan 15, 2015 at 9:49 AM, Tessitura Ticketing Forum wrote:
Tom:
That's done it. Thank you for the wonderful and detailed instruction.
That was amazing. Is there some kind of recipe book for creating new line items in T_KEYWORD?


On Wed, Jan 14, 2015 at 8:05 PM, Tom Brown > wrote:
We have one. try having one of your system administrator add the following to T_Keyword.

Description = Ticket Delivery method
Data Type = Number
Edit Mask = This one is blank in our system. If others have better ideas please let us know.
Detail Tbl = T_Order
Detail Col = !.delivery
Ref Tbl = TR_ORDER_SHIP_METHOD
Ref idcol = id
Ref Desccol = Description
Ref Where = This one is blank
Category = Ticketing Or anywhere else you may want this.
Use For List = List Only
Multiple Value = [Checked]
Control Group = Whomever should have access to this.
Custom ID = This one is blank
Custom Limit This one is blank
Custom Required = [Not Checked]
Custom Default Value This one is blank
Incl In Basic Search= [Not Checked]
Keyword Desc = Something that is clear to your users
Primary Group Default We have this at “Default Value No
Parent Table This one is blank
Parent Key Column This one is blank
Key Column This one is blank
Help Text Something useful

--Tom
…
718.724.8135
tbrown@BAM.org

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Christopher Short
Sent: Wednesday, January 14, 2015 4:48 PM
To: Thomas Brown
Subject: Re: [Tessitura Ticketing Forum] Reporting on the number of PAH patrons


Sounds like a job for T-Stats!
From: David Janeski >
Sent: 1/14/2015 7:16:28 PM
Thank you for the suggestion.
In List Mgr > Ticketing Folder, I have no option for "delivery method"
Here's what I do have:

Comp Code
MOS Category
Number of Seats
Order Date
Order MOS Custom
Per Ticket Amount
Perf Date
Perf Name
Price Type
Season
Total Amount

On Wed, Jan 14, 2015 at 2:02 PM, Maurice Nounou > wrote:

You should be able to generate a list using Order Delivery Method (under the Ticketing folder) as a line item. It would then depend on if you wanted to know based on season, by performance or just historically.
From: David Janeski >
Sent: 1/14/2015 1:11:29 PM

What is the best wayt o find out how many patrons are using our print at home ticketing?


--
View this message online at http://www.tessituranetwork.com/Community/forums/p/12878/40103.aspx#40103 or reply to this message
-David Janeski
Virginia Repertory Theatre
Tessitura Administrator
(804) 282-2620 x1147



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!


--
View this message online at http://www.tessituranetwork.com/Community/forums/p/12878/40117.aspx#40117 or reply to this message

-David Janeski
Virginia Repertory Theatre
Tessitura Administrator
(804) 282-2620 x1147



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!

Although, what I sent you can work.

Please note the other instructions / warning in this thread. This is used in conjunction with a number of other order specific keywords.

It would be much better if this were actually used a separate secured view.

If someone else has a better keyword. Please share. I'd love to copy.

--Tom

On Thu, Jan 15, 2015 at 9:49 AM, Tessitura Ticketing Forum wrote:
Tom:
That's done it. Thank you for the wonderful and detailed instruction.
That was amazing. Is there some kind of recipe book for creating new line items in T_KEYWORD?


On Wed, Jan 14, 2015 at 8:05 PM, Tom Brown > wrote:
We have one. try having one of your system administrator add the following to T_Keyword.

Description = Ticket Delivery method
Data Type = Number
Edit Mask = This one is blank in our system. If others have better ideas please let us know.
Detail Tbl = T_Order
Detail Col = !.delivery
Ref Tbl = TR_ORDER_SHIP_METHOD
Ref idcol = id
Ref Desccol = Description
Ref Where = This one is blank
Category = Ticketing Or anywhere else you may want this.
Use For List = List Only
Multiple Value = [Checked]
Control Group = Whomever should have access to this.
Custom ID = This one is blank
Custom Limit This one is blank
Custom Required = [Not Checked]
Custom Default Value This one is blank
Incl In Basic Search= [Not Checked]
Keyword Desc = Something that is clear to your users
Primary Group Default We have this at “Default Value No
Parent Table This one is blank
Parent Key Column This one is blank
Key Column This one is blank
Help Text Something useful

--Tom
…
718.724.8135
tbrown@BAM.org

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Christopher Short
Sent: Wednesday, January 14, 2015 4:48 PM
To: Thomas Brown
Subject: Re: [Tessitura Ticketing Forum] Reporting on the number of PAH patrons


Sounds like a job for T-Stats!
From: David Janeski >
Sent: 1/14/2015 7:16:28 PM
Thank you for the suggestion.
In List Mgr > Ticketing Folder, I have no option for "delivery method"
Here's what I do have:

Comp Code
MOS Category
Number of Seats
Order Date
Order MOS Custom
Per Ticket Amount
Perf Date
Perf Name
Price Type
Season
Total Amount

On Wed, Jan 14, 2015 at 2:02 PM, Maurice Nounou > wrote:

You should be able to generate a list using Order Delivery Method (under the Ticketing folder) as a line item. It would then depend on if you wanted to know based on season, by performance or just historically.
From: David Janeski >
Sent: 1/14/2015 1:11:29 PM

What is the best wayt o find out how many patrons are using our print at home ticketing?


--
View this message online at http://www.tessituranetwork.com/Community/forums/p/12878/40103.aspx#40103 or reply to this message
-David Janeski
Virginia Repertory Theatre
Tessitura Administrator
(804) 282-2620 x1147



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!


--
View this message online at http://www.tessituranetwork.com/Community/forums/p/12878/40117.aspx#40117 or reply to this message

-David Janeski
Virginia Repertory Theatre
Tessitura Administrator
(804) 282-2620 x1147



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!