all groups > sql server notification services > april 2006 >
You're in the

sql server notification services

group:

Modifying E-Mail Format in Notification Workflow Applications


Modifying E-Mail Format in Notification Workflow Applications Pete Zerger
4/8/2006 12:00:00 AM
sql server notification services: Experts,

I am seeking a good resource where I can learn how to manipulate the e-mail
format in a Notification Services application. I am working with the MOM
Notification Workflow Solution Acclerator Application, which, stores this
infromation in an .xml file. Are the elements in this file standard to all
applications, or is the .xml schema customized for every notification services
application.

I have included a snapshot of this portion of the AppADF.xml file. In particular,
how can I make adjustments, such as changing text color or font in message
body, or modify what data is delivered in the message body. If nobody in
the group is familiar with this app, a pointer to some targeted reading would
be most appreciated.

<Protocols>
<Protocol>
<ProtocolName>SMTP</ProtocolName>
<Fields>
<Field>
<FieldName>Subject</FieldName>
<SqlExpression>Name</SqlExpression>
</Field>
<Field>
<FieldName>BodyFormat</FieldName>
<SqlExpression>'html'</SqlExpression>
</Field>
<Field>
<FieldName>From</FieldName>
<SqlExpression>'momalerts2@akosts.com'</SqlExpression>
</Field>
<Field>
<FieldName>Priority</FieldName>
<SqlExpression>'High'</SqlExpression>
</Field>
<Field>
<FieldName>To</FieldName>
<SqlExpression>SubscriberDeviceAddress</SqlExpression>
</Field>
</Fields>
</Protocol>

Kind Regards,

Pete Zerger MCSE(Messaging)
mail:pete.zerger@nospam.gmail.com
BLOG:http://www.it-jedi.net/

Re: Modifying E-Mail Format in Notification Workflow Applications Joe Webb
4/10/2006 12:00:00 AM
Are you opposed to using XSLT?

For extremely high volume systems, it can be somewhat of a resource
bottleneck. But for many systems it works very, very well.

HTH...



--
Joe Webb
SQL Server MVP
http://www.sqlns.com


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)



On Sat, 8 Apr 2006 07:10:31 +0000 (UTC), Pete Zerger
[quoted text, click to view]
AddThis Social Bookmark Button