{"id":212,"date":"2010-08-01T20:49:04","date_gmt":"2010-08-01T20:49:04","guid":{"rendered":"http:\/\/www.myfatblog.co.uk\/?p=212"},"modified":"2010-08-01T20:50:23","modified_gmt":"2010-08-01T20:50:23","slug":"task-alerts-not-firing-in-new-site-from-content-migration","status":"publish","type":"post","link":"http:\/\/www.myfatblog.co.uk\/index.php\/2010\/08\/task-alerts-not-firing-in-new-site-from-content-migration\/","title":{"rendered":"Task alerts not firing in new site from Content Migration."},"content":{"rendered":"

Whilst working with a client recently we decided to use the Content Migration system within SharePoint to allow us to create a template site that could then be used as the source for the 88 sites that needed to be created for each of the areas of interest.<\/p>\n

Each site had identical set-up with regards to security and the groups involved, the data merely changed by geographical location, with each site representing a postal district. As the custom webparts all triggered from data such as the site title for their geo-location data, this provided us with the best mechanism for creating the structure.<\/p>\n

During the UAT period however we did experience one problem that I didn\u00e2\u20ac\u2122t expect, This related to task creation and the automatic notifications sent to users. In our template site, we created a standard out of the box task list and turned on the \u00e2\u20ac\u02dcNotify on Task Assignment\u00e2\u20ac\u2122 option.<\/p>\n

\"image\"<\/a> <\/p>\n

This worked as expected in test, but during the migration something happened to the alerts and none of the 88 sites sent alerts when tasks were created.<\/p>\n

The first thing I do when task alerts aren\u00e2\u20ac\u2122t working is to set-up an \u00e2\u20ac\u02dcAlert me\u00e2\u20ac\u2122 on a list or document library. When this is done you immediately receive notification that this has been done, so this shows that the SMTP is configured correctly. Then creating a new item triggers the second alert (Be aware of the timer delay though, alerts may take up to 5 minutes to be triggered as this runs on a default 5 minute timer. (Which can be changed..))<\/p>\n

In this instance, these tests worked ok. So, now knowing that the infrastructure was ok, I started thinking about how SharePoint handles this kind of alert. In alert parlance, these Task alerts are called immediate scheduled alerts, as opposed to the daily round up or journal alerts. When an alert such as this is created, an entry is made in the dbo.ImmedSubscriptions table.<\/p>\n

\n

WARNING: Doing any kind of querying into the SQL databases of SharePoint is NOT supported and this was done for investigative purposes only. I would recommend only doing this when all else fails OR, Microsoft tell you to do it!<\/strong><\/em><\/p>\n<\/blockquote>\n

\"image\"<\/a> <\/p>\n

In my test system, I created a new site collection and then a new tasks list. Initially for this site, task alerts were off so the ImmedSubscriptions table was empty. However after editing the properties of the tasks list and turning on E-mail notifications, the following data appeared in the content-db.<\/p>\n

\"image\"<\/a> <\/p>\n

The key areas of information that we\u00e2\u20ac\u2122re interested in are shown above, Primarily the Site and Web urls, the list name and most importantly the AlertTemplateName (SPAlertTemplateType.AssignedToNotification) and the filter that applies the alert.<\/p>\n

In the case of the sites for my client, this data did not appear for any of the sites created from the Content Migration Package and we can therefore assume that when creating these sites, alerts do NOT get processed in the normal way.<\/p>\n

The fix is simple, turn off the alerts and turn them on again, this creates the entry and alerts start working as expected. moving forward, we\u00e2\u20ac\u2122ve now created a quick powershell script than turns Alerts off and back on again after the site is created using the SPList object and the EnableAssignToEmail property.<\/p>\n

Paul.<\/p>\n","protected":false},"excerpt":{"rendered":"

Whilst working with a client recently we decided to use the Content Migration system within SharePoint to allow us to create a template site that could then be used as the source for the 88 sites that needed to be created for each of the areas of interest. Each site had identical set-up with regards … <\/p>\n

Continue reading<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[16,6,28,36,20],"tags":[],"yoast_head":"\nTask alerts not firing in new site from Content Migration. - Blog of an overweight SharePoint addict<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.myfatblog.co.uk\/index.php\/2010\/08\/task-alerts-not-firing-in-new-site-from-content-migration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Task alerts not firing in new site from Content Migration. - Blog of an overweight SharePoint addict\" \/>\n<meta property=\"og:description\" content=\"Whilst working with a client recently we decided to use the Content Migration system within SharePoint to allow us to create a template site that could then be used as the source for the 88 sites that needed to be created for each of the areas of interest. Each site had identical set-up with regards … Continue reading\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.myfatblog.co.uk\/index.php\/2010\/08\/task-alerts-not-firing-in-new-site-from-content-migration\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog of an overweight SharePoint addict\" \/>\n<meta property=\"article:published_time\" content=\"2010-08-01T20:49:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2010-08-01T20:50:23+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/TaskalertsnotfiringinnewsitefromContent_131C2\/image_thumb.png\" \/>\n<meta name=\"author\" content=\"Cimares\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@cimares\" \/>\n<meta name=\"twitter:site\" content=\"@cimares\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Cimares\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.myfatblog.co.uk\/index.php\/2010\/08\/task-alerts-not-firing-in-new-site-from-content-migration\/\",\"url\":\"http:\/\/www.myfatblog.co.uk\/index.php\/2010\/08\/task-alerts-not-firing-in-new-site-from-content-migration\/\",\"name\":\"Task alerts not firing in new site from Content Migration. - Blog of an overweight SharePoint addict\",\"isPartOf\":{\"@id\":\"http:\/\/www.myfatblog.co.uk\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/www.myfatblog.co.uk\/index.php\/2010\/08\/task-alerts-not-firing-in-new-site-from-content-migration\/#primaryimage\"},\"image\":{\"@id\":\"http:\/\/www.myfatblog.co.uk\/index.php\/2010\/08\/task-alerts-not-firing-in-new-site-from-content-migration\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/TaskalertsnotfiringinnewsitefromContent_131C2\/image_thumb.png\",\"datePublished\":\"2010-08-01T20:49:04+00:00\",\"dateModified\":\"2010-08-01T20:50:23+00:00\",\"author\":{\"@id\":\"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/55ae8f6885bb5b8390dad001f3da83c6\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.myfatblog.co.uk\/index.php\/2010\/08\/task-alerts-not-firing-in-new-site-from-content-migration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/www.myfatblog.co.uk\/index.php\/2010\/08\/task-alerts-not-firing-in-new-site-from-content-migration\/#primaryimage\",\"url\":\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/TaskalertsnotfiringinnewsitefromContent_131C2\/image_thumb.png\",\"contentUrl\":\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/TaskalertsnotfiringinnewsitefromContent_131C2\/image_thumb.png\"},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/www.myfatblog.co.uk\/#website\",\"url\":\"http:\/\/www.myfatblog.co.uk\/\",\"name\":\"Blog of an overweight SharePoint addict\",\"description\":\"The rantings of a (not so) food obsessed IT consultant!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/www.myfatblog.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/55ae8f6885bb5b8390dad001f3da83c6\",\"name\":\"Cimares\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/About_D057\/TopOfTheWorld.jpg\",\"contentUrl\":\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/About_D057\/TopOfTheWorld.jpg\",\"caption\":\"Cimares\"},\"sameAs\":[\"http:\/\/www.myfatblog.co.uk\"],\"url\":\"http:\/\/www.myfatblog.co.uk\/index.php\/author\/reginald\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Task alerts not firing in new site from Content Migration. - Blog of an overweight SharePoint addict","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/www.myfatblog.co.uk\/index.php\/2010\/08\/task-alerts-not-firing-in-new-site-from-content-migration\/","og_locale":"en_US","og_type":"article","og_title":"Task alerts not firing in new site from Content Migration. - Blog of an overweight SharePoint addict","og_description":"Whilst working with a client recently we decided to use the Content Migration system within SharePoint to allow us to create a template site that could then be used as the source for the 88 sites that needed to be created for each of the areas of interest. Each site had identical set-up with regards … Continue reading","og_url":"http:\/\/www.myfatblog.co.uk\/index.php\/2010\/08\/task-alerts-not-firing-in-new-site-from-content-migration\/","og_site_name":"Blog of an overweight SharePoint addict","article_published_time":"2010-08-01T20:49:04+00:00","article_modified_time":"2010-08-01T20:50:23+00:00","og_image":[{"url":"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/TaskalertsnotfiringinnewsitefromContent_131C2\/image_thumb.png"}],"author":"Cimares","twitter_card":"summary_large_image","twitter_creator":"@cimares","twitter_site":"@cimares","twitter_misc":{"Written by":"Cimares","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/www.myfatblog.co.uk\/index.php\/2010\/08\/task-alerts-not-firing-in-new-site-from-content-migration\/","url":"http:\/\/www.myfatblog.co.uk\/index.php\/2010\/08\/task-alerts-not-firing-in-new-site-from-content-migration\/","name":"Task alerts not firing in new site from Content Migration. - Blog of an overweight SharePoint addict","isPartOf":{"@id":"http:\/\/www.myfatblog.co.uk\/#website"},"primaryImageOfPage":{"@id":"http:\/\/www.myfatblog.co.uk\/index.php\/2010\/08\/task-alerts-not-firing-in-new-site-from-content-migration\/#primaryimage"},"image":{"@id":"http:\/\/www.myfatblog.co.uk\/index.php\/2010\/08\/task-alerts-not-firing-in-new-site-from-content-migration\/#primaryimage"},"thumbnailUrl":"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/TaskalertsnotfiringinnewsitefromContent_131C2\/image_thumb.png","datePublished":"2010-08-01T20:49:04+00:00","dateModified":"2010-08-01T20:50:23+00:00","author":{"@id":"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/55ae8f6885bb5b8390dad001f3da83c6"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.myfatblog.co.uk\/index.php\/2010\/08\/task-alerts-not-firing-in-new-site-from-content-migration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.myfatblog.co.uk\/index.php\/2010\/08\/task-alerts-not-firing-in-new-site-from-content-migration\/#primaryimage","url":"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/TaskalertsnotfiringinnewsitefromContent_131C2\/image_thumb.png","contentUrl":"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/TaskalertsnotfiringinnewsitefromContent_131C2\/image_thumb.png"},{"@type":"WebSite","@id":"http:\/\/www.myfatblog.co.uk\/#website","url":"http:\/\/www.myfatblog.co.uk\/","name":"Blog of an overweight SharePoint addict","description":"The rantings of a (not so) food obsessed IT consultant!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.myfatblog.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/55ae8f6885bb5b8390dad001f3da83c6","name":"Cimares","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/image\/","url":"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/About_D057\/TopOfTheWorld.jpg","contentUrl":"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/About_D057\/TopOfTheWorld.jpg","caption":"Cimares"},"sameAs":["http:\/\/www.myfatblog.co.uk"],"url":"http:\/\/www.myfatblog.co.uk\/index.php\/author\/reginald\/"}]}},"_links":{"self":[{"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/212"}],"collection":[{"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/comments?post=212"}],"version-history":[{"count":2,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/212\/revisions"}],"predecessor-version":[{"id":214,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/212\/revisions\/214"}],"wp:attachment":[{"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/media?parent=212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/categories?post=212"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/tags?post=212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}