{"id":164,"date":"2009-11-16T16:58:00","date_gmt":"2009-11-16T16:58:00","guid":{"rendered":"http:\/\/turtlellc.com\/index.php\/sharepoint-document-property-names\/"},"modified":"2009-11-16T16:58:00","modified_gmt":"2009-11-16T16:58:00","slug":"sharepoint-document-property-names","status":"publish","type":"post","link":"https:\/\/www.turtle.works\/knowledge\/sharepoint-document-property-names\/","title":{"rendered":"SharePoint Document Property Names"},"content":{"rendered":"

Recently while working on embedding SharePoint properties within a Word 2003 document I discovered some oddities with the names. When working to embed a property named Doc No. I found at times one of the 3 following situations displayed in the Field list:
<\/span><\/p>\n

    \n
  1. Doc No.<\/li>\n
  2. Doc No. and Document No.<\/li>\n
  3. Document No.<\/li>\n<\/ol>\n

    If i used Doc No.<\/span> the value would be incorrect. If I used Document No.<\/span> the correct value would display and would synchronize. <\/span><\/p>\n

    Upon investigation I looked at the AllLists<\/span> table in the database to find the row for the Document Library I was using. Examining the ContentType <\/span>column explained the behaviour. For the field Doc No.<\/span> this is the value I found:<\/span><\/p>\n

    <\/span><\/p>\n

    DisplayName=”Doc No.”
    Required=”TRUE” Hidden=”FALSE”
    ReadOnly=”FALSE” PITarget=”” PrimaryPITarget=””
    PIAttribute=”” PrimaryPIAttribute=””
    Aggregation=”” Node=””\/><\/span><\/p><\/blockquote>\n

    Notice that the name is Document No.<\/span> (after decoding) and the DisplayName is Doc No.<\/span> After seeing this, I remembered initially naming the column Document No. and then shortening it to Doc No. SharePoint obviously retained the original name as the ID of the field and just adds the DisplayName attribute to show the changed value. This is definitely a gotcha and will lead to some confusion for users. But at least the behaviour is now explained.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

    Recently while working on embedding SharePoint properties within a Word 2003 document I discovered some oddities with the names. When working to embed a property named Doc No. I found at times one of the 3 following situations displayed in the Field list: Doc No. Doc No. and Document No. Document No. If i used … <\/p>\n

    Continue reading “SharePoint Document Property Names”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41,20],"tags":[],"class_list":["post-164","post","type-post","status-publish","format-standard","hentry","category-moss","category-sharepoint"],"_links":{"self":[{"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts\/164","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/comments?post=164"}],"version-history":[{"count":0,"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts\/164\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/media?parent=164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/categories?post=164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/tags?post=164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}