Output cookbook question/help?

Hi Jennifer

From the error message you included it looks like LVS_ELEMENTS_PHONE has not been added to the database. This requires access to SQL Server not just Tessitura.

Since you don't have someone in your organisation with database access, please contact Tessitura Support and they will be able to help you with adding the View to your database.

As to why you have experienced some elements working and some don't. Not all the custom elements in the Cookbook use a custom View. Many elements use existing Views in the database, but when a custom view is required it needs to be added/created in the database so Tessitura Output Set element can access the data it produces.

A quick guide, whenever an element uses a custom View that needs to be added to the database, I include the code for it after the Tessitura setup details for the element. So when you see an element on the contents page that has View as a subhead - then custom code will need to be added to the database.

If you need any general help with Output Set elements - feel free to email me directly!

Regards
Sandra

Thank you, Sandra!

I am going to put the phones on my to-do later list because right now I need to get a handle on emails. I was able to add the multiple emails, but I don't understand how it works because I'm not able to get any of the email types I've selected under output filters. It seems if they are under the individual vs. household, even when I leave individual constituents on my list, they don't exactly show up on my list - but it's not consistent. Most of our specific emails, like Email hers/Email his (which is what we want) are under the individual and the login emails/primary are under HH. I've tested all different ways and it's not logical (to me anyway) 

Examples:

My record has the following:

• HH - Primary Email Address
• Mr. - Email (his)
• Mrs. - Email (hers) and Business

I have tried several ways to get all of these emails output and here is the result. The advanced relationship is to leave individual consistuents. 

Eaddress Multiple with no output filter
Result: I get Primary Email, Email (hers) and Mrs. Business. 

Eaddress Multiple with output filter to include Primary, Email (his), Email (hers) and business.
Result: Same as above!

Email (his) won't show up unless it's moved to HH.

When I changed the list to replace individuals with Primary HH I get only the HH primary, but when I move all individuals to HH I get them all. 

What am I missing with getting individuals email types, since it seems to work for some?

Thank you, Sandra!

I am going to put the phones on my to-do later list because right now I need to get a handle on emails. I was able to add the multiple emails, but I don't understand how it works because I'm not able to get any of the email types I've selected under output filters. It seems if they are under the individual vs. household, even when I leave individual constituents on my list, they don't exactly show up on my list - but it's not consistent. Most of our specific emails, like Email hers/Email his (which is what we want) are under the individual and the login emails/primary are under HH. I've tested all different ways and it's not logical (to me anyway) 

Examples:

My record has the following:

• HH - Primary Email Address
• Mr. - Email (his)
• Mrs. - Email (hers) and Business

I have tried several ways to get all of these emails output and here is the result. The advanced relationship is to leave individual consistuents. 

Eaddress Multiple with no output filter
Result: I get Primary Email, Email (hers) and Mrs. Business. 

Eaddress Multiple with output filter to include Primary, Email (his), Email (hers) and business.
Result: Same as above!

Email (his) won't show up unless it's moved to HH.

When I changed the list to replace individuals with Primary HH I get only the HH primary, but when I move all individuals to HH I get them all. 

What am I missing with getting individuals email types, since it seems to work for some?