NCOA Processing

We're starting to talk about getting this set up at the Science Museum...will let you know what we learn!  Do you have any specific questions?

I am having a meeting today on exactly that topic.  We have company names in Opt. Address as well and it has caused some trouble with the import file. Specifically, while that field allows 55 characters, the import file format only allows 30. So in some cases that field is too big which is preventing import. We are not using MBS, but I am using the utility to get the addresses in and out.

My suggestion for the company name at our location will be to add it to the second line of the salutation and leave the Opt. Address line blank unless it really is part of the address. 

I'll let you know if anything comes out of our user group discussion today.

Tom Brown,

Jon Slater of The Huntington Theatre here.  Thanks for speaking with me by telephone in December.  We are ready to take the plunge with MBS and hope to export a file tomorrow (1/29/10). 

I was a little bit concerned earlier today when I noticed in the export utility an optional parameter of Include Address Types.  I am presuming that leaving this blank will only export the primary address?  In my case this would be about 250,000 records.  If leaving this blank exports ALL addresses then the quantity will be much higher and the process will be more expensive than we anticipate.  Have any thoughts on this???

Thanks,

Jon

Hi Jon,

We just finished our first NCOA run with MBS (and overall things worked quite smoothly).  If anyone else wants to hear about our experiences we're happy to share.

To answer your question about the Include Address Types parameter, if you leave it blank it exports all addresses on the record, not just the primary.  The utility does not, however, export Inactive addresses.

Unknown said:

Tom Brown,

Jon Slater of The Huntington Theatre here.  Thanks for speaking with me by telephone in December.  We are ready to take the plunge with MBS and hope to export a file tomorrow (1/29/10). 

I was a little bit concerned earlier today when I noticed in the export utility an optional parameter of Include Address Types.  I am presuming that leaving this blank will only export the primary address?  In my case this would be about 250,000 records.  If leaving this blank exports ALL addresses then the quantity will be much higher and the process will be more expensive than we anticipate.  Have any thoughts on this???

Thanks,

Jon

 

Hi, we are just starting our first NCOA run with MBS.  We only like to export primary address.  What is the best way to accomplish that?

Best regards,

Diana

Yes, after reviewing the documentation and the NCOA utility, it does not appear to be a straight forward way to export only primary address, so I am trying to figure out the best work-around.

I really can't think of anything, but I'll let you know if any brilliant ideas pop into my head. 

Something to bear in mind if you do find a way to export only primary addresses: If your users run any of the Labels and Letters reports to generate a list of addresses for a mailing and use Mailing Date, Mailing Purpose, etc... they will probably pull addresses other than just the Primary Address and you won't necessarily be NCOA compliant.  Here at the museum we inactivate addresses we know are bad and that saves a bit on the cost of the NCOA processing.

Unknown said:

Yes, after reviewing the documentation and the NCOA utility, it does not appear to be a straight forward way to export only primary address, so I am trying to figure out the best work-around.

Shellie Sullivan with the Kansas City Repertory Theatre.  I would be very interested in hearing about your experience with NCOA.  I am getting ready to begin this process and we are also using MBS.  I'd be very appreciative of any advice you'd be willing to share including things to watch out for, potential problems, issues you ran into, etc. 

We are doing the phone update as well.  Did you also have MBS do this for you?  Did you do any tweaking of the standard code behind the scenes (for instance, to select only the primary addresses?)

Thanks for your wilingness to share your experiences concerning NCOA!

Shellie

One other thing I forgot to put in my last post, concerns the problems that Science Museum of  Minnesota encountered with the Opt address being wiped out.  Does the NCOA process actually delete old addresses - or does it rather just inactivate them and keep them in history?  I was thinking I could possibly pull the Opt Address field back in after I've run the process.    Thanks again for any information.

Shellie Sullivan

Kansas City Rep Theatre

Unknown said:

 Does the NCOA process actually delete old addresses - or does it rather just inactivate them and keep them in history?  I was thinking I could possibly pull the Opt Address field back in after I've run the process.    Thanks again for any information.

Shellie Sullivan

Kansas City Rep Theatre

The NCOA utility overwrites the address.  It does not create a new address and inactivate the old one.  However you can still see the old address in the audit trail (go to Transactions and select the Audit radio button).

Unknown said:

We are doing the phone update as well.  Did you also have MBS do this for you?  Did you do any tweaking of the standard code behind the scenes (for instance, to select only the primary addresses?)

Thanks for your wilingness to share your experiences concerning NCOA!

Shellie

We chose not to do the phone update so I can't answer any questions about that process.  We also did not tweak any of the code, just used it as is.  Technically the process was very straight forward and pretty seamless.  One thing we did that I would highly recommend was making a copy to our Test environment after pulling the export for NCOA.  That way when the files came back from MBS we could import them and then apply the changes into Test first rather than going straight to Production.

Let me know if you have any other questions.

This is a concern.  I know SQL well enough, I'm thinking I could create a table to store constituents with the optional address field along with the account id.  Then after I do the processing of the import data I could possibly pull these fields back in to the optional address field from my table based on the account id. 

I totally LOVE your advice about bringing this into TEST first.  That will be a great place for a trial run of this.  I'd feel better if the addresses were being made inactive - rather than overwritten.  All the more reason for doing the TEST run first.  Thanks so much for your help. 

Thanks so much, Beth.  I will probably take you up on your offer and give you a call next week.  I appreciate your willingness to take the time to talk to me.  Thanks!

Beth, 

I'm wondering how long the process took you to run.  I'm assuming you did this when your box office was closed?

Beth, 

I'm wondering how long the process took you to run.  I'm assuming you did this when your box office was closed?

Hi Shellie,

I can answer this one.  We have just over 400,000 records and it took about 30 minutes to process the changes from the staging table into the records themselves.  We did do it afterhours when the box office and call center were closed.  For fun, when we ran the update in our Stage system we tried to process some transactions at the same time and didn't have any trouble but did notice that the system was a bit sluggish so we felt safer making the changes when we weren't helping customers.

Kjersten

Unknown said:

Beth, 

I'm wondering how long the process took you to run.  I'm assuming you did this when your box office was closed?