Now that we have the initiator and the recipient, how can I export that information. Example we have an event for education and we sell to the school and have the recipient as the teacher ( so we know what teacher this group order is for) or we have a household purchase a camp but we have the recipient as the child.
My goal would be to pull a list of those who purchased for "Camp" and then on the output set to create a roster so to speak. So I could see me selecting F_Name, L_Name, Recipient_Name, Recipient_No.
I found how I can pull a list on Role but not how I can get a list of the Owner and the Recipient for seats. I tried to create a query but my SQL isn't strong. So I got an error.
How would I get this information? Any other ways?
According to the Tessitura Table Structures documentation.
http://www.tessituranetwork.com/~/media/Documentation/System%20Administration/Tessitura_Table_Structures_V125.ashx
There appears to be no TR_Table describing these relationships
1.1.1. role tinyint NOT NULL
1=owner
2=initiator
4=recipient
3=owner/initiator
5=owner/recipient
6=initiator/recipient
7=owner/initiator/recipient
If you need to pull the strings from somewhere check out your tr_gooesoft_dropdown table.
My guess is that the Code number may be different on all instances of Tessitura. In our system the Code = 204 reflects the correct descriptions for the Owner/Initiator/Recipient.
I found this by looking in T_Keyword for the list options for
· Package History Role
· Ticket History Role
Hope this helps.
--Tom
…
718.724.8135
tbrown@BAM.org
From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Jan LaRocque Sent: Monday, December 05, 2016 2:30 PM To: Thomas Brown <tbrown@bam.org> Subject: RE: [Tessitura Marketing Forum] Output Sets V12 and Recipient, Initiator information
Is there a table that stores the codes for Roles/Initator? I cannot find one.
Thanks.
From: Ryan Rowell <bounce-ryanrowell5634@tessituranetwork.com> Sent: 4/3/2014 2:12:40 PM
Hi Dale,
I'm not Kevin, but happened across this and had an answer for you. Here are the List Manager role criteria options that I think you are looking for.
Contribution Constituent Role Package History Role Ticket History Role
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing 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!
Thank you, Tom. I'm going to save that for my Tess notes.
What I really want to get my hands on is the Cr Role in Contributions that indicates a soft credit. Soft credits have been a thorn in my side for a long time and a short cut to identify those would be really helpful. Does anyone know where that code comes from?
Thanks,
Jan
Hi ,
I hope your keeping well. I appreciate this is over 4 years after your above post, but this is still not something that is clear on our database.
I'm trying to use list manager to pull JUST OWNERS for all orders for a production. It was a schools event so most orders have an Owner and an Initiator.
I can see in the raw data in ticket history that there are two entries for each order:
- the entry for the Owner with a 'role' value of 5
- the entry for the Iniatior with a 'role' value of 2.
This does not seem to correspond with this table:
There are no role based keywords in our database, so I have to add this myself, but I'm struggling to understand what code values I should have for the role dropdown.
Your thoughts would be welcomed.
Many thanks,
Dara