• Replies 7 replies
  • Subscribers 414 subscribers
  • Views 24 views
  • Users 0 members are here
Related

Tessitura working with Micros POS software?

Jennifer Aprea
$organization

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

Parents
  • $organization

    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

    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




    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!

  • $organization in reply to Jennifer Aprea

    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.

     

Reply
  • $organization in reply to Jennifer Aprea

    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.

     

Children