I'd like our Tessitura to "talk" to our concessionaire's point of sale system so that we could pre-sell beverages, etc in the box office. Our concessionaire uses a form of the Micros point of sale system. Maybe the bar staff scans a barcode on a drink voucher or swipes a mag strip card for payment and it deducts money from the patron's Tessitura account. I suspect it'll take some sort of middle ware to connect the two. Anyone out there doing anything like this?
Jennifer Aprea
AT&T PAC
Hi Caryl,
Sadly we have not continued down this path as we hoped we would. The building of the middle ware was going to be waaay more expensive than we could afford at the time. We’d still like to tackle it but it’s not a current priority. Let me know if you figure anything out!
Jennifer
Jennifer Aprea | Director, Ticket Services AT&T Performing Arts Center 2100 Ross Avenue, Suite 650 | Dallas, Texas | 75201 214.978.3665 (office) | 214.880.0303 (fax) jennifer.aprea@attpac.org
AT&T Performing Arts Center is proud to present a wonderful line up of programming Call 214.880.0202 or visit www.attpac.org for tickets!
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Caryl Jones Sent: Wednesday, February 26, 2014 5:26 AM To: Jennifer Aprea Subject: Re: [Tessitura Ticketing Forum] Tessitura working with Micros POS software?
Hi Jennifer & Nicholas,
Did either of you get anywhere with this at all, or has anyone done anything similar?
Thanks, Caryl
From: Jennifer Aprea <bounce-jenniferaprea3202@tessituranetwork.com> Sent: 2/16/2012 2:19:53 PM
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!
I spent a bunch of time discussing this with our different business units, and ended up with a half way solution.
The solution was to have a subset of our customers who are members present their membership cards which have their Constituent ID on a barcode to get their discount. This number would then be appended to the purchase in the third party POS.
The next stage is to extract reports that show these sales and import them to Tess. This has been a sticky point as it has proved challenging to get usable reports in a regular fashion from these third party systems. This is partly technical, and partly a business rule challenge.
We have not imported them to Tess yet, but when we do before the end of the FY, we will store them in the Purchase History table. We already have a custom T-Stats measure for reporting when that is done.
Here is a look at my account which shows some entries that we added manually into the database to simulate what the data would like like in a customer record. The Product Code column is just showing numbers, but the plan is to have that be codes like coffee/food/alcohol/books/catalogs.
Thanks both!