• Replies 9 replies
  • Subscribers 247 subscribers
  • Views 66 views
  • Users 0 members are here
Related

XSLT

Marty Jones
$organization

Just found out that I am going to have build my own Email Confirmation template. I do not knowing anything about XSLT and I am currently at w3 Schools website teaching myself about it, my question is, in the sample templates, it appears that all the data comes from //GetOrderDetailsInfoResults/... Is there documentation or somewhere I can go to find out what fields are available in this uh.. data connection thingy?

 

Thanks!

Parents
  • $organization

    Hi Marty,

    If you look on your webgateway server in the templates directory.  There are sample templates.  The templates that start with the name "Order Email Sample2" use all the available fields.  If you need to pull data into email confirmations that is not in the datasets, this can be done.  I have posted in the forums examples of pulling in more super package data and appeneding it to the xml dataset for transformation. I also posted how to pull in order payment plan information as well.

    Here is a link that shows how I pull in the payment plan information:

    www.tessituranetwork.com/COMMUNITY/forums/t/977.aspx

    If you would like to I can send you a couple of our templates.

     

  • $organization in reply to Jon Ballinger

    Thanks Jon,

     

    I did find the samples but found an issue with them as is. Any negative dollar payment shows up as an donation. The issue with this is that returns show up as a donation. Because of this is why I need to build my own. I took a look at your sample and looks promising. Thanks for sharing that.

     

     

     

    Marty Jones

    Database Administrator

     

    Omaha Performing Arts
    1200 Douglas Street

    Omaha, Nebraska 68102

    P 402.661.8469  |  F 402.345.0222    

    majones@omahaperformingarts.org

    www.omahaperformingarts.org

    For tickets, call Ticket Omaha at 402.345.0606

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Jon Ballinger
    Sent: Friday, September 04, 2009 8:35 AM
    To: Martin A. Jones
    Subject: Re: [Tessitura Web Forum] XSLT

     

    Hi Marty,

    If you look on your webgateway server in the templates directory.  There are sample templates.  The templates that start with the name "Order Email Sample2" use all the available fields.  If you need to pull data into email confirmations that is not in the datasets, this can be done.  I have posted in the forums examples of pulling in more super package data and appeneding it to the xml dataset for transformation. I also posted how to pull in order payment plan information as well.

    Here is a link that shows how I pull in the payment plan information:

    www.tessituranetwork.com/COMMUNITY/forums/t/977.aspx

    If you would like to I can send you a couple of our templates.

     

    From: Marty Jones <bounce-martyjones7649@tessituranetwork.com>
    Sent: 9/3/2009 4:28:08 PM

    Just found out that I am going to have build my own Email Confirmation template. I do not knowing anything about XSLT and I am currently at w3 Schools website teaching myself about it, my question is, in the sample templates, it appears that all the data comes from //GetOrderDetailsInfoResults/... Is there documentation or somewhere I can go to find out what fields are available in this uh.. data connection thingy?

     

    Thanks!




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!

  • $organization in reply to Marty Jones

    Marty,

    We display this as well.  I had to make a call to get information on all the sublinitems in an order.  Once I got that information I added to the XML dataset, which could be used in the transform.  below is a screen shot of an order that has returned seats.

    I can send you mytemplates if you like.  I hope this helps. 

    Jon

Reply
  • $organization in reply to Marty Jones

    Marty,

    We display this as well.  I had to make a call to get information on all the sublinitems in an order.  Once I got that information I added to the XML dataset, which could be used in the transform.  below is a screen shot of an order that has returned seats.

    I can send you mytemplates if you like.  I hope this helps. 

    Jon

Children