<?xml version="1.0" encoding="utf-8"?>
<rss xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:pingback="http://madskills.com/public/xml/rss/module/pingback/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0">
  <channel>
    <title>Joe Shirey - Office Apps</title>
    <link>http://www.joeshirey.com/</link>
    <description>Random Technical Stuff</description>
    <language>en-us</language>
    <copyright>Joe Shirey</copyright>
    <lastBuildDate>Tue, 16 Oct 2007 22:41:02 GMT</lastBuildDate>
    <generator>newtelligence dasBlog 2.0.7226.0</generator>
    <managingEditor>joe@joeshirey.com</managingEditor>
    <webMaster>joe@joeshirey.com</webMaster>
    <item>
      <trackback:ping>http://www.joeshirey.com/Trackback.aspx?guid=5d937885-fcbf-4a45-a6ed-7e32ac6e51cb</trackback:ping>
      <pingback:server>http://www.joeshirey.com/pingback.aspx</pingback:server>
      <pingback:target>http://www.joeshirey.com/PermaLink,guid,5d937885-fcbf-4a45-a6ed-7e32ac6e51cb.aspx</pingback:target>
      <dc:creator>Joe Shirey</dc:creator>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <p>
One of the newest features of Word 2007 and MOSS 2007 is a much tighter integration
between the two applications, particularly when it comes to metadata.  There
is a capability to integrate the metadata into the actual document rather than attach
the metadata as an afterthought.  This example shows how to set this up.
</p>
        <p>
Create a document library with the appropriate columns (attributes) you want to track. 
In this case I have created document library called Features Requests with columns
for tracking Description, Request Date, Status (choice of New, In Process, and Completed),
and Priority (choice of High, Medium, and Low).
</p>
        <p>
          <a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_6.png">
            <img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="538" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_2.png" width="604" border="0" />
          </a>
        </p>
        <p>
Bring up the Advanced Settings for the document library and click on the "Edit Template"
link under the Document Template section.
</p>
        <p>
          <a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_22.png">
            <img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="538" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_10.png" width="604" border="0" />
          </a>
        </p>
        <p>
and Word will open in the following fashion:
</p>
        <p>
          <a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_26.png">
            <img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="497" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_12.png" width="604" border="0" />
          </a>
        </p>
        <p>
I created a quick shell document to capture the information required.
</p>
        <p>
          <a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_12.png">
            <img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="497" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_5.png" width="604" border="0" />
          </a>
        </p>
        <p>
The attributes from MOSS become Document Properties that are exposed as Quick Parts
in Word.  Word will respect the data types and try to infer the appropriate content
control.  If the data type is a choice in MOSS, Word will create a drop down
list.  For a date, Word will create a date picker.  One thing to note is
that while I changed the column name for the Title to Description, the Quick Part
still calls that data Title.
</p>
        <p>
          <a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_16.png">
            <img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="483" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_7.png" width="654" border="0" />
          </a>
        </p>
        <p>
The fully laid out Word document will have the content controls embedded in the document
itself and fully connected to the MOSS library.  You can change the properties
of the content controls and nest them if you want to lock down certain sections of
the document.
</p>
        <p>
          <a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_18.png">
            <img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="497" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_8.png" width="604" border="0" />
          </a>
        </p>
        <p>
Now you can save the document and it will update the document template in the document
library.  If you return to the document library and create a new document it
will use the template that we linked to the document library.
</p>
        <p>
          <a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_28.png">
            <img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="538" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_13.png" width="604" border="0" />
          </a>
        </p>
        <p>
As fields are filled in within the document the attributes change
</p>
        <p>
          <a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_32.png">
            <img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="497" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_15.png" width="604" border="0" />
          </a>
        </p>
        <p>
As the document is saved back to the document library, all of the attributes are saved
back to the columns in the document library.
</p>
        <p>
          <a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_34.png">
            <img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="538" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_16.png" width="604" border="0" />
          </a>
        </p>
        <p>
The metadata about the document will fully round trip - if I change the metadata in
MOSS, the document will change and vice versa.  If you want to understand the
mechanics of this, you can crack open the document (save it locally, rename to use
a .zip extension, and open it in explorer) and look at the custom xml folder. 
The data is not embedded in the content of the document but is bound via custom xml.
</p>
        <img width="0" height="0" src="http://www.joeshirey.com/aggbug.ashx?id=5d937885-fcbf-4a45-a6ed-7e32ac6e51cb" />
      </body>
      <title>Word 2007/MOSS Metadata Integration</title>
      <guid isPermaLink="false">http://www.joeshirey.com/PermaLink,guid,5d937885-fcbf-4a45-a6ed-7e32ac6e51cb.aspx</guid>
      <link>http://www.joeshirey.com/2007/10/16/Word2007MOSSMetadataIntegration.aspx</link>
      <pubDate>Tue, 16 Oct 2007 22:41:02 GMT</pubDate>
      <description>&lt;p&gt;
One of the newest features of Word 2007 and MOSS 2007 is a much tighter integration
between the two applications, particularly when it comes to metadata.&amp;nbsp; There
is a capability to integrate the metadata into the actual document rather than attach
the metadata as an afterthought.&amp;nbsp; This example shows how to set this up.
&lt;/p&gt;
&lt;p&gt;
Create a document library with the appropriate columns (attributes) you want to track.&amp;nbsp;
In this case I have created document library called Features Requests with columns
for tracking Description, Request Date, Status (choice of New, In Process, and Completed),
and Priority (choice of High, Medium, and Low).
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_6.png"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="538" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_2.png" width="604" border="0"&gt;&lt;/a&gt; 
&lt;/p&gt;
&lt;p&gt;
Bring up the Advanced Settings for the document library and click on the "Edit Template"
link under the Document Template section.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_22.png"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="538" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_10.png" width="604" border="0"&gt;&lt;/a&gt; 
&lt;/p&gt;
&lt;p&gt;
and Word will open in the following fashion:
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_26.png"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="497" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_12.png" width="604" border="0"&gt;&lt;/a&gt; 
&lt;/p&gt;
&lt;p&gt;
I created a quick shell document to capture the information required.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_12.png"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="497" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_5.png" width="604" border="0"&gt;&lt;/a&gt; 
&lt;/p&gt;
&lt;p&gt;
The attributes from MOSS become Document Properties that are exposed as Quick Parts
in Word.&amp;nbsp; Word will respect the data types and try to infer the appropriate content
control.&amp;nbsp; If the data type is a choice in MOSS, Word will create a drop down
list.&amp;nbsp; For a date, Word will create a date picker.&amp;nbsp; One thing to note is
that while I changed the column name for the Title to Description, the Quick Part
still calls that data Title.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_16.png"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="483" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_7.png" width="654" border="0"&gt;&lt;/a&gt; 
&lt;/p&gt;
&lt;p&gt;
The fully laid out Word document will have the content controls embedded in the document
itself and fully connected to the MOSS library.&amp;nbsp; You can change the properties
of the content controls and nest them if you want to lock down certain sections of
the document.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_18.png"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="497" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_8.png" width="604" border="0"&gt;&lt;/a&gt; 
&lt;/p&gt;
&lt;p&gt;
Now you can save the document and it will update the document template in the document
library.&amp;nbsp; If you return to the document library and create a new document it
will use the template that we linked to the document library.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_28.png"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="538" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_13.png" width="604" border="0"&gt;&lt;/a&gt; 
&lt;/p&gt;
&lt;p&gt;
As fields are filled in within the document the attributes change
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_32.png"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="497" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_15.png" width="604" border="0"&gt;&lt;/a&gt; 
&lt;/p&gt;
&lt;p&gt;
As the document is saved back to the document library, all of the attributes are saved
back to the columns in the document library.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_34.png"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="538" alt="image" src="http://www.joeshirey.com/content/binary/WindowsLiveWriter/Word2007MOSSMetadataIntegration_EA51/image_thumb_16.png" width="604" border="0"&gt;&lt;/a&gt; 
&lt;/p&gt;
&lt;p&gt;
The metadata about the document will fully round trip - if I change the metadata in
MOSS, the document will change and vice versa.&amp;nbsp; If you want to understand the
mechanics of this, you can crack open the document (save it locally, rename to use
a .zip extension, and open it in explorer) and look at the custom xml folder.&amp;nbsp;
The data is not embedded in the content of the document but is bound via custom xml.
&lt;/p&gt;
&lt;img width="0" height="0" src="http://www.joeshirey.com/aggbug.ashx?id=5d937885-fcbf-4a45-a6ed-7e32ac6e51cb" /&gt;</description>
      <category>MOSS</category>
      <category>Office</category>
      <category>Office Apps</category>
    </item>
  </channel>
</rss>