Hi All,
Just wandering, when a confirmation email is sent for an order, is this logged anywhere as having been sent?
Thanks
Hi Huw,
It's logged in Connections/Contact Log.
Michele
Don't suppose you know what table I'd find that in on the database?
The information is pulled from several tables to form the information shown in the Contact Log screen.
It's all pulled together by a stored procedure when you view the information in the constituent record - AP_CUSTOMER_LOG
If you ever need to know any table names for anything in the Constituent Record there is a really handy document in the System Administration section of the Documentation & Help System section called Tessitura Screens Table Reference which details where everything in the constituent is stored.
Caryl
The table is T_LOG_ORDER_EMAIL. There are some other T_LOG_*_EMAIL tables. A row is NOT written when TNEW sends order confirmations, if that's relevant to you.
Hey Huw,
You may find this document useful: http://www.tessituranetwork.com/~/media/Documentation/System%20Administration/Tessitura_Screens_Table_Reference.ashx
Dot
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Huw Davies Sent: Wednesday, September 21, 2016 10:30 AM To: Dot Krebs Subject: Re: [Tessitura Technical Forum] Confirmation email log
From: Michele Keutsch <bounce-michelekeutsch5100@tessituranetwork.com> Sent: 9/21/2016 9:54:13 AM
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!
Hey Guys,
Thanks for some really great responses. It appears our confirmation emails aren't being logged for some reason so need to investigate that but explains why I couldn't find it. We're not using TNEW, we have a custom site. Out site uses the SendOrderConfirmationEmail method from the SOAP API to send the confirmation emails. Should this be updating the log automatically or is there another method that needs to be used to update the log?
Ah, that's right.
Huw, check out this thread for more about that API method: http://www.tessituranetwork.com/Community/forums/p/16214/49038.aspx
Thanks for clearing this up.
Looks like will have to write my own procedure. That's not a problem, was just checking if there was anything already built to save having to reinvent the wheel. Seems a fairly significant oversight. Hopefully be made available in Rest at some point.
Wondering how/if anyone resolved the fact that order confirmations sent via the API do not get logged in T_LOG_ORDER_EMAIL. We are experimenting with the new v14 HTML templates; it seems that they can be sent in the client order screen, but are not being inserted into T_LOG_ORDER_EMAIL (I think because they are sent via the API and not the method that gets them into T_LOG_ORDER_EMAIL).