{"id":204,"date":"2012-10-26T17:56:12","date_gmt":"2012-10-26T11:56:12","guid":{"rendered":"http:\/\/markwheeler.com\/wordpress\/?p=204"},"modified":"2012-10-26T17:56:12","modified_gmt":"2012-10-26T11:56:12","slug":"sharepoint-2010-email-enabled-discussion-list-content-query-web-part","status":"publish","type":"post","link":"https:\/\/www.markwheeler.com\/?p=204","title":{"rendered":"Sharepoint 2010 Email-Enabled Discussion List Content Query Web Part"},"content":{"rendered":"

I had a recent request to allow supervisors to post “kudos” emails to a Sharepoint site for display on a “dashboard.”<\/p>\n

They did not want it to be labor intensive by having to logon and copy\/paste email content to a list.<\/p>\n

To achieve this I created an email-enabled discussion list. This part is key as email-enabled document libraries keep the content of the email as an attachment. Discussion lists keep the email content in the body of the list.<\/p>\n

I added a Content Query Web Part to my page, set it up to query the discussion list and then exported that for modification.<\/p>\n

This is the change to the CQWP:<\/p>\n

<property name=\"CommonViewFields\" type=\"string\">Body,RichText;<\/pre>\n
DiscussionLastUpdated,DateTime;<\/property><\/pre>\n
This pulls in the Body and Date fields. I then added a custom ItemStyle for my display.<\/p>\n
<xsl:template name=\"Kuds\" match=\"Row[@Style='Kuds']\" mode=\"itemstyle\">\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <xsl:variable name=\"SafeLinkUrl\">\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <xsl:call-template name=\"OuterTemplate.GetSafeLink\">\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <xsl:with-param name=\"UrlColumnName\" select=\"'LinkUrl'\"\/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/xsl:call-template>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/xsl:variable><\/pre>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <xsl:variable name=\"DisplayTitle\">\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <xsl:call-template name=\"OuterTemplate.GetTitle\">\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <xsl:with-param name=\"Title\" select=\"''\"\/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <xsl:with-param name=\"UrlColumnName\" select=\"'LinkUrl'\"\/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <xsl:with-param name=\"UseFileName\" select=\"1\"\/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/xsl:call-template>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/xsl:variable><\/pre>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <table border=\"0\">\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <tr>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<Td style=\"background-color:#C0E2EF\">\n\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0<xsl:call-template name=\"OuterTemplate.CallPresenceStatusIconTemplate\"\/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <a href=\"{$SafeLinkUrl}\" title=\"{@LinkToolTip}\">\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <xsl:if test=\"$ItemsHaveStreams = 'True'\">\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<xsl:attribute name=\"onclick\">\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <xsl:value-of select=\"@OnClickForWebRendering\"\/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/xsl:attribute>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/xsl:if><\/pre>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<xsl:if test=\"$ItemsHaveStreams != 'True' and @OpenInNewWindow = 'True'\">\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <xsl:attribute name=\"onclick\">\n <xsl:value-of disable-output-escaping=\"yes\" select=\"$OnClickTargetAttribute\"\/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/xsl:attribute>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/xsl:if><\/pre>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<div style=\"font-size:10pt\"><xsl:value-of select=\"$DisplayTitle\"\/><\/div>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/a>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/Td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/tr>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <tr>\n<td style=\"border-bottom:2px black solid\">\n<div style=\"font-size:6pt;font-style:italic\"><\/pre>\n
<xsl:value-of disable-output-escaping=\"yes\"\u00a0 select=\"@DiscussionLastUpdated\"\/><\/div>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom:1px gray solid\">\n<xsl:value-of disable-output-escaping=\"yes\"\u00a0 select=\"@Body\"\/>\n<\/td>\n<\/tr>\n<\/table>\n<\/xsl:template><\/pre>\n
End result – The Subject line is highlighted in blue with the date posted underneath. The Body of the email follows below.<\/p>\n
\"\"<\/a><\/p>\n
<\/pre>\n","protected":false},"excerpt":{"rendered":"
I had a recent request to allow supervisors to post “kudos” emails to a Sharepoint site for display on a “dashboard.” They did not want it to be labor intensive by having to logon and copy\/paste email content to a list. To achieve this I created an email-enabled discussion list. […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[2,10,11],"tags":[34,43,99],"class_list":["post-204","post","type-post","status-publish","format-standard","hentry","category-computer","category-sharepoint","category-software","tag-content-query-web-part","tag-email-enabled-discussion-list","tag-sharepoint-2010"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/204","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=204"}],"version-history":[{"count":0,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/204\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}