• Replies 4 replies
  • Subscribers 414 subscribers
  • Views 75 views
  • Users 0 members are here
Related

Problems with TR_WEB_SOURCE_NO

Elizabeth Carlock (Past Member)
$organization

I'm stumped and am looking for some advice.  I have created a entry in the TR_WEB_SOURCE_NO table to link my source number (425) to the promo code word (PEK) same as I have done for many other sources.  However when I attempt to use the code word on our website I'm getting an error message that the promo code is invalid.  Yet if I use the source number it works as expected.  Any ideas on what I might have missed?  Suggestions on how to make it work?

Appreciate all and any ideas,

Elizabeth Carlock

Director, Ticketing Services

The Granada/Santa Barbara Center for the Performing Arts

Parents
  • Former Member
    Former Member $organization
    I think the website needs to be configured to see the code word instead of the code itself.

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Elizabeth Carlock
    Sent: Wednesday, November 18, 2009 1:27 PM
    To: Jeri Henderson
    Subject: [Tessitura Ticketing Forum] Problems with TR_WEB_SOURCE_NO

    I'm stumped and am looking for some advice.  I have created a entry in the TR_WEB_SOURCE_NO table to link my source number (425) to the promo code word (PEK) same as I have done for many other sources.  However when I attempt to use the code word on our website I'm getting an error message that the promo code is invalid.  Yet if I use the source number it works as expected.  Any ideas on what I might have missed?  Suggestions on how to make it work?

    Appreciate all and any ideas,

    Elizabeth Carlock

    Director, Ticketing Services

    The Granada/Santa Barbara Center for the Performing Arts




    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 Former Member

    I have 11 promo code words that work on our website and 2 that don’t but I can’t figure out what is different about those two.

     

    Elizabeth Carlock

    Director, Ticketing Services

    The Granada

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Jeri Henderson
    Sent: Wednesday, November 18, 2009 10:32 AM
    To: Elizabeth Carlock
    Subject: RE: [Tessitura Ticketing Forum] Problems with TR_WEB_SOURCE_NO

     

    I think the website needs to be configured to see the code word instead of the code itself.

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Elizabeth Carlock
    Sent: Wednesday, November 18, 2009 1:27 PM
    To: Jeri Henderson
    Subject: [Tessitura Ticketing Forum] Problems with TR_WEB_SOURCE_NO

    I'm stumped and am looking for some advice.  I have created a entry in the TR_WEB_SOURCE_NO table to link my source number (425) to the promo code word (PEK) same as I have done for many other sources.  However when I attempt to use the code word on our website I'm getting an error message that the promo code is invalid.  Yet if I use the source number it works as expected.  Any ideas on what I might have missed?  Suggestions on how to make it work?

    Appreciate all and any ideas,

    Elizabeth Carlock

    Director, Ticketing Services

    The Granada/Santa Barbara Center for the Performing Arts




    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!




    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!

Reply
  • $organization in reply to Former Member

    I have 11 promo code words that work on our website and 2 that don’t but I can’t figure out what is different about those two.

     

    Elizabeth Carlock

    Director, Ticketing Services

    The Granada

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Jeri Henderson
    Sent: Wednesday, November 18, 2009 10:32 AM
    To: Elizabeth Carlock
    Subject: RE: [Tessitura Ticketing Forum] Problems with TR_WEB_SOURCE_NO

     

    I think the website needs to be configured to see the code word instead of the code itself.

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Elizabeth Carlock
    Sent: Wednesday, November 18, 2009 1:27 PM
    To: Jeri Henderson
    Subject: [Tessitura Ticketing Forum] Problems with TR_WEB_SOURCE_NO

    I'm stumped and am looking for some advice.  I have created a entry in the TR_WEB_SOURCE_NO table to link my source number (425) to the promo code word (PEK) same as I have done for many other sources.  However when I attempt to use the code word on our website I'm getting an error message that the promo code is invalid.  Yet if I use the source number it works as expected.  Any ideas on what I might have missed?  Suggestions on how to make it work?

    Appreciate all and any ideas,

    Elizabeth Carlock

    Director, Ticketing Services

    The Granada/Santa Barbara Center for the Performing Arts




    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!




    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!

Children
  • $organization in reply to Elizabeth Carlock (Past Member)

    Is there an extra space before the promo code(s) in the table? I've done that before. Source still worked, but promo didn't.

    If that's not it, I'm not sure. It couldn't be too many things though. The source number works, so it sounds like the rest of the setup (mode, price type, etc.) is correct.

  • $organization in reply to Curtis Schneider

    No spaces in my table so I ended up deleting all of the pieces from the offer – offer, price type, tr_web_source_no entry, source number and appeal and then rebuilt them in this order:  appeal, source number, tr_web_source_no, price type, offer, and it worked just fine this time.  It appears that creating an offer with a code word is order dependent on how you build it – add the entries to tr_web_source_no before adding the price type and the offer to the performance.  Who knew?

     

    Thanks for all the suggestions,

     

    Elizabeth Carlock

    Director, Ticketing Services

    The Granada

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Curtis Schneider
    Sent: Wednesday, November 18, 2009 10:42 AM
    To: Elizabeth Carlock
    Subject: Re: [Tessitura Ticketing Forum] RE: Problems with TR_WEB_SOURCE_NO

     

    Is there an extra space before the promo code(s) in the table? I've done that before. Source still worked, but promo didn't.

    If that's not it, I'm not sure. It couldn't be too many things though. The source number works, so it sounds like the rest of the setup (mode, price type, etc.) is correct.

    From: Elizabeth Carlock <bounce-elizabethcarlock8778@tessituranetwork.com>
    Sent: 11/18/2009 12:36:00 PM

    I have 11 promo code words that work on our website and 2 that don’t but I can’t figure out what is different about those two.

     

    Elizabeth Carlock

    Director, Ticketing Services

    The Granada

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Jeri Henderson
    Sent: Wednesday, November 18, 2009 10:32 AM
    To: Elizabeth Carlock
    Subject: RE: [Tessitura Ticketing Forum] Problems with TR_WEB_SOURCE_NO

     

    I think the website needs to be configured to see the code word instead of the code itself.

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Elizabeth Carlock
    Sent: Wednesday, November 18, 2009 1:27 PM
    To: Jeri Henderson
    Subject: [Tessitura Ticketing Forum] Problems with TR_WEB_SOURCE_NO

    I'm stumped and am looking for some advice.  I have created a entry in the TR_WEB_SOURCE_NO table to link my source number (425) to the promo code word (PEK) same as I have done for many other sources.  However when I attempt to use the code word on our website I'm getting an error message that the promo code is invalid.  Yet if I use the source number it works as expected.  Any ideas on what I might have missed?  Suggestions on how to make it work?

    Appreciate all and any ideas,

    Elizabeth Carlock

    Director, Ticketing Services

    The Granada/Santa Barbara Center for the Performing Arts




    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!




    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!




    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!