Are you using the ltr_add_registrant table and trigger to add students on the web? If so, are you using the GetLocalData/UpdateLocalData methods or are you using a procedure with ExecuteLocalProcedure?
If you are not doing it this way, how are you doing it?
Hi-
For our web we are actually using the standard Tessitura process of creating a record via associations in the associations tab, and copying the address information (which is what the ltr_add_registrant table and stored procedure do as well) In the client we still use this custom process. It seems to work great. We also do use the ExecuteLocalProceduure for other aspects of our web registration around our specific business rules.
Thanks
Jeanette Boudjouk
Database Administrator
Jeanette,
How do you update the student (associated record) through the API. From what we can see, the UpdateAccount and GetConstituentInfo API calls require a session id which is the parent’s account as they are the logged in user.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jeanette Boudjouk Sent: Monday, August 02, 2010 5:26 PM To: Gloria Ormsby Subject: Re: [Tessitura Technical Forum] Student Registration Online
From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com> Sent: 8/2/2010 3:38:04 PM
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!
Hi Gloria -
We don't allow updates to the child record via the web, or for that matter the parent record. We create CSI for address change information, and name change information, which are managed by our staff.
To create a new child record we use addCont. call, and then associate them via updateassociation call, we have a function to create a web session id. Hope that helps.
Jeanette
Gloria,
We wrote a custom procedure and are using ExecuteLocalProcedure to do this. The procedure takes parent customer_no and the student information, creates the student and the association.
I'd be happy to talk further about this with you.
David
Hi David,
Once you create the student’s record, how do you then update that record through the API? Seems the correct calls (UpdateAccountEX and UpdateConstituentInfo only take the sessionid as a parameter – which is tied to the logged in user…the parent. I suspect I’ll need to create a custom procedure but wanted to make sure that I’m not missing anything available through the API to do this.
Gloria
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Woodall Sent: Friday, August 06, 2010 1:36 PM To: Gloria Ormsby Subject: Re: [Tessitura Technical Forum] Student Registration Online
Yes, all the updating to the Student records is done via custom procedures and ExecuteLocalProcedure. Nothing in the API will let you modify an associated record.
Thanks David.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Woodall Sent: Monday, August 16, 2010 12:55 PM To: Gloria Ormsby Subject: RE: [Tessitura Technical Forum] Student Registration Online
From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com> Sent: 8/9/2010 9:38:16 AM