Hello All,
Has anyone out there done an email append? We are planning on updating our email addresses and I've checked with MBS but am wondering if anyone has worked with a different vendor and had good luck. Any information is very much appreciated.
Thank you, David.
While was I continuing to research this matter, I found a post by Graeme Ellis and response by Ken McSwain. I was so pleased to find a way to deal with incrementing the eaddress_no in the T_EADDRESS table as it’s not created as an auto increment primary key. Now I know there’s a procedure to address this (ap_get_nextid_function). Below is a link to the post and I’m sure it will be helpful to you as well. I noticed that the marketing indicator is automatically set to ‘Y’ when running the script, which may or may not be an issue depending on the email addresses you’re appending. I think I’m off and running now and I hope this helps you as well!
http://www.tessituranetwork.com/COMMUNITY/forums/t/4333.aspx
Shereen Marino Data Analysis Manager | The Phoenix Symphony | Tel. 602-452-0414 | Fax. (602) 253-1772 SMarino@PHOENIXSYMPHONY.ORG | www.phoenixsymphony.org
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Frederick Sent: Tuesday, October 01, 2013 3:23 PM To: Shereen Marino Subject: RE: [Tessitura Technical Forum] Email Append
Hi Shereen,
We are in the midst of an email append as well. Our plan is to create a custom eaddress type, as you mentioned, to ensure it is clear that the address was acquired through research, not from the patron directly. Likewise, I will be a SQL script to load to T_EADDRESS, which will be a fairly simple query to write since we have customer_no in our returned research.
I think you are on the right track; of course, someone else may reply with some other interesting option! J
Thanks,
David
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Shereen Marino Sent: Tuesday, October 1, 2013 2:09 PM To: David Frederick Subject: [Tessitura Technical Forum] Email Append
Hello,
I've been asked to complete an email append in the very near future for our organization, TPS. We're the master license holder of a new consortium and are working through several projects in preparation for the first consortium merge - there are potentially 52K duplicate accounts currently. Additionally, our email addresses have not yet been moved off the General Tab. Tessitura will be contracted to assist with the pre-merge tasks and the consortium merge but not before this email append is due. As a result, there's the possibility that some of the append emails may be for patrons who have accounts not only with our organization but one or both of the other consortium members. What are my options for the email append (SQL scripts, utilities, etc.) and what might be the best strategy given the challenges of the consortium and many duplicate accounts? Would it make sense to create a new eaddress type for these append emails and use a SQL script to add them to the T_EADDRESS table? Is there a utility that would work better in this situation? I appreciate any suggestions you might have.
Thank you,
Shereen
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!