XSLT

I think the document you need is API Documentation:

http://www.tessituranetwork.com/~/media/Documentation/Web%20API/API_Documentation.ashx

Look in Appendix D, specifically page 494.

Kevin Sheehan

Documentation & Learning Resources Specialist

Tessitura Network

1 888 643 5778 ext 329 Office

ksheehan@tessituranetwork.com

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!

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.409 / Virus Database: 270.13.76/2343 - Release Date: 09/03/09 18:05:00

I don't know if I looked in the right spot or not but didn't see a page 494. Look in appendix D and I see the "OrderData" result set for the aspx page but I am looking for the //GetOrderDetailsInfoResults for the xls page which appear to pull in fields like li_seq_no, Pkg_Li_No, and Pkg_no.

Thanks,

Thanks Naomi, I think this is what I am looking for.

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

Hi Marty,

If you have access to the impresario database, you can pull up the stored procedure

[dbo]

.[WP_GET_ORDER_DETAILS]

and that will tell you all the fields that are available. Another good stored procedure to look at is

[dbo]

.[WP_GET_ORDER_CONF_DATA]

Hope this helps.

Naomi

I’m sorry.  I sited the wrong page, I meant 484 but you found it anyway.  I’ve been reading this document recently and it seemed like this was the information you were looking for, but I’m a little out of my element in this area.  I’m glad Naomi was able to help you out!

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

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.