TNEW - Aux info into a table/view instead of CSI

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

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.  

Jenny

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