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
Were you able to figure something out with this?
Hi Courtney,
An oldie but a goodie (from 2 jobs ago!)
I think in the end I manged to talk the users out of whatever it was they were planning in favor an alternative way of marking what they wanted. Honestly can't recall what the specifics were.
The tricksy bit was going to be figuring out how to insert a mail purpose value into something that already had some values marked. Since all 10 mail purposes are stored as a single string of characters in one field I wasn't excited about having to write some weird concatenation rules for over half a million address records.
I haven't looked in our test environment yet, but I'm excited to see how the contact purposes are handled.
- Levi
I had a feeling it was something that could not be done easily, but thanks for the follow-up!
We have a function that could possibly help you with this. I would be happy to share.
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
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