• Replies 5 replies
  • Subscribers 339 subscribers
  • Views 36 views
  • Users 0 members are here
Related

Fees - Free Friday

Terry Stevens
$organization

We are investigating offering a free Friday where no web fees would be charged to customers.  We are wondering if anyone has ever tried something similar and just how it might be accomplished.  We could do this using a promo code but we want it to be automatic for all customers who log in on that day and not require them to type in a code.   Any ideas on how we could automatically turn off a fee for a day and back on after 24 hours?   

  • $organization

    We did this, but it was not automatic.  We just unassociated the fee from Web MOS then reassociated it when promotion was over.

    It worked fine, just wasn’t automatic.

     

    From: Terry Stevens [mailto:bounce-terrystevens8563@tessituranetwork.com]
    Sent: Thursday, May 19, 2011 10:27 AM
    To: Sharon Grayton
    Subject: [Tessitura Technical Forum] Fees - Free Friday

     

    We are investigating offering a free Friday where no web fees would be charged to customers.  We are wondering if anyone has ever tried something similar and just how it might be accomplished.  We could do this using a promo code but we want it to be automatic for all customers who log in on that day and not require them to type in a code.   Any ideas on how we could automatically turn off a fee for a day and back on after 24 hours?   




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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

    A simpler method could be to just make the fees inactive for the 24 hour period (T_FEE.inactive =’Y’ in the db or simply do it manually in the Fee setup).

     

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Sharon Grayton
    Sent: Thursday, May 19, 2011 10:42 AM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] Fees - Free Friday

     

    We did this, but it was not automatic.  We just unassociated the fee from Web MOS then reassociated it when promotion was over.

    It worked fine, just wasn’t automatic.

     

    From: Terry Stevens [mailto:bounce-terrystevens8563@tessituranetwork.com]
    Sent: Thursday, May 19, 2011 10:27 AM
    To: Sharon Grayton
    Subject: [Tessitura Technical Forum] Fees - Free Friday

     

    We are investigating offering a free Friday where no web fees would be charged to customers.  We are wondering if anyone has ever tried something similar and just how it might be accomplished.  We could do this using a promo code but we want it to be automatic for all customers who log in on that day and not require them to type in a code.   Any ideas on how we could automatically turn off a fee for a day and back on after 24 hours?   




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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

    That was our first thought or just deactivating the fee but they are thinking of doing this every week for an entire year. 

     

    Terry

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Sharon Grayton
    Sent: Thursday, May 19, 2011 10:42 AM
    To: Stevens, Terry
    Subject: RE: [Tessitura Technical Forum] Fees - Free Friday

     

    We did this, but it was not automatic.  We just unassociated the fee from Web MOS then reassociated it when promotion was over.

    It worked fine, just wasn’t automatic.

     

    From: Terry Stevens [mailto:bounce-terrystevens8563@tessituranetwork.com]
    Sent: Thursday, May 19, 2011 10:27 AM
    To: Sharon Grayton
    Subject: [Tessitura Technical Forum] Fees - Free Friday

     

    We are investigating offering a free Friday where no web fees would be charged to customers.  We are wondering if anyone has ever tried something similar and just how it might be accomplished.  We could do this using a promo code but we want it to be automatic for all customers who log in on that day and not require them to type in a code.   Any ideas on how we could automatically turn off a fee for a day and back on after 24 hours?   




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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 Terry Stevens

    You could schedule a job to run every Friday and Saturday at 12:01am that does something like:


    Update t_fee
    set inactive = case datepart(WEEKDAY,getdate())
    when 6 then 'Y' -- 6 = Friday
    else 'N' end
    where fee_no = <your fee no here>

    Just be sure to turn this off when the promotion ends!

    David

  • $organization

    David,

     

    Thank you.  That is what I was looking for.  We will give it a test. 

     

    Terry

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Woodall
    Sent: Thursday, May 19, 2011 11:22 AM
    To: Stevens, Terry
    Subject: RE: [Tessitura Technical Forum] Fees - Free Friday

     

    You could schedule a job to run every Friday and Saturday at 12:01am that does something like:


    Update t_fee
    set inactive = case datepart(WEEKDAY,getdate())
    when 6 then 'Y' -- 6 = Friday
    else 'N' end
    where fee_no = <your fee no here>

    Just be sure to turn this off when the promotion ends!

    David

    From: Terry Stevens <bounce-terrystevens8563@tessituranetwork.com>
    Sent: 5/19/2011 9:59:20

    That was our first thought or just deactivating the fee but they are thinking of doing this every week for an entire year. 

     

    Terry

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Sharon Grayton
    Sent: Thursday, May 19, 2011 10:42 AM
    To: Stevens, Terry
    Subject: RE: [Tessitura Technical Forum] Fees - Free Friday

     

    We did this, but it was not automatic.  We just unassociated the fee from Web MOS then reassociated it when promotion was over.

    It worked fine, just wasn’t automatic.

     

    From: Terry Stevens [mailto:bounce-terrystevens8563@tessituranetwork.com]
    Sent: Thursday, May 19, 2011 10:27 AM
    To: Sharon Grayton
    Subject: [Tessitura Technical Forum] Fees - Free Friday

     

    We are investigating offering a free Friday where no web fees would be charged to customers.  We are wondering if anyone has ever tried something similar and just how it might be accomplished.  We could do this using a promo code but we want it to be automatic for all customers who log in on that day and not require them to type in a code.   Any ideas on how we could automatically turn off a fee for a day and back on after 24 hours?   




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!