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

Stylesheet problem....help

Subject: Stylesheet problem....help
From:
Date: 17 Jan 2006 08:57:44 -0800
Newsgroups: microsoft.public.sqlserver.notificationsvcs
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>