Comments on: Create a new alert for a SharePoint list http://www.emptycache.com/blog/?p=67 a developer's blog Mon, 27 Apr 2009 06:44:01 -0500 http://wordpress.org/?v=2.8.2 hourly 1 By: SharePoint 2007’s problems « Huynhvothinh’s Weblog http://www.emptycache.com/blog/?p=67&cpage=1#comment-3214 SharePoint 2007’s problems « Huynhvothinh’s Weblog Wed, 04 Feb 2009 02:51:25 +0000 http://www.emptycache.com/blog/2008/04/17/create-a-new-alert-for-a-sharepoint-list/#comment-3214 [...] -http://www.emptycache.com/blog/2008/04/17/create-a-new-alert-for-a-sharepoint-list/ [...] [...] -http://www.emptycache.com/blog/2008/04/17/create-a-new-alert-for-a-sharepoint-list/ [...]

]]> By: Pamela Willox http://www.emptycache.com/blog/?p=67&cpage=1#comment-3209 Pamela Willox Fri, 26 Sep 2008 02:49:25 +0000 http://www.emptycache.com/blog/2008/04/17/create-a-new-alert-for-a-sharepoint-list/#comment-3209 Excellent post Adam. I hope you can help me! I've created an item event handler so that when someone posts an item to a list, an alert is created on that item (if it's the first post i.e fileSystemObjectType folder). It works well if it's a site administrator creating the item, but when it's a user with member permissions, I have a problem. When it tries to set the alert template name I get a permission denied error. I have tried to open the site with a user token to impersonate the site collection administrator but still having the same issue. Here is the method for the alert up to the point it fails: public void CreateAlert(SPWeb myWeb, SPList list, SPListItem item, string alertTitle, SPUser alertUser, bool notify) { try { SPUserToken siteAdminToken = GetUserToken(myWeb.Url.ToString(), "siteadmin"); using (SPSite site = new SPSite(myWeb.Site.ID, siteAdminToken)) { SPWeb alertsWeb = site.OpenWeb(myWeb.ID); SPList alertList = alertsWeb.Lists[list.ID]; SPListItem alertListItem = alertList.GetItemById(item.ID); SPAlertCollection alerts = alertsWeb.Alerts; // get the lists alert template and apply that to the new alert SPAlertTemplate alertTemplate = alertList.AlertTemplate; alertTemplate.Name = alertList.AlertTemplate.Name; ... } Can you shed any light? Regards, Pam Excellent post Adam. I hope you can help me!
I’ve created an item event handler so that when someone posts an item to a list, an alert is created on that item (if it’s the first post i.e fileSystemObjectType folder).
It works well if it’s a site administrator creating the item, but when it’s a user with member permissions, I have a problem. When it tries to set the alert template name
I get a permission denied error.

I have tried to open the site with a user token to impersonate the site collection administrator but still having the same issue.
Here is the method for the alert up to the point it fails:

public void CreateAlert(SPWeb myWeb, SPList list, SPListItem item, string alertTitle, SPUser alertUser, bool notify)
{
try
{
SPUserToken siteAdminToken = GetUserToken(myWeb.Url.ToString(), “siteadmin”);
using (SPSite site = new SPSite(myWeb.Site.ID, siteAdminToken))
{
SPWeb alertsWeb = site.OpenWeb(myWeb.ID);
SPList alertList = alertsWeb.Lists[list.ID];
SPListItem alertListItem = alertList.GetItemById(item.ID);
SPAlertCollection alerts = alertsWeb.Alerts;

// get the lists alert template and apply that to the new alert
SPAlertTemplate alertTemplate = alertList.AlertTemplate;
alertTemplate.Name = alertList.AlertTemplate.Name;
…
}

Can you shed any light?

Regards,
Pam

]]>