• Replies 12 replies
  • Subscribers 338 subscribers
  • Views 154 views
  • Users 0 members are here
Related

Quarterly data address hygiene

Tiffany Elliott (Past Member)
$organization

Hi,

I'm curious as to how many Tessitura clients are updating account records from address hygiene reports.  We get quarterly reports from TRG of people who have moved and I've been asked to investigate how we could update these records.  There are over 2000 records and instead of hiring a bunch of interns for data entry, I figured I would reach out to see if anyone else has a solution that has worked for them. 

It appears that the TRG file would need to be tweaked before I could update using the NCOA utility. 

 Anyone have any advice or experience with this?

  • $organization

    Hi Tiffany,

    I looked into this same thing a while ago before we decided to use the Tessitura recommended NCOA company MBS (though I think their name may have changed).
    Though I don't have an answer for you, I thought I'd post what notes I have from that in the off chance that something might prove useful to you. 

    Using TRG for NCOA

    TRG records do not appear to have the NCOA footnote tag which is required for importing into Tessitura. The address hygiene certificate 2 report does list what those footnotes are, however the files with the addresses don't appear to have that column included.

    The tables (for reference) involved in that are TX_NCOALINK_RESULT_ACTION and TR_NCOALINK_ACTION.

    TRG does their NCOA processing via Acxiom Corporation.

    Though the footnote is not included we may be able to simply associate the Good Moves, Bad Moves, and Undeliverable with the  TR_NCOALINK_ACTION table.

    Example

    Good Move = 1 (Match - New address returned. Record will be updated.)

    Bad Move = 2 (Matched but no new forwarding address returned. Record will not be updated. Do not mail.)

    Undeliverable = 4 (No address change was returned, and the address could not be standardized. Do not mail. )

    All other records could be imported with 3 (No address change was returned but the record will be updated with the standardized address.)

  • $organization

    I’ll add that we as an organization had used TRG in the past, however we now use Tessitura’s preferred vendor eBay Marketing (formerly to be MBS). They were great, fast, and VERY cost efficient. Doing the NCOA on our database of 400,000+ records took less than 30 minutes and the cost was almost nominal. It might be worth the effort look at using eBay instead of TRG.

     

    Randall A. Mitchell
    Director of Information Systems | The Phoenix Symphony | Tel. (602) 452-0440 | Mobile. (602) 796-9323 | Fax. (602) 253-1772
    RMitchell@PHOENIXSYMPHONY.ORG | www.phoenixsymphony.org

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Rowell
    Sent: Thursday, April 03, 2014 12:36 PM
    To: Randall A. Mitchell
    Subject: Re: [Tessitura Technical Forum] Quarterly data address hygiene

     

    Hi Tiffany,

    I looked into this same thing a while ago before we decided to use the Tessitura recommended NCOA company MBS (though I think their name may have changed).
    Though I don't have an answer for you, I thought I'd post what notes I have from that in the off chance that something might prove useful to you. 

    Using TRG for NCOA

    TRG records do not appear to have the NCOA footnote tag which is required for importing into Tessitura. The address hygiene certificate 2 report does list what those footnotes are, however the files with the addresses don't appear to have that column included.

    The tables (for reference) involved in that are TX_NCOALINK_RESULT_ACTION and TR_NCOALINK_ACTION.

    TRG does their NCOA processing via Acxiom Corporation.

    Though the footnote is not included we may be able to simply associate the Good Moves, Bad Moves, and Undeliverable with the  TR_NCOALINK_ACTION table.

    Example

    Good Move = 1 (Match - New address returned. Record will be updated.)

    Bad Move = 2 (Matched but no new forwarding address returned. Record will not be updated. Do not mail.)

    Undeliverable = 4 (No address change was returned, and the address could not be standardized. Do not mail. )

    All other records could be imported with 3 (No address change was returned but the record will be updated with the standardized address.)

    From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com>
    Sent: 4/3/2014 11:18:09 AM

    Hi,

    I'm curious as to how many Tessitura clients are updating account records from address hygiene reports.  We get quarterly reports from TRG of people who have moved and I've been asked to investigate how we could update these records.  There are over 2000 records and instead of hiring a bunch of interns for data entry, I figured I would reach out to see if anyone else has a solution that has worked for them. 

    It appears that the TRG file would need to be tweaked before I could update using the NCOA utility. 

     Anyone have any advice or experience with this?




    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!
  • $organization

    Tiffany -

     

    We are a TRG customer and we update our addresses from the hygiene reports.  In the process, we modify the returned data to meet our data entry standards and then use the Tessitura NCOA process report to complete.

     

    Jackie Guy

    CSO

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Rowell
    Sent: Thursday, April 03, 2014 2:35 PM
    To: Guy, Jackie
    Subject: Re: [Tessitura Technical Forum] Quarterly data address hygiene

     

    Hi Tiffany,

    I looked into this same thing a while ago before we decided to use the Tessitura recommended NCOA company MBS (though I think their name may have changed).
    Though I don't have an answer for you, I thought I'd post what notes I have from that in the off chance that something might prove useful to you. 

    Using TRG for NCOA

    TRG records do not appear to have the NCOA footnote tag which is required for importing into Tessitura. The address hygiene certificate 2 report does list what those footnotes are, however the files with the addresses don't appear to have that column included.

    The tables (for reference) involved in that are TX_NCOALINK_RESULT_ACTION and TR_NCOALINK_ACTION.

    TRG does their NCOA processing via Acxiom Corporation.

    Though the footnote is not included we may be able to simply associate the Good Moves, Bad Moves, and Undeliverable with the  TR_NCOALINK_ACTION table.

    Example

    Good Move = 1 (Match - New address returned. Record will be updated.)

    Bad Move = 2 (Matched but no new forwarding address returned. Record will not be updated. Do not mail.)

    Undeliverable = 4 (No address change was returned, and the address could not be standardized. Do not mail. )

    All other records could be imported with 3 (No address change was returned but the record will be updated with the standardized address.)

    From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com>
    Sent: 4/3/2014 11:18:09 AM

    Hi,

    I'm curious as to how many Tessitura clients are updating account records from address hygiene reports.  We get quarterly reports from TRG of people who have moved and I've been asked to investigate how we could update these records.  There are over 2000 records and instead of hiring a bunch of interns for data entry, I figured I would reach out to see if anyone else has a solution that has worked for them. 

    It appears that the TRG file would need to be tweaked before I could update using the NCOA utility. 

     Anyone have any advice or experience with this?




    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!



  • $organization

    Thanks to both of you.

    Yes, Randall, we do use MBS/ebay Marketing for NCOA once a year, but we are also using TRG for other data and mailhouse projects.  As a courtesy, they provide us with a hygiene report 5 times a year.  Ideally, I would like to be able to use this list to update our database so we wouldn’t need to wait until the NCOA to update our records. 

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Randall Mitchell
    Sent: Thursday, April 03, 2014 4:06 PM
    To: Tiffany Evans
    Subject: RE: [Tessitura Technical Forum] Quarterly data address hygiene

     

    I’ll add that we as an organization had used TRG in the past, however we now use Tessitura’s preferred vendor eBay Marketing (formerly to be MBS). They were great, fast, and VERY cost efficient. Doing the NCOA on our database of 400,000+ records took less than 30 minutes and the cost was almost nominal. It might be worth the effort look at using eBay instead of TRG.

     

    Randall A. Mitchell
    Director of Information Systems | The Phoenix Symphony | Tel. (602) 452-0440 | Mobile. (602) 796-9323 | Fax. (602) 253-1772
    RMitchell@PHOENIXSYMPHONY.ORG | www.phoenixsymphony.org

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Rowell
    Sent: Thursday, April 03, 2014 12:36 PM
    To: Randall A. Mitchell
    Subject: Re: [Tessitura Technical Forum] Quarterly data address hygiene

     

    Hi Tiffany,

    I looked into this same thing a while ago before we decided to use the Tessitura recommended NCOA company MBS (though I think their name may have changed).
    Though I don't have an answer for you, I thought I'd post what notes I have from that in the off chance that something might prove useful to you. 

    Using TRG for NCOA

    TRG records do not appear to have the NCOA footnote tag which is required for importing into Tessitura. The address hygiene certificate 2 report does list what those footnotes are, however the files with the addresses don't appear to have that column included.

    The tables (for reference) involved in that are TX_NCOALINK_RESULT_ACTION and TR_NCOALINK_ACTION.

    TRG does their NCOA processing via Acxiom Corporation.

    Though the footnote is not included we may be able to simply associate the Good Moves, Bad Moves, and Undeliverable with the  TR_NCOALINK_ACTION table.

    Example

    Good Move = 1 (Match - New address returned. Record will be updated.)

    Bad Move = 2 (Matched but no new forwarding address returned. Record will not be updated. Do not mail.)

    Undeliverable = 4 (No address change was returned, and the address could not be standardized. Do not mail. )

    All other records could be imported with 3 (No address change was returned but the record will be updated with the standardized address.)

    From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com>
    Sent: 4/3/2014 11:18:09 AM

    Hi,

    I'm curious as to how many Tessitura clients are updating account records from address hygiene reports.  We get quarterly reports from TRG of people who have moved and I've been asked to investigate how we could update these records.  There are over 2000 records and instead of hiring a bunch of interns for data entry, I figured I would reach out to see if anyone else has a solution that has worked for them. 

    It appears that the TRG file would need to be tweaked before I could update using the NCOA utility. 

     Anyone have any advice or experience with this?




    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!

     
     
     
     
     
     
     
     
     




    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!

  • $organization in reply to Jackie Guy

    Oh Jackie, that's good to hear!

    Do you modify the returned data manually or do you have a procedure that does it for you?  How do you use the NCOA process to complete it when there are columns that appear to be missing? 

     

  • $organization in reply to Tiffany Elliott (Past Member)

    We're embarking on a data hygiene project, so forgive the "newbie" questions...

    What is the difference in Experian QAS (which there is now a TNEW integration for) and the other companies mentioned - TRG and MBS/eBay Marketing?  I spoke to a QAS rep yesterday and he talked about doing a de-dup cleanup to reduce our duplicate accounts, as well as address verification.  Is that similar to what TRG and MBS/eBay do?

    Any info is greatly appreciated!

  • $organization

    We vetted QAS, TRG and eBay/MBS when we looked at doing NCOA for our consortium. In essence the “product” that you will get is pretty much all the same; updated addresses and phone records. There is some spin that each put on, but it essentially all is the same product. The biggest difference, or the qualifier for us, was the price. It was a substantial difference. I’d suggest first obtaining the number of records by doing the NCOA Export Utility from Tessitura Test (after a Live to Test of course), and use that number to get price quotes from the three. You might be surprised at the huge discrepancy in amounts– we definitely were.

     

    Randall A. Mitchell
    Director of Information Systems | The Phoenix Symphony | Tel. (602) 452-0440 | Mobile. (602) 796-9323 | Fax. (602) 253-1772
    RMitchell@PHOENIXSYMPHONY.ORG | www.phoenixsymphony.org

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Marley Wynne
    Sent: Thursday, April 03, 2014 2:49 PM
    To: Randall A. Mitchell
    Subject: RE: [Tessitura Technical Forum] Quarterly data address hygiene

     

    We're embarking on a data hygiene project, so forgive the "newbie" questions...

    What is the difference in Experian QAS (which there is now a TNEW integration for) and the other companies mentioned - TRG and MBS/eBay Marketing?  I spoke to a QAS rep yesterday and he talked about doing a de-dup cleanup to reduce our duplicate accounts, as well as address verification.  Is that similar to what TRG and MBS/eBay do?

    Any info is greatly appreciated!

    From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com>
    Sent: 4/3/2014 3:26:20 PM

    Oh Jackie, that's good to hear!

    Do you modify the returned data manually or do you have a procedure that does it for you?  How do you use the NCOA process to complete it when there are columns that appear to be missing? 

     




    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!
  • $organization

    I apologize for the delayed response.  We modify the data programmatically using the following steps:

     

    NCOA PROCESS STEPS

    1. Load Export/Import into T_NCOA_SESSION

    2. LOAD data into TW_NCOA_INCOMING TBL

    3. REMOVE ANY NON-USA ADDRESSES

    4. Move APT to line 2

    5. Remove VIPs

    6. Run puncuation/address update

    7. Remove undeliverable restriction

    8. RUN NCOA PROCESS REPORT THROUGH TESSITURA

     

    The ncoa_foot is the only column that is needed.  Let me know if you need specifics.  I have provided my contact information below if needed.

     

     

    Jackie Guy

    Sr. Systems/Database Administrator

    Chicago Symphony Orchestra

    312.294.3318

    guyj@cso.org

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tiffany Evans
    Sent: Thursday, April 03, 2014 3:42 PM
    To: Guy, Jackie
    Subject: RE: [Tessitura Technical Forum] Quarterly data address hygiene

     

    Oh Jackie, that's good to hear!

    Do you modify the returned data manually or do you have a procedure that does it for you?  How do you use the NCOA process to complete it when there are columns that appear to be missing? 

     

    From: Jackie Guy <bounce-jacquelineguy8869@tessituranetwork.com>
    Sent: 4/3/2014 3:17:26 PM

    Tiffany -

     

    We are a TRG customer and we update our addresses from the hygiene reports.  In the process, we modify the returned data to meet our data entry standards and then use the Tessitura NCOA process report to complete.

     

    Jackie Guy

    CSO

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Rowell
    Sent: Thursday, April 03, 2014 2:35 PM
    To: Guy, Jackie
    Subject: Re: [Tessitura Technical Forum] Quarterly data address hygiene

     

    Hi Tiffany,

    I looked into this same thing a while ago before we decided to use the Tessitura recommended NCOA company MBS (though I think their name may have changed).
    Though I don't have an answer for you, I thought I'd post what notes I have from that in the off chance that something might prove useful to you. 

    Using TRG for NCOA

    TRG records do not appear to have the NCOA footnote tag which is required for importing into Tessitura. The address hygiene certificate 2 report does list what those footnotes are, however the files with the addresses don't appear to have that column included.

    The tables (for reference) involved in that are TX_NCOALINK_RESULT_ACTION and TR_NCOALINK_ACTION.

    TRG does their NCOA processing via Acxiom Corporation.

    Though the footnote is not included we may be able to simply associate the Good Moves, Bad Moves, and Undeliverable with the  TR_NCOALINK_ACTION table.

    Example

    Good Move = 1 (Match - New address returned. Record will be updated.)

    Bad Move = 2 (Matched but no new forwarding address returned. Record will not be updated. Do not mail.)

    Undeliverable = 4 (No address change was returned, and the address could not be standardized. Do not mail. )

    All other records could be imported with 3 (No address change was returned but the record will be updated with the standardized address.)

    From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com>
    Sent: 4/3/2014 11:18:09 AM

    Hi,

    I'm curious as to how many Tessitura clients are updating account records from address hygiene reports.  We get quarterly reports from TRG of people who have moved and I've been asked to investigate how we could update these records.  There are over 2000 records and instead of hiring a bunch of interns for data entry, I figured I would reach out to see if anyone else has a solution that has worked for them. 

    It appears that the TRG file would need to be tweaked before I could update using the NCOA utility. 

     Anyone have any advice or experience with this?




    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!

     




    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!



  • $organization

    This is great, Jackie.

     

    I’ll try and change the code to these and see how it goes!  (In Test first, of course…)

    I will contact you if I have any issues leaving me scratching my head.  I appreciate your help! J

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jackie Guy
    Sent: Wednesday, April 09, 2014 1:05 PM
    To: Tiffany Evans
    Subject: RE: [Tessitura Technical Forum] Quarterly data address hygiene

     

    I apologize for the delayed response.  We modify the data programmatically using the following steps:

     

    NCOA PROCESS STEPS

    1. Load Export/Import into T_NCOA_SESSION

    2. LOAD data into TW_NCOA_INCOMING TBL

    3. REMOVE ANY NON-USA ADDRESSES

    4. Move APT to line 2

    5. Remove VIPs

    6. Run puncuation/address update

    7. Remove undeliverable restriction

    8. RUN NCOA PROCESS REPORT THROUGH TESSITURA

     

    The ncoa_foot is the only column that is needed.  Let me know if you need specifics.  I have provided my contact information below if needed.

     

     

    Jackie Guy

    Sr. Systems/Database Administrator

    Chicago Symphony Orchestra

    312.294.3318

    guyj@cso.org

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tiffany Evans
    Sent: Thursday, April 03, 2014 3:42 PM
    To: Guy, Jackie
    Subject: RE: [Tessitura Technical Forum] Quarterly data address hygiene

     

    Oh Jackie, that's good to hear!

    Do you modify the returned data manually or do you have a procedure that does it for you?  How do you use the NCOA process to complete it when there are columns that appear to be missing? 

     

    From: Jackie Guy <bounce-jacquelineguy8869@tessituranetwork.com>
    Sent: 4/3/2014 3:17:26 PM

    Tiffany -

     

    We are a TRG customer and we update our addresses from the hygiene reports.  In the process, we modify the returned data to meet our data entry standards and then use the Tessitura NCOA process report to complete.

     

    Jackie Guy

    CSO

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Rowell
    Sent: Thursday, April 03, 2014 2:35 PM
    To: Guy, Jackie
    Subject: Re: [Tessitura Technical Forum] Quarterly data address hygiene

     

    Hi Tiffany,

    I looked into this same thing a while ago before we decided to use the Tessitura recommended NCOA company MBS (though I think their name may have changed).
    Though I don't have an answer for you, I thought I'd post what notes I have from that in the off chance that something might prove useful to you. 

    Using TRG for NCOA

    TRG records do not appear to have the NCOA footnote tag which is required for importing into Tessitura. The address hygiene certificate 2 report does list what those footnotes are, however the files with the addresses don't appear to have that column included.

    The tables (for reference) involved in that are TX_NCOALINK_RESULT_ACTION and TR_NCOALINK_ACTION.

    TRG does their NCOA processing via Acxiom Corporation.

    Though the footnote is not included we may be able to simply associate the Good Moves, Bad Moves, and Undeliverable with the  TR_NCOALINK_ACTION table.

    Example

    Good Move = 1 (Match - New address returned. Record will be updated.)

    Bad Move = 2 (Matched but no new forwarding address returned. Record will not be updated. Do not mail.)

    Undeliverable = 4 (No address change was returned, and the address could not be standardized. Do not mail. )

    All other records could be imported with 3 (No address change was returned but the record will be updated with the standardized address.)

    From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com>
    Sent: 4/3/2014 11:18:09 AM

    Hi,

    I'm curious as to how many Tessitura clients are updating account records from address hygiene reports.  We get quarterly reports from TRG of people who have moved and I've been asked to investigate how we could update these records.  There are over 2000 records and instead of hiring a bunch of interns for data entry, I figured I would reach out to see if anyone else has a solution that has worked for them. 

    It appears that the TRG file would need to be tweaked before I could update using the NCOA utility. 

     Anyone have any advice or experience with this?




    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!

     




    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!

     




    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!

  • $organization

    I can share our code if you need ideas.  Note the Ncoa_foot value will come from your TX_NCOALINK_RESULT_ACTION system table.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tiffany Evans
    Sent: Friday, April 11, 2014 9:48 AM
    To: Guy, Jackie
    Subject: RE: [Tessitura Technical Forum] Quarterly data address hygiene

     

    This is great, Jackie.

     

    I’ll try and change the code to these and see how it goes!  (In Test first, of course…)

    I will contact you if I have any issues leaving me scratching my head.  I appreciate your help! J

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jackie Guy
    Sent: Wednesday, April 09, 2014 1:05 PM
    To: Tiffany Evans
    Subject: RE: [Tessitura Technical Forum] Quarterly data address hygiene

     

    I apologize for the delayed response.  We modify the data programmatically using the following steps:

     

    NCOA PROCESS STEPS

    1. Load Export/Import into T_NCOA_SESSION

    2. LOAD data into TW_NCOA_INCOMING TBL

    3. REMOVE ANY NON-USA ADDRESSES

    4. Move APT to line 2

    5. Remove VIPs

    6. Run puncuation/address update

    7. Remove undeliverable restriction

    8. RUN NCOA PROCESS REPORT THROUGH TESSITURA

     

    The ncoa_foot is the only column that is needed.  Let me know if you need specifics.  I have provided my contact information below if needed.

     

     

    Jackie Guy

    Sr. Systems/Database Administrator

    Chicago Symphony Orchestra

    312.294.3318

    guyj@cso.org

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tiffany Evans
    Sent: Thursday, April 03, 2014 3:42 PM
    To: Guy, Jackie
    Subject: RE: [Tessitura Technical Forum] Quarterly data address hygiene

     

    Oh Jackie, that's good to hear!

    Do you modify the returned data manually or do you have a procedure that does it for you?  How do you use the NCOA process to complete it when there are columns that appear to be missing? 

     

    From: Jackie Guy <bounce-jacquelineguy8869@tessituranetwork.com>
    Sent: 4/3/2014 3:17:26 PM

    Tiffany -

     

    We are a TRG customer and we update our addresses from the hygiene reports.  In the process, we modify the returned data to meet our data entry standards and then use the Tessitura NCOA process report to complete.

     

    Jackie Guy

    CSO

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Rowell
    Sent: Thursday, April 03, 2014 2:35 PM
    To: Guy, Jackie
    Subject: Re: [Tessitura Technical Forum] Quarterly data address hygiene

     

    Hi Tiffany,

    I looked into this same thing a while ago before we decided to use the Tessitura recommended NCOA company MBS (though I think their name may have changed).
    Though I don't have an answer for you, I thought I'd post what notes I have from that in the off chance that something might prove useful to you. 

    Using TRG for NCOA

    TRG records do not appear to have the NCOA footnote tag which is required for importing into Tessitura. The address hygiene certificate 2 report does list what those footnotes are, however the files with the addresses don't appear to have that column included.

    The tables (for reference) involved in that are TX_NCOALINK_RESULT_ACTION and TR_NCOALINK_ACTION.

    TRG does their NCOA processing via Acxiom Corporation.

    Though the footnote is not included we may be able to simply associate the Good Moves, Bad Moves, and Undeliverable with the  TR_NCOALINK_ACTION table.

    Example

    Good Move = 1 (Match - New address returned. Record will be updated.)

    Bad Move = 2 (Matched but no new forwarding address returned. Record will not be updated. Do not mail.)

    Undeliverable = 4 (No address change was returned, and the address could not be standardized. Do not mail. )

    All other records could be imported with 3 (No address change was returned but the record will be updated with the standardized address.)

    From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com>
    Sent: 4/3/2014 11:18:09 AM

    Hi,

    I'm curious as to how many Tessitura clients are updating account records from address hygiene reports.  We get quarterly reports from TRG of people who have moved and I've been asked to investigate how we could update these records.  There are over 2000 records and instead of hiring a bunch of interns for data entry, I figured I would reach out to see if anyone else has a solution that has worked for them. 

    It appears that the TRG file would need to be tweaked before I could update using the NCOA utility. 

     Anyone have any advice or experience with this?




    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!

     




    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!

     




    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!




    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!



  • $organization

    Hello,
    I'm currently trying to update NCOA addresses coming from TRG into Tessitura. The import data file asks for a Session Number in the first column. Is that the job number from the Hygiene Certification 2? Or does the session number lurk somewhere within Tessitura like the address numbers?
    Thank you,
    Jane Esterquest

    Marketing Assistant, Celebrity Series of Boston 

  • $organization in reply to Jane Esterquest (Past Member)

    Hi Jane, 

    The session number is generated when you do the NCOA export from Tessitura and is required when importing. I haven't looked into it enough to know if there is an export table somewhere that references this on a patron by patron level when you are doing the import, or if you simply just need to export a single record to be able to utilize that session ID. Never got that far when trying to work with the TRG data.