NCOA data

We had a completely bespoke process that did something like this in the past, before the network created the "standard" method. (I'm on a train into NYC) does anyone know if there is a local procedire that is part of the NCOA process that could be updated to do something like this?

Even if there is not a local procedure. The standard process runs in two phases importation and application. Once the updates are staged to the database through the import process.

One could likely write a local procedure to
* go through the staging table
*duplicate the existing address that are about to be overwritten
* Label the copy of the existing address with a replaced by NCOA address type (so that you do not)re-verify this old address

Then run standard apply NCOA process with the existing report.

If anyone has done this I too would be interested.

--Tom

On Wed, Sep 23, 2015 at 9:30 AM, Claire Ryan wrote:

We run into this problem of the NCOA process overwriting our data, as well, and I like your idea of archiving the addresses first so we won't have to look in the audit. I wondered if anyone has been able to create such a procedure to before?
From: Travis Armbuster
Sent: 9/18/2015 9:55:39 AM

If you used the preferred vendor you can use the import utility.

Steps ( Search, "NCOA Processing Utility" in the documentation)

1. Place the file on the server and note the path and session number in the txt.

a.Check the actions on the NOCA system table to be sure they are correct (tr_nocalink_action)

2. Run the utility

If you did not use the preferred vendor your DB admin will have to do a custom script to import and update. One thing to note is the utility will not archive the addresses only update. So, if you want to keep the old addresses you will need to create some procedure to archive them before running the NCOA. As always run in test first.



Travis



This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing 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!

We have a simple archiving procedure. Email me off the forums and I will get you situated.

Travis

Hi Travis,

About to start the NCOA import and curious about your method for archiving current addresses so they are not overwritten. If you have script that would be dandy. Happy Thanksgiving!