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!

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!