Any one have a script or SQL function for this? Pretty sure I can write one, but I'm sure to mess it up at least once. Hoping one already exists out in the world.
-Levi
I have this that might help.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Courtney Owen Sent: Friday, January 03, 2014 5:04 PM To: Gloria Ormsby Subject: Re: [Tessitura Technical Forum] easy way to update mail/email purposes en masse
Were you able to figure something out with this?
From: Levi Sauerbrei <bounce-levisauerbrei8271@tessituranetwork.com> Sent: 3/16/2011 3:08:26 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!
Let me just echo Brian's word of caution here. We had a lovely little SQL function that dealt neatly with mail purposes through v11. However, in v12 the world completely changes - and that way of storing purposes is now obsolete.
So if you use some sort of SQL to update this in pre-v12, know that you'll have to upgrade/change it for v12 and beyond.
- Heather