Client Email Confirmations – text formatting

Wonderful, thanks Brian

Attached are the core sql procedures for you to look at.

Cheers

BWG

Thanks Brian,

There must be something in the way we are pulling this data out via the stored procedure, the html formatting is not appearing in the output.  Instead we have our text with a ton of html tags!

How/where is your html text being output?

Cheers

Kim

We put the html right in the content in Tessitura.

BRIAN WILBUR GRUNDSTROM | Database Administrator
SHAKESPEARE THEATRE COMPANY
Recipient of the 2012 Regional Theatre Tony Award®
516 Eighth Street, SE | Washington, DC 20003-2834
p 202.547.3230 ext. 2216 | c 917.952.7957
bwg@shakespearetheatre.org
www.shakespearetheatre.org
www.brianwilbur.com
2014|2015 SEASON •• Shakespeare’s AS YOU LIKE IT • Shakespeare’s  THE TEMPEST • Piron’s THE METROMANIACS • MAN OF LA MANCHA • Greig’s DUNSINANE • Molière’s TARTUFFE

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Mark Ridley
Sent: Friday, July 11, 2014 7:33 AM
To: Brian W. Grundstrom
Subject: Re: [Tessitura Technical Forum] Client Email Confirmations – text formatting

Hi
I have done things like this in the past within the sql calls

replace(interval_text,' / ',char(13)+char(10)) 
 
replace(html_text,'<HR>',char(13)+char(10) +replicate('-',60)+char(13)+char(10) )

The replace and replicate can be done in views so you can more easily split out from a single entry field an html and a text view of the field.

Mark

Hi all,

We have started using Tessitura for Schools bookings, and as part of this process we are sending email confirmations from the client.

We have created a Content Type called Performances Notes that is added at either Production Season or Performance level.  In the value for this Content Type we enter text about the performance and any special instructions for the Teacher.  Then, based on the performances within the order, these Performance Notes are displayed on the email confirmation.

We have found that this solution is limited in that we are not able format the text, it displays as one continuous string.  Therefore the notes don’t draw much attention and may not be read by the Teacher.

Has anyone found a way to present formatted text on email confirmations without hard coding this in the email template itself?  We only want to do simple formatting, probably using basic html tags, such as spacing, bold, italics etc.  The solution needs to be accessible to the Schools Booking team who will create the notes initially and update them if details change.

Thanks in advance,

Kim

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!

Click here to report this email as spam.

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!

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!

Wonderful, thanks Brian

Attached are the core sql procedures for you to look at.

Cheers

BWG

Thanks Brian,

There must be something in the way we are pulling this data out via the stored procedure, the html formatting is not appearing in the output.  Instead we have our text with a ton of html tags!

How/where is your html text being output?

Cheers

Kim

We put the html right in the content in Tessitura.

BRIAN WILBUR GRUNDSTROM | Database Administrator
SHAKESPEARE THEATRE COMPANY
Recipient of the 2012 Regional Theatre Tony Award®
516 Eighth Street, SE | Washington, DC 20003-2834
p 202.547.3230 ext. 2216 | c 917.952.7957
bwg@shakespearetheatre.org
www.shakespearetheatre.org
www.brianwilbur.com
2014|2015 SEASON •• Shakespeare’s AS YOU LIKE IT • Shakespeare’s  THE TEMPEST • Piron’s THE METROMANIACS • MAN OF LA MANCHA • Greig’s DUNSINANE • Molière’s TARTUFFE

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Mark Ridley
Sent: Friday, July 11, 2014 7:33 AM
To: Brian W. Grundstrom
Subject: Re: [Tessitura Technical Forum] Client Email Confirmations – text formatting

Hi
I have done things like this in the past within the sql calls

replace(interval_text,' / ',char(13)+char(10)) 
 
replace(html_text,'<HR>',char(13)+char(10) +replicate('-',60)+char(13)+char(10) )

The replace and replicate can be done in views so you can more easily split out from a single entry field an html and a text view of the field.

Mark

Hi all,

We have started using Tessitura for Schools bookings, and as part of this process we are sending email confirmations from the client.

We have created a Content Type called Performances Notes that is added at either Production Season or Performance level.  In the value for this Content Type we enter text about the performance and any special instructions for the Teacher.  Then, based on the performances within the order, these Performance Notes are displayed on the email confirmation.

We have found that this solution is limited in that we are not able format the text, it displays as one continuous string.  Therefore the notes don’t draw much attention and may not be read by the Teacher.

Has anyone found a way to present formatted text on email confirmations without hard coding this in the email template itself?  We only want to do simple formatting, probably using basic html tags, such as spacing, bold, italics etc.  The solution needs to be accessible to the Schools Booking team who will create the notes initially and update them if details change.

Thanks in advance,

Kim

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!

Click here to report this email as spam.

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!

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!