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

  • 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.
  • 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?

  • Former Member
    Former Member $organization

    Hi Huw

    Sorry about that – now that I look at our t_web_session_Variable table, it looks like the session variable should actually be called “Organization Name” – with a space and no underscore.

     

    ________________________________
    Ken McSwain

    Systems and Technology Manager

    Australian Chamber Orchestra

    Email: ken.mcswain@aco.com.au

    Ph:   +61 (0)2 8274 3833

    Mob: +61 (0)418 659 360 

    Fax:  +61 (0)2 8274 3801

    Opera Quays, 2 East Circular Quay, Sydney NSW 2000

    Website | Facebook | Twitter | YouTube

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Huw Davies
    Sent: Tuesday, 11 June 2013 18:51
    To: Ken McSwain
    Subject: Re: [Tessitura Development Forum] Default solictor when reserving seats

     

    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?


    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.
  • Former Member
    Former Member $organization in reply to Former Member

    Hi Ken,

    Thanks, that seems to have done it. Although didn't realise I had to set the variable through the API using SetVariable() rather just setting a regular session variable.

    Thanks again