Does anyone know how to create an output element that would return only emails with a specific contact point purpose? Elements are tricky for me and I don't see anything that specific in the cookbook.
Hi Tara,
When you run the output set in Report/Utilities, Electronic Address Purpose is one of the variables you can fill in.
Susan
I want to create an output set to be used in WordFly
Did you ever get your output set to be used in Wordfly? I am hitting a similar issue and just starting to investigate using the outout set but have not yet done so.
---Arthur
I did, I had to work with our IT department (they had to do some digging too) to have them build a custom element that was the specific purpose I wanted to pull as Wordfly doesn't work so well with multiple options.
Are you able to ask your IT department to share the TR_QUERY_ELEMENT they set up for this purpose? I'm sure I could re-create it but may as well not reinvent the wheel...
Thanks
dgh
For a specific email contact point:
Category: Contact Preferences
Data Select: !.email
Data from: LV_Contact_Points
Data Where: !.purpose_id=7 and !.contact_point_cat_id = -2 and !.email_pri='Y'
Single row is checked.
I hope this helps!
Tara Uppman
Director of Development Operations
t 651.221.2515 | tuppman@smm.org
Science Museum of Minnesota
120 West Kellogg Boulevard | St. Paul, MN 55102
Turn on the science: Inspire learning. Inform policy. Improve lives.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Geoffrey HallSent: Sunday, July 17, 2016 11:15 PMTo: tuppman@smm.orgSubject: Re: [Tessitura Technical Forum] Creating output element that would return only emails with specific purpose
From: Tara Uppman <bounce-tarauppman1688@tessituranetwork.com>Sent: 7/8/2016 12:47:15 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!
SpamNot spamForget previous vote
Hi Tara, thanks for that.
i think the local view your query is referring to (LV_CONTACT_POINTS) must be custom - any chance you could share the CREATE script with me please?
Thank you
Hi Tara, thanks for that.i think the local view your query is referring to (LV_CONTACT_POINTS) must be custom - any chance you could share the CREATE script with me please?Thank youdghFrom: Tara Uppman <bounce-tarauppman1688@tessituranetwork.com>Sent: 7/18/2016 1:50:43 PMFor a specific email contact point:Category: Contact PreferencesData Select: !.emailData from: LV_Contact_PointsData Where: !.purpose_id=7 and !.contact_point_cat_id = -2 and !.email_pri='Y'Single row is checked. I hope this helps! Tara UppmanDirector of Development Operationst 651.221.2515 | tuppman@smm.orgScience Museum of Minnesota120 West Kellogg Boulevard | St. Paul, MN 55102Turn on the science: Inspire learning. Inform policy. Improve lives.From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Geoffrey HallSent: Sunday, July 17, 2016 11:15 PMTo: tuppman@smm.orgSubject: Re: [Tessitura Technical Forum] Creating output element that would return only emails with specific purpose Hi Tara,Are you able to ask your IT department to share the TR_QUERY_ELEMENT they set up for this purpose? I'm sure I could re-create it but may as well not reinvent the wheel...ThanksdghFrom: Tara Uppman <bounce-tarauppman1688@tessituranetwork.com>Sent: 7/8/2016 12:47:15 PMI did, I had to work with our IT department (they had to do some digging too) to have them build a custom element that was the specific purpose I wanted to pull as Wordfly doesn't work so well with multiple options.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!SpamNot spamForget previous voteThis 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! Spam Not spam Forget previous vote
From: Tara Uppman <bounce-tarauppman1688@tessituranetwork.com>Sent: 7/18/2016 1:50:43 PM
Hi Chris,
Could I also get the custom view create script? My email is gormsby@flynncenter.org. Thank you!
Gloria
I'd love to get the script for that view as well. We're just implementing WordFly and I'd like to include an element in our Output set that returns the email with the contact point purpose selected or the primary email if there isn't one with the contact point purpose.
Hi all, there's been lots of requests for this so I've uploaded it to my profile for easy access. This link should work: http://www.tessituranetwork.com/Community/members/davidgeoffreyhall6570/files/LV_5F00_CONTACT_5F00_POINTS_5F00_Science_5F00_Museum_5F00_MN.SQL.aspx
Thanks to Chris and the Science Museum of Minnesota!
Hi all
Realise this was posted awhile ago! But we're currently looking for this exact same thing and wondered if it would be possible to have the local view script shared with us? I've tried clicking on the link above but it's expired! Would you be happy to send this to: databaseteam@wmc.org.uk - we would be very grateful!
Chloe