Adding Notes data to Websphere content manager via RSS

Websphere Content Manager (WCM) can aggregate information from various sources in many formats. A quick and dirty way to add Domino data is to use RSS. The simplest way is to add a page (not an XPage, a Page), define its content type as application/rss+xml and add a few lines to it:

<rss version="2.0">
 <channel>
  <title><Computed Value></title>
  <link><Computed Value>feed.xml</link>
  <description>Extraction of data from the Audience Governance database</description>
  <lastBuildDate><Computed Value></lastBuildDate>
  [Embedded view here]
 </channel>
</rss>

Thereafter create a view with passthrou HTML with all the values for an item element. Of course that is super boring, therefore you can use the following code to speed this up.Simply create a view and save it. Then open it in DXL and paste this in:

<?xml version="1.0" encoding="UTF-8"?>
<view xmlns="http://www.lotus.com/dxl"
      xmlns:ibmwcm="http://purl.org/net/ibmfeedsvc/wcm/1.0"
      xmlns:rss="http://backend.userland.com/rss2"
      name="(FeedData)"
      alias="FeedData"
      treatashtml="true"
      bgcolor="white"
      headers="flat"
      altrowcolor="#efefef"
      gridstyle="solid"
      gridcolor="silver">
   <code event="selection">
      <formula>SELECT @All amp;amp; !@IsAvailable($Conflict)</formula>
   </code>
   <column itemname="startItem" width="10.0">
      <code event="value">
         <formula>"amp;lt;itemamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;titleamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"title"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/titleamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;linkamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"link"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/linkamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;descriptionamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"description"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/descriptionamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;guidamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"guid"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/guidamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;pubDateamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"pubDate"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/pubDateamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;authoramp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"author"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/authoramp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:actionamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"ibmwcm:action"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:actionamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:itemTypeamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"ibmwcm:itemType"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:itemTypeamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:authoringTemplateamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"ibmwcm:authoringTemplate"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:authoringTemplateamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:pathamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"ibmwcm:path"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:pathamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:createLinksamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"ibmwcm:createLinks"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:createLinksamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:owneramp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"ibmwcm:owner"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:owneramp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:keywordsamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"ibmwcm:keywords"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:keywordsamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:workflowamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"ibmwcm:workflow"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:workflowamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:publishDateamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"ibmwcm:publishDate"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:publishDateamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:expirationDateamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"ibmwcm:expirationDate"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:expirationDateamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:element name=\"Heading\"amp;gt;amp;lt;ibmwcm:typeamp;gt;textamp;lt;/ibmwcm:typeamp;gt;amp;lt;ibmwcm:valueamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"Heading"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:valueamp;gt;amp;lt;/ibmwcm:elementamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:element name=\"End date\"amp;gt;amp;lt;ibmwcm:typeamp;gt;dateamp;lt;/ibmwcm:typeamp;gt;amp;lt;ibmwcm:valueamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"End date"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:valueamp;gt;amp;lt;/ibmwcm:elementamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:element name=\"Free event\"amp;gt;amp;lt;ibmwcm:typeamp;gt;optionamp;lt;/ibmwcm:typeamp;gt;amp;lt;ibmwcm:valueamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"Free event"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:valueamp;gt;amp;lt;/ibmwcm:elementamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:element name=\"Venue name\"amp;gt;amp;lt;ibmwcm:typeamp;gt;textamp;lt;/ibmwcm:typeamp;gt;amp;lt;ibmwcm:valueamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"Venue name"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:valueamp;gt;amp;lt;/ibmwcm:elementamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:element name=\"Short description\"amp;gt;amp;lt;ibmwcm:typeamp;gt;textamp;lt;/ibmwcm:typeamp;gt;amp;lt;ibmwcm:valueamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"Short description"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:valueamp;gt;amp;lt;/ibmwcm:elementamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:element name=\"Extended description\"amp;gt;amp;lt;ibmwcm:typeamp;gt;rich textamp;lt;/ibmwcm:typeamp;gt;amp;lt;ibmwcm:valueamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"Extended description"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:valueamp;gt;amp;lt;/ibmwcm:elementamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:element name=\"Audience\"amp;gt;amp;lt;ibmwcm:typeamp;gt;optionamp;lt;/ibmwcm:typeamp;gt;amp;lt;ibmwcm:valueamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"Audience"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:valueamp;gt;amp;lt;/ibmwcm:elementamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:element name=\"Interest area\"amp;gt;amp;lt;ibmwcm:typeamp;gt;optionamp;lt;/ibmwcm:typeamp;gt;amp;lt;ibmwcm:valueamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"Interest area"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:valueamp;gt;amp;lt;/ibmwcm:elementamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:element name=\"Event type\"amp;gt;amp;lt;ibmwcm:typeamp;gt;optionamp;lt;/ibmwcm:typeamp;gt;amp;lt;ibmwcm:valueamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"Event type"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:valueamp;gt;amp;lt;/ibmwcm:elementamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:element name=\"Archival value\"amp;gt;amp;lt;ibmwcm:typeamp;gt;optionamp;lt;/ibmwcm:typeamp;gt;amp;lt;ibmwcm:valueamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"Archival value"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:valueamp;gt;amp;lt;/ibmwcm:elementamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:element name=\"Select image\"amp;gt;amp;lt;ibmwcm:typeamp;gt;imageamp;lt;/ibmwcm:typeamp;gt;amp;lt;ibmwcm:valueamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"Select image"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:valueamp;gt;amp;lt;/ibmwcm:elementamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:element name=\"Image caption\"amp;gt;amp;lt;ibmwcm:typeamp;gt;textamp;lt;/ibmwcm:typeamp;gt;amp;lt;ibmwcm:valueamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"Image caption"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:valueamp;gt;amp;lt;/ibmwcm:elementamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;ibmwcm:accessamp;gt;"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"ibmwcm:access"</formula>
      </code>
   </column>
   <column width="10.0">
      <code event="value">
         <formula>"amp;lt;/ibmwcm:accessamp;gt;"</formula>
      </code>
   </column>
        <column itemname="endItem" width="10.0">
      <code event="value">
         <formula>"amp;lt;/itemamp;gt;"</formula>
      </code>
   </column>
</view>

Remove the columns you don't need and replace the static text with the fields in your database.
As usual: YMMV