• Replies 2 replies
  • Subscribers 414 subscribers
  • Views 31 views
  • Users 0 members are here
Related

Ticket and Subscription History

Reena Taank
$organization

Hi All,

We are wondering if there is a way to transfer ticket history to a patron who splits up their account.  For example, Mrs Smith has purchased subscriptions for 2 of her friends for 10 years. This year however, they choose to split up their subscriptions into their own accounts. 

We are starting to do more and more work to honour long time subscribers and unfortunately this info is lost when creating new accounts.  Any ideas? Does anybody have a workaround on this?

Thanks

Reena

  • $organization

    Hi Reena,

    Bit depends on how daring you want to be. 

    The most daring move using SQL edit the current record, move the edited record into EXCEL, copy and edit the record so the information reflects the friends purchase, and then do a custom import of the EXCEL data.

    The less daring process use attributes so you would have and attribute for the series and the number of years subscribed.  You could then write a bit of SQL to update the years subscribed at the end of each season.

    Peter

     

  • $organization

    Thanks Peter!

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Peter Smurlick
    Sent: Tuesday, February 17, 2015 11:29 AM
    To: Reena Taank
    Subject: Re: [Tessitura Ticketing Forum] Ticket and Subscription History

     

    Hi Reena,

    Bit depends on how daring you want to be. 

    The most daring move using SQL edit the current record, move the edited record into EXCEL, copy and edit the record so the information reflects the friends purchase, and then do a custom import of the EXCEL data.

    The less daring process use attributes so you would have and attribute for the series and the number of years subscribed.  You could then write a bit of SQL to update the years subscribed at the end of each season.

    Peter

     

    From: Reena Taank <bounce-reenataank8609@tessituranetwork.com>
    Sent: 2/17/2015 12:33:59 PM

    Hi All,

    We are wondering if there is a way to transfer ticket history to a patron who splits up their account.  For example, Mrs Smith has purchased subscriptions for 2 of her friends for 10 years. This year however, they choose to split up their subscriptions into their own accounts. 

    We are starting to do more and more work to honour long time subscribers and unfortunately this info is lost when creating new accounts.  Any ideas? Does anybody have a workaround on this?

    Thanks

    Reena



    --
    View this message online at http://www.tessituranetwork.com/Community/forums/p/13098/40715.aspx#40715 or reply to this message
    --
    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!

    IMPORTANT NOTICE: This email transmission and any accompanying  attachments contain confidential information intended 
only for the use of the individual or entity named above. Any dissemination, distribution, copying or  action  taken 
in  reliance on the contents of this email by anyone other than the intended recipient is strictly prohibited. If you  
have received this email in error please immediately delete it and notify sender at the above email address.