I am curious how other organizations handle cleaning up new accounts from internet sales. In our old system we ran weekly new patron reports and manually cleaned up the data and we've carried that practice over to Tessitura. And as much fun as it is to go into each and every account to fix address formating or make their name and address the appropriate case (i.e. the customers who like to enter their info in all caps) I'd like to find a way that doesn't take so much time. Have any of you developed stored procedures to do some of this work?
Thanks!
There is a Shared Report from the Washington National Opera available in Task; it's number 99 in the Reference Materials section that cleans up addresses - you might want to take a look at that and modfy it for your needs.
Caryl
Thanks! I'll have to check that out.