Hello,
Trying to get the scope of a potentially massive data hygiene project here at The Cleveland Orchestra. Is there a utility or protocol within tessitura currently that would allow me to upload some type of template with patron ID and update that patrons information automatically in one massive bulk upload. or is the only way this can be done is a patron by patron basis (i find that very hard to believe but anything is possible..). Any help would be greatly appreciated!
Carlo Claridad said: Is there a utility or protocol within tessitura currently that would allow me to upload some type of template with patron ID
You could perhaps fool the NCOA utility to upload your data, but that would likely be more trouble than it's worth; plus you're already using the NCOA util for NCOA updates, right? ;-)
Carlo Claridad said:or is the only way this can be done is a patron by patron basis (i find that very hard to believe but anything is possible..)
With SSMS and a little SQL code, anything is indeed possible. Nothing automated or built-in at this time, however. Sadly.