Hi all-
First just want to say I'm new to Tessitura and have been lurking on TN for a bit. These forums have been a big help learning everything so thank you all.
Moving on.... I have begun looking at an issue that we have had with Wordfly for our Email Marketing. In response to the way that bounces are handled. After looking through our DB I believe I found that LP_UPDATE_EMAIL_PROMOTION is being triggered by WF (via WP_UPDATE_EMAIL_PROMOTION) and that this is triggered as the result of a Campaign running in WF.
So I have two questions:
Is it acceptable to modify TR_EMRKT_IND to include custom fields?
Is it accepted procedure to modify LP_UPDATE_EMAIL_PROMOTION to update T_CUSTOMER 's EMARKET_IND?
Ultimately I would like to take charge over the Hard/Soft bounce protocol (It seems that most of this is handled by WF in our current installation), give the Box Office a quicker way to identify why a constituent would not be getting their email, and allow patrons to easily re-subscribe to newsletters if they have previously unsubscribed.
Any input would be greatly appreciated,
Thanks,
Chris
FAIRFIELD THEATRE COMPANY | on StageOne | at The Klein Christopher Sherwood | Technical Director 70 Sanford Street, Fairfield, CT 06824 T 203.319.1404 x310 | F 203.259.1747 | C 203.257.8569
Chris@fairfieldtheatre.org | www.fairfieldtheatre.org
It's always good to hear when someone, especially someone new to the software, makes great use of the forums. In answer to your questions, it is not allowed to change TR_EMRKT_IND to have new columns, but you can, of course, add new rows there to reflect possible new values. And it is allowed (encouraged in fact) to make changes to LP_UPDATE_EMAIL_PROMOTION. Any procedure which begins with LP_ is designed to be edited to contain your custom code.