We have recently used a outside vendor to check the phone numbers in our database and now I have an excel list of 15,000 records with verified and updated phone numbers and phone types. I understand there is no standard utility to do this, and we certainly can't update them manually. I thought I'd ask to see if anyone out there in Tessitura land, has done this kind of a thing before? And how?
Thanks, Ida
We manually import our NCOA updates from a flat file, but it does require a significant amount of technical (SQL) know-how. I import the information first into a custom staging table using BCP, and then I have a second process that I use for updating the values in Tessitura.
If this is a one-time thing, and you don't have someone on staff comfortable with doing that sort of thing, you might consider Tessitura's consulting services. They're pretty reasonable, and should be able to do this kind of thing pretty quickly.
Got it, thanks!