Scanning membership card:store usage, VIP lounge etc

I have received a request from our Development department for a way to track donor usage by scanning a membership card. The idea is that when a purchase is made at our store (running Microsoft Retail Management) or when a donor appears in our VIP lounge, their card would be scanned to track how they are using their benefits. Donors can use the VIP lounge anytime that they want so it is not possible to set it up as performance in Tessitura. We want them to be able to use their member card without having to issue tickets for the lounge. Is anyone doing anything like this? I would love to hear from you.

Parents
  • Hi Lou -

    We're doing something sort of similar, but it is completely offline from Tessitura and we have to import it in. We scan their 'membership' card using one of our scanners that adds the customer number from the barcode to an excel file on the scanner. We then take that excel and dump it into a list in Tessi and add a Premium to the account (specific to our usage case).

    It's not particularly elegant, but it gets the job done right now and at least provides basic usage information. Eventually I could write some sort of lovely code that does the work for me, but that's down the road.

    FWIW,

    - Heather

Reply
  • Hi Lou -

    We're doing something sort of similar, but it is completely offline from Tessitura and we have to import it in. We scan their 'membership' card using one of our scanners that adds the customer number from the barcode to an excel file on the scanner. We then take that excel and dump it into a list in Tessi and add a Premium to the account (specific to our usage case).

    It's not particularly elegant, but it gets the job done right now and at least provides basic usage information. Eventually I could write some sort of lovely code that does the work for me, but that's down the road.

    FWIW,

    - Heather

Children
No Data