Has anyone created a custom data element for a Ticket Header ticket design that will pull a specific salutation based on the alternate address selected in an order? I'm trying to rework the way we handle Corp/School/Org accounts in Tessitura and one issue is ticket headers and making sure the correct name and address appear on them. Ideally, we'd have a salutation type assigned to an address type. The specific address type is selected in the order as an alt address. I need to have the 'alt' salutation that goes with the address to appear on the ticket header instead of Name1 or Name2 information. Has anyone tackled this and is willing to share how to's with me?
Teresa
You should be able to do this without a custom element. The system elements Salutation1 and Salutation2 should pull the salutation from the address selected for the order.
Thanks Chuck. I saw that, but assumed it would pull the salutation from the general/default address. But now that someone says it, it makes sense it’d be from the specific address. I will give it a try and see what happens.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chuck Reif Sent: Thursday, May 05, 2011 4:02 PM To: Teresa Dean Subject: Re: [Tessitura Technical Forum] Ticket Design Custom Data Elements
From: Teresa Dean <bounce-teresadean9276@tessituranetwork.com> Sent: 5/5/2011 3:48:00 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!
Chuck,
I just tried this and it's pulling in the salutation from the general tab. I've verified that the address is a specific alt address, but it's not pulling in the appropriate salutation. Is there something else I should be doing?
Teresa,
There are a couple of other things to check. In the constituent address tab is the salutation type you are trying to use selected for the alternate address? If it is set to default you will only get the salutation from the general tab. You said you double checked the ticket order to make sure the alternate address was selected but that also needs to be selected. Finally did you check to make sure on the names tab there was a salutation with the salutation type that matches what is on the address?
I tested it and once I made sure I had all of those pieces it worked as expected per Chuck’s response.
Elizabeth Carlock
Director, Ticketing Services
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Teresa Dean Sent: Thursday, May 05, 2011 2:27 PM To: Elizabeth Carlock Subject: Re: [Tessitura Technical Forum] Ticket Design Custom Data Elements
From: Chuck Reif <bounce-chuckreif3941@tessituranetwork.com> Sent: 5/5/2011 4:00:04 PM
Teresa, There are a couple of other things to check. In the constituent address tab is the salutation type you are trying to use selected for the alternate address? If it is set to default you will only get the salutation from the general tab. You said you double checked the ticket order to make sure the alternate address was selected but that also needs to be selected. Finally did you check to make sure on the names tab there was a salutation with the salutation type that matches what is on the address? I tested it and once I made sure I had all of those pieces it worked as expected per Chuck’s response. Elizabeth Carlock Director, Ticketing Services From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Teresa Dean Sent: Thursday, May 05, 2011 2:27 PM To: Elizabeth Carlock Subject: Re: [Tessitura Technical Forum] Ticket Design Custom Data Elements Chuck, I just tried this and it's pulling in the salutation from the general tab. I've verified that the address is a specific alt address, but it's not pulling in the appropriate salutation. Is there something else I should be doing? Teresa From: Chuck Reif <bounce-chuckreif3941@tessituranetwork.com> Sent: 5/5/2011 4:00:04 PM You should be able to do this without a custom element. The system elements Salutation1 and Salutation2 should pull the salutation from the address selected for the order. 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! 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!
You might need to open a support ticket then. Do you by any chance have either of the following entries in T_DEFAULTS:
"ticket print label" with a value of 'Y' OR "ticket print sal type" with any value?
If so, then this could be overriding the behavior you are looking for.
I have neither of those entries at all in my t_defaults table. I'm going to open a ticket tonight and I guess work with someone tomorrow to figure out what I'm doing wrong. Thanks for the help.
Hi folks,
I'm having this issue where the ticket header is printing the default salutation and not the salutation associated with the alternate address selected for the order. The header design is using the Salutation1 and Salutation2 fields as suggested and there are no entries in T_DEFAULTS (that I can isolate) that would be affecting this behaviour.
I have tried searching TASK but can't find any recent solutions. Can anyone advise me on this?
Martin
Unknown said: I'm having this issue where the ticket header is printing the default salutation and not the salutation associated with the alternate address selected for the order. The header design is using the Salutation1 and Salutation2 fields as suggested and there are no entries in T_DEFAULTS (that I can isolate) that would be affecting this behaviour.
Your post reminds me of a custom ticket element I recently created at the request of our Group Sales folks. The code below could perhaps be modified to your needs, or provide inspiration in that direction. Feel free to e-mail me offline if I can help further.
-- #6: Group Sales "name" field, consisting of the org name if order owner is non-ind, Street2 if an ind
If @ude_no = 6
select @ude_value =
case
when c.cust_type in (1,7) -- ind or hhold -- select * from tr_cust_type
and a.street2 is not null
then left(a.street2,30) -- get the business/group name from street2
when c.cust_type not in (1,7) -- get the org name for schools, etc
then left(c.lname,30)
else left(cx.esal1_desc,30) -- if all else fails, get the sal
end
from T_ORDER o
join T_CUSTOMER c
on o.customer_no = c.customer_no
join TX_CUST_SAL cx
on o.customer_no = cx.customer_no and cx.default_ind = 'Y'
left join T_ADDRESS a
on o.address_no = a.address_no
where o.order_no = @order_no