• Replies 4 replies
  • Subscribers 411 subscribers
  • Views 12 views
  • Users 0 members are here
Related

Default solictor when reserving seats

Former Member
Former Member $organization

Hi,

Am writing a new website that connects to our tessitura installation. When I try reserve seats using "ReserveTicketsSpecifiedSeats" it works fine if a user is signed in but if I try to reserve seats using the default constituent then seats are locked in the system but then I get an error saying

"Default Solicitor value not present in T_DEFAULTS table"

If I look at the table we a number of rows for Default Solicitor for various organisations we run through our system. Only one has  a value of null that is for parent_table "Tessitura Web".

Is there a way I can tell the Tessitura, which row to look at depending on the organisation?

Thanks

Parents
  • Former Member
    Former Member $organization
    Hi Huw
    To use the org-based defaults, you need to set a session variable called organization_name to match the parent table value in t_defaults. If there's no organization_name value set, the api uses the Tessitura Web value. It's the default default, as it were. Actually you probably should have a value set for that, just as a catch all - if it shows up, you know you've got a problem.

    In our experience working with org name session variables, you need to be careful to maintain them - under certain circumstances, they can be lost - before you do anything critical, you probably should reset, or at least check them.


    Sent from the iPad

    On 11/06/2013, at 1:21, "Huw Davies" <bounce-huwdavies2886@tessituranetwork.com> wrote:

    Hi,

    Am writing a new website that connects to our tessitura installation. When I try reserve seats using "ReserveTicketsSpecifiedSeats" it works fine if a user is signed in but if I try to reserve seats using the default constituent then seats are locked in the system but then I get an error saying

    "Default Solicitor value not present in T_DEFAULTS table"

    If I look at the table we a number of rows for Default Solicitor for various organisations we run through our system. Only one has  a value of null that is for parent_table "Tessitura Web".

    Is there a way I can tell the Tessitura, which row to look at depending on the organisation?

    Thanks




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

    Hear Richard Tognetti present ACO2 and German cellist Daniel M&#x000FC;ller-Schott in a classic showcase of string orchestra repertoire.
    Touring nationally 13-26 June. www.aco.com.au/tognetti-aco2

    This email is confidential. If you are not the intended recipient you must not disclose or use the information contained in it. If you have received this email in error please notify us immediately by return email and delete the document. The ACO is not responsible for any changes made to a document other than those made by the ACO or for the effect of the changes on the document's meaning. The ACO accepts no liability for any damage caused by this email or its attachments due to viruses interference, interception, corruption or unauthorised access.
Reply
  • Former Member
    Former Member $organization
    Hi Huw
    To use the org-based defaults, you need to set a session variable called organization_name to match the parent table value in t_defaults. If there's no organization_name value set, the api uses the Tessitura Web value. It's the default default, as it were. Actually you probably should have a value set for that, just as a catch all - if it shows up, you know you've got a problem.

    In our experience working with org name session variables, you need to be careful to maintain them - under certain circumstances, they can be lost - before you do anything critical, you probably should reset, or at least check them.


    Sent from the iPad

    On 11/06/2013, at 1:21, "Huw Davies" <bounce-huwdavies2886@tessituranetwork.com> wrote:

    Hi,

    Am writing a new website that connects to our tessitura installation. When I try reserve seats using "ReserveTicketsSpecifiedSeats" it works fine if a user is signed in but if I try to reserve seats using the default constituent then seats are locked in the system but then I get an error saying

    "Default Solicitor value not present in T_DEFAULTS table"

    If I look at the table we a number of rows for Default Solicitor for various organisations we run through our system. Only one has  a value of null that is for parent_table "Tessitura Web".

    Is there a way I can tell the Tessitura, which row to look at depending on the organisation?

    Thanks




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

    Hear Richard Tognetti present ACO2 and German cellist Daniel M&#x000FC;ller-Schott in a classic showcase of string orchestra repertoire.
    Touring nationally 13-26 June. www.aco.com.au/tognetti-aco2

    This email is confidential. If you are not the intended recipient you must not disclose or use the information contained in it. If you have received this email in error please notify us immediately by return email and delete the document. The ACO is not responsible for any changes made to a document other than those made by the ACO or for the effect of the changes on the document's meaning. The ACO accepts no liability for any damage caused by this email or its attachments due to viruses interference, interception, corruption or unauthorised access.
Children
  • Former Member
    Former Member $organization in reply to Former Member

    Hi Ken,

    Thanks for your reply. Have set the session variable in the page_load using:


                        Session["organization_name"] = "Mayflower";

    Have checked the value persists when the reserveseats function is called but still get the same error. There is definitely a value for this organisation set in the database.

    Any ideas?