microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Stylesheet problem....help

Subject: Re: Stylesheet problem....help
From:
Date: 17 Jan 2006 10:15:16 -0800
Newsgroups: microsoft.public.sqlserver.notificationsvcs
OK - got it figured out.  I had my UTF encoding = 16 in my ICF and
changed it to utf-8 & this fixed it.


[email protected] wrote:
> My events are firing and my email alerts are arriving.  But all that
> arrives in the body of my message is the "<" character.  It's like it's
> not finding my stylesheet definition.  I just used the one from the
> template and replaced the field names with my fieldnames from my ADF.
> Below is my stylesheet & ADF <notificationclasses> section for
> debugging.  Can anyone help?
>
>
> <?xml version="1.0" encoding="UTF-8" ?>
> <xsl:stylesheet version="1.0"
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
>
>       <xsl:template match="notifications">
>
>               <html>
>                       <body>
>                               <xsl:apply-templates/>
>                               <i>Thank you for using this Notification 
> System.</i><br/>
>                               <b>The thing that you have subscribed to has 
> happened!</b><br/>
>                       </body>
>               </html>
>       </xsl:template>
>
>       <xsl:template match="notification">
>               Full Name : <b><xsl:value-of select="FullName" /></b><br/>
>               New Address Line 1 : <b><xsl:value-of select="AddressLine1"
> /></b><br/>
>               New Address Line 2 : <b><xsl:value-of select="AddressLine2"
> /></b><br/>
>               New City : <b><xsl:value-of select="City" /></b><br/>
>               New State : <b><xsl:value-of select="State" /></b><br/>
>               New Zip Code : <b><xsl:value-of select="Zip" /></b><br/>
>               <br/>
>       </xsl:template>
>
> </xsl:stylesheet>
>
>
>
> ---------------------------
>
>   <NotificationClasses>
>
>     <NotificationClass>
>       <NotificationClassName>
>         ChangeofAddressAlert
>       </NotificationClassName>
>       <Schema>
>         <Fields>
>         <Field>
>           <FieldName>RegistrationNumber</FieldName>
>           <FieldType>varchar(10)</FieldType>
>         </Field>
>         <Field>
>           <FieldName>FullName</FieldName>
>           <FieldType>varchar(30)</FieldType>
>         </Field>
>         <Field>
>           <FieldName>Date</FieldName>
>           <FieldType>datetime</FieldType>
>         </Field>
>         <Field>
>           <FieldName>AddressLine1</FieldName>
>           <FieldType>varchar(40)</FieldType>
>         </Field>
>         <Field>
>           <FieldName>AddressLine2</FieldName>
>           <FieldType>varchar(40)</FieldType>
>         </Field>
>         <Field>
>           <FieldName>City</FieldName>
>           <FieldType>varchar(24)</FieldType>
>         </Field>
>         <Field>
>           <FieldName>State</FieldName>
>           <FieldType>char(2)</FieldType>
>         </Field>
>         <Field>
>           <FieldName>Zip</FieldName>
>           <FieldType>varchar(9)</FieldType>
>         </Field>
>         </Fields>
>       </Schema>
>       <ContentFormatter>
>         <ClassName>XsltFormatter</ClassName>
>         <Arguments>
>           <Argument>
>             <Name>XsltBaseDirectoryPath</Name>
>             <Value>%_AppPath_%\stylesheets</Value>
>           </Argument>
>           <Argument>
>             <Name>XsltFileName</Name>
>             <Value>stylesheet.xslt</Value>
>           </Argument>
>         </Arguments>
>       </ContentFormatter>
>       <Protocols>
>         <Protocol>
>           <ProtocolName>SMTP</ProtocolName>
>           <Fields>
>             <Field>
>               <FieldName>Subject</FieldName>
>               <SqlExpression>'Your Notification'</SqlExpression>
>             </Field>
>             <Field>
>               <FieldName>From</FieldName>
>               <SqlExpression>'[email protected]'</SqlExpression>
>             </Field>
>             <Field>
>               <FieldName>To</FieldName>
>               <FieldReference>DeviceAddress</FieldReference>
>             </Field>
>             <Field>
>               <FieldName>Priority</FieldName>
>               <SqlExpression>'Normal'</SqlExpression>
>             </Field>
>             <Field>
>               <FieldName>BodyFormat</FieldName>
>               <SqlExpression>'html'</SqlExpression>
>             </Field>
>           </Fields>
>           <!--
>           <ProtocolExecutionSettings>
>             <RetrySchedule>
>               <RetryDelay>P0DT00H15M00S</RetryDelay>
>               <RetryDelay>P0DT00H30M00S</RetryDelay>
>               <RetryDelay>P0DT01H00M00S</RetryDelay>
>             </RetrySchedule>
>           </ProtocolExecutionSettings>
>           -->
>         </Protocol>
>       </Protocols>
>     </NotificationClass>


<Prev in Thread] Current Thread [Next in Thread>