Metadata fields not displaying in office 2003
Hi,I have a document library with a couple of custom columns. When I create a new document and it opens in word 2003, it is suppose to ask me for all the metadata after I save the file. However, a lot of the fields are missing. It seems to be all my lookup fields.Does anyone know why this is happening? When I just upload a document instead of creating a new one it has all the fields. I also tested this on Office 2007 and everything was working fine there. It just seems to be office 2003.Any help would be appreciated.Thanks!
December 3rd, 2009 3:18pm
Uploading files to SharePoint can be done many ways including the upload page, front page extensions remote procedure calls and webdav using Windows Explorer. Of course Microsoft Office uses its own proprietary ways which may involve a combination of webservice and rpc calls depending on what version of Office you are using. Many companies have upgraded to SharePoint 2007 and Office 2007, however; many older Office version files still exist. Companies are putting older Office documents in SharePoint 2007 without converting to Office 2007 format. This seems to be reasonable, until you need to view and edit the document's properties. The catch is the process of "property demotion". SharePoint has a process of property "promotion" and "demotion". When you upload a document and its properties then a document's properties get "promoted" to the matching SharePoint columns. Opening the document from SharePoint then demotes SharePoint properties to the matching document's properties so they can be viewed in the native application. SharePoint 2007 seems to have a problem with the demotion process for Office 2003 documents. Check out the rest of the article Steve Curan Explains this better than anyone...http://sharepointfieldnotes.blogspot.com/2009/09/office-2003-files-are-second-class.htmThe main problem is using front page remote procedure call "put document". This method makes a direct call to the author.dll uploading the file binary and the corresponding properties you wish to populate. However, uploading Office 2003 files using this method causes an error on SharePoint 2007. After uploading a file you can examine the metadata that is generated for the document in the "AllDocs" table in the corresponding content database in sql server. Below is an example of what is generated in the metaInfo column of the table when you upload a file.
-Ivan Ivan Sanders
My LinkedIn Profile,
My Blog,
@iasanders.
Free Windows Admin Tool Kit Click here and download it now
February 12th, 2010 4:25am


