Greetings!
I'm looking to write a stored procedure to send the data that gets created as part of a Aux event in TNEW (LTR TNEW CUSTOM FORM DATA) to move to a table or view as opposed to a CSI. Has anyone else done this? The functionality exists (LTR TNEW CUSTOM FORM SAVE DATA and the Use Stored Proc checkbox) but I am new to the stored procedure area so I'd love to check out someone else's example if you are willing to share. The CSIs are nice but I have a set of Aux events that are requesting 9 pieces of info and the CSI is pretty full and isn't as user-friendly for those needing the information.
Thanks!
Jenny
Here is a high level quick how to.
Custom form approach using validate cart:
Create your form fields. Create a validate point that has a custom form. Store the form into a staging table or sorts. Create some variables in the newly created sproc ie. LRP_TN_EXPRESS_WEB_SAVE_AUX_DATA. Once that is done select the appropriate information using the sessionkey and or li_seq_no from you staging table and stuff it into whatever table you want. You should be able to get order no, customer no, ...etc. using that.
Aux form approach:
Create your form fields. Create some variables in the newly created sproc ie. LRP_TN_EXPRESS_WEB_SAVE_AUX_DATA. When the order is saved the vars should be passed and you can stuff them into whatever table you want. keep in mind the field name and parameter name must be an exact match.
Important Setup things to note:
Required in the local stored procedure include @sessionKey (varchar(64)) and @li_seq_no (int). Do not forget to add the procedure name to tr_local_procedure system table. You will need a auxiliary item keyword for the "intended use" in the ltr_tnew_custom_form_save_data.
http://www.tessituranetwork.com/tn_express_web_user_guide/TNEW.htm#Topics/LTR_TNEW_CUSTOM_FORM_SAVE_DATA.htm?Highlight=save
Test, test, test.
Hope it helps. Feel free to shoot me an email.
Travis
Thanks, Travis. I'll try to digest this and may get back to you with questions.
Hi Jenny,
Did you end up making a procedure for this? And, if so, would you be willign to share it? I think I understand the basic structure here, but I am having trouble wrapping my head around it without specific examples in front of me.
Cheers,
Sheila
Hi Sheila,
I did not end up making a procedure. We used the standard CSI functionality and pulled info from there.
I'm considering trying this for our Open Day bookings. I haven't created anything yet (still weighing up the best approach) but I saw someone present on this exact thing at TLCC2017. It's in these slides: http://www.tessituranetwork.com/tlcc/2017/PDF/08_08_EDU_TNEW.pdf