Greetings.
Brian from the Fulton Theatre.
I have been told by Marketing that moving forward all extractions for mailings need first name and last name in their own columns. I'm having some real difficulty getting this to work. I've even gone to another thread and attempted to do some system tables work but the directions are so old and there are fields not in tessitura.
I'm very new to this and I really need some help. Can anyone help me with this, please?
Thank you
B
I just uploaded a view that you might find useful for this: https://bitbucket.org/snippets/TN_WebShare/xAMK4j
We use this to define output set elements for mailings that have a mix of households and individuals. It outputs name1 fields for all constituents, and name2 fields for any households that have an A2 affiliate.
Hi Nick,
Could you provide the output set up that you did in system tables? I've successfully ran the code you provided but I'm now stuck since I'm unsure of what to setup in the system tables so that it appears as an output criteria!Thank you,
Katie Cullen
Sure:
- Start with a new row in TR_QUERY_ELEMENT_GROUP for the view (Data From = LV_CUSTOMER_A1A2). I call this "Constituent - Affiliate Details".
- Create rows in TR_QUERY_ELEMENT for each column in the view, like this:
(Ignore the rows for banner_id and class_year -- those are specific to my setup.)
You can check the Single Row column in this table for all elements.
That's it!