Grouping Data for Consolidated Notification

We have a requirement where we need to send a single consolidated list
of items belonging to a user which get active on particular date.



So, for example Item 1, Item 2, Item 3 gets active. These entries are
inserted as Events. Now, we need to send single notification to the
user with the email as:

=========================

Dear User,



Your following items got active today:

Item 1

Item 2

Item 3



Thanks,

Customer Care

=========================



For this we set the DigestDelievery to true and the emails indeed were
consolidated. But, what it did was that it send single email
notification repeating the entire content for each item as follows:

=========================

Dear User,



Your following items got active today:

Item 1



Thanks,

Customer Care



Dear User,



Your following items got active today:

Item 2



Thanks,

Customer Care



Dear User,



Your following items got active today:

Item 3



Thanks,

Customer Care

=========================



Please let me know if we are missing any setting or any changes need
to be made in the .xslt for this to work.



regards,

Rajiv

On Sat, 21 Jul 2007 11:06:51 -0700, raj wrote:

> We have a requirement where we need to send a single consolidated list
> of items belonging to a user which get active on particular date.
>
>
>
> So, for example Item 1, Item 2, Item 3 gets active. These entries are
> inserted as Events. Now, we need to send single notification to the
> user with the email as:
>
> =========================
>
> Dear User,
>
>
>
> Your following items got active today:
>
> Item 1
>
> Item 2
>
> Item 3
>
>
>
> Thanks,
>
> Customer Care
>
> =========================
>
>
>
> For this we set the DigestDelievery to true and the emails indeed were
> consolidated. But, what it did was that it send single email
> notification repeating the entire content for each item as follows:
>
> =========================
>
> Dear User,
>
>
>
> Your following items got active today:
>
> Item 1
>
>
>
> Thanks,
>
> Customer Care
>
>
>
> Dear User,
>
>
>
> Your following items got active today:
>
> Item 2
>
>
>
> Thanks,
>
> Customer Care
>
>
>
> Dear User,
>
>
>
> Your following items got active today:
>
> Item 3
>
>
>
> Thanks,
>
> Customer Care
>
> =========================
>
>
>
> Please let me know if we are missing any setting or any changes need
> to be made in the .xslt for this to work.
>
>
>
> regards,
>
> Rajiv


Hi Rajiv -

From a SSNS perspective, it sounds like you have everything configured for
digest delivery properly. Since it's not being formatted the way you wish,
the issue is in the content formatter.

If you are using the built-in XSLT content formatter, try adjusting the
XSLTransform document.

Try placing the header and footer text directly in the XSLT document and
the notification data in an <xsl:template> Match on "notification".

HTH...

Joe


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