• Replies 6 replies
  • Subscribers 359 subscribers
  • Views 40 views
  • Users 0 members are here
Related

V11 and Education Classes for children via the WEB

Robert Taulty
$organization

All,

On our V10 website we sell Children's classes that are purchases by the parent. The child must have the same address as the parent and we do this through a customization.The workflow for V11 we want is

1. Create a Household record for the parent and add the parent as a Adult affiliate to the household

2. Add the child information as a Minor Child affiliate to the household and

In V11 we are trying to make the child a primary affiliate via the SOAP/API and we find we that we can not make this happen.

I am interested in learning on how other organizations are selling children's classes in V11 Websites

 

Bob

 

  • $organization

    Hi Bob,

    We ran into the same issue since we sell children's classes in the same manner. As of right now we don't have a solution, other than the Tessitura Network's suggestion of rewriting the online components using REST instead of SOAP.

    The newly created child records are not marked as Primary, but our sales are continuing to go through fine and the only ramification seems to be the lack of data inheritance and other features that come with the Primary flag. (The affiliation still gets created.) I have vague plans to investigate some kind of automated script run on a regular basis that would add the Primary flag, but haven't gotten that far yet. Nor do I know if it's worth going that route vs. rewriting the code entirely.

    So no solution here, but we're in the same boat.

    -Michael

  • $organization

    Our “create student records on the web” process is actually being accomplished by a stored procedure on the Tessitura side, and the affiliation is being marked as primary. I can check with our DBA to see if that’s something that can be shared, if anyone’s interested…

     

    -p.

     

    Patrick Schley
    Academy Services Manager

    FIRST STAGE

    Transforming Lives Through Theater

    325 West Walnut Street | Milwaukee, WI 53212
    (414) 267-2970 direct     | (414) 267-2976 fax

     

     

  • $organization

    Hi Michael –

     

    We have a solution after we create the child on the web we are going to update it via a custom stored procedure that we will call.

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Michael Wilcox
    Sent: Thursday, October 11, 2012 1:54 PM
    To: Robert Taulty
    Subject: Re: [Tessitura Next Generation Forum] V11 and Education Classes for children via the WEB

     

    Hi Bob,

    We ran into the same issue since we sell children's classes in the same manner. As of right now we don't have a solution, other than the Tessitura Network's suggestion of rewriting the online components using REST instead of SOAP.

    The newly created child records are not marked as Primary, but our sales are continuing to go through fine and the only ramification seems to be the lack of data inheritance and other features that come with the Primary flag. (The affiliation still gets created.) I have vague plans to investigate some kind of automated script run on a regular basis that would add the Primary flag, but haven't gotten that far yet. Nor do I know if it's worth going that route vs. rewriting the code entirely.

    So no solution here, but we're in the same boat.

    -Michael

    From: Robert Taulty <bounce-roberttaulty1608@tessituranetwork.com>
    Sent: 10/11/2012 12:38:58 PM

    All,

    On our V10 website we sell Children's classes that are purchases by the parent. The child must have the same address as the parent and we do this through a customization.The workflow for V11 we want is

    1. Create a Household record for the parent and add the parent as a Adult affiliate to the household

    2. Add the child information as a Minor Child affiliate to the household and

    In V11 we are trying to make the child a primary affiliate via the SOAP/API and we find we that we can not make this happen.

    I am interested in learning on how other organizations are selling children's classes in V11 Websites

     

    Bob

     




    You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!

  • $organization

    Thank you we are going to doing this also

     

    Bob

     

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Patrick Schley
    Sent: Thursday, October 11, 2012 2:15 PM
    To: Robert Taulty
    Subject: RE: [Tessitura Next Generation Forum] V11 and Education Classes for children via the WEB

     

    Our “create student records on the web” process is actually being accomplished by a stored procedure on the Tessitura side, and the affiliation is being marked as primary. I can check with our DBA to see if that’s something that can be shared, if anyone’s interested…

     

    -p.

     

    Patrick Schley
    Academy Services Manager

    FIRST STAGE

    Transforming Lives Through Theater

    325 West Walnut Street | Milwaukee, WI 53212
    (414) 267-2970 direct     | (414) 267-2976 fax

     

     




    You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!

  • $organization

    Hello Patrick –

     

    Would you be able to send us a copy of your stored procedure that I can forward to our Database admin.

     

    Bob

     

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Patrick Schley
    Sent: Thursday, October 11, 2012 2:15 PM
    To: Robert Taulty
    Subject: RE: [Tessitura Next Generation Forum] V11 and Education Classes for children via the WEB

     

    Our “create student records on the web” process is actually being accomplished by a stored procedure on the Tessitura side, and the affiliation is being marked as primary. I can check with our DBA to see if that’s something that can be shared, if anyone’s interested…

     

    -p.

     

    Patrick Schley
    Academy Services Manager

    FIRST STAGE

    Transforming Lives Through Theater

    325 West Walnut Street | Milwaukee, WI 53212
    (414) 267-2970 direct     | (414) 267-2976 fax

     

     




    You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!

  • $organization

    Thank you Brian I will check it out

     

    Bob

     

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Brian Wilbur Grundstrom
    Sent: Thursday, October 11, 2012 2:46 PM
    To: Robert Taulty
    Subject: RE: [Tessitura Next Generation Forum] V11 and Education Classes for children via the WEB

     

    Solution 101 in shared reports does this.  I have installed it and it works great.

    Brian

     

    Brian Wilbur Grundstrom | Database Administrator
    SHAKESPEARE THEATRE COMPANY

    516 Eighth Street, SE | Washington, DC 20003-2834

    p 202.547.3230 ext. 2216 | c 917.952.7957
    bwg@shakespearetheatre.org 
    www.shakespearetheatre.org
    www.brianwilbur.com     

     

     

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Patrick Schley
    Sent: Thursday, October 11, 2012 2:15 PM
    To: Brian W. Grundstrom
    Subject: RE: [Tessitura Next Generation Forum] V11 and Education Classes for children via the WEB

     

    Our “create student records on the web” process is actually being accomplished by a stored procedure on the Tessitura side, and the affiliation is being marked as primary. I can check with our DBA to see if that’s something that can be shared, if anyone’s interested…

     

    -p.

     

    Patrick Schley
    Academy Services Manager

    FIRST STAGE

    Transforming Lives Through Theater

    325 West Walnut Street | Milwaukee, WI 53212
    (414) 267-2970 direct     | (414) 267-2976 fax

     

     




    You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!




    You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!