{"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":"http:\/\/www.turtle.works\/knowledge\/sharepoint-document-property-names\/","title":{"rendered":"SharePoint Document Property Names"},"content":{"rendered":"<p><span style=\"font-family: trebuchet ms;\">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:<br \/><\/span><\/p>\n<ol style=\"font-family: trebuchet ms;\">\n<li>Doc No.<\/li>\n<li>Doc No. and Document No.<\/li>\n<li>Document No.<\/li>\n<\/ol>\n<p><span style=\"font-family: trebuchet ms;\">If i used <span style=\"font-style: italic;\">Doc No.<\/span> the value would be incorrect. If I used <span style=\"font-style: italic;\">Document No.<\/span> the correct value would display and would synchronize. <\/span><\/p>\n<p><span style=\"font-family: trebuchet ms;\">Upon investigation I looked at the <span style=\"font-style: italic;\">AllLists<\/span> table in the database to find the row for the Document Library I was using. Examining the <span style=\"font-style: italic;\">ContentType <\/span>column explained the behaviour. For the field <span style=\"font-style: italic;\">Doc No.<\/span> this is the value I found:<\/span><\/p>\n<p><span style=\"font-family: trebuchet ms;\"><\/span><\/p>\n<blockquote><p><span style=\"font-family: trebuchet ms;\"><fieldRef ID=\"{339ab4a8-844a-47f0-89fa-a956de3af582}\" Name=\"Document_x0020_No_x002e_\"<br \/>DisplayName=&#8221;Doc No.&#8221;<br \/>Required=&#8221;TRUE&#8221; Hidden=&#8221;FALSE&#8221;<br \/>ReadOnly=&#8221;FALSE&#8221; PITarget=&#8221;&#8221; PrimaryPITarget=&#8221;&#8221;<br \/>PIAttribute=&#8221;&#8221; PrimaryPIAttribute=&#8221;&#8221;<br \/>Aggregation=&#8221;&#8221; Node=&#8221;&#8221;\/><\/span><\/p><\/blockquote>\n<p><span style=\"font-family: trebuchet ms;\">Notice that the name is <span style=\"font-style: italic;\">Document No.<\/span> (after decoding) and the DisplayName is <span style=\"font-style: italic;\">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":"<p>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 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.turtle.works\/knowledge\/sharepoint-document-property-names\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;SharePoint Document Property Names&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[41,20],"tags":[],"class_list":["post-164","post","type-post","status-publish","format-standard","hentry","category-moss","category-sharepoint"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SharePoint Document Property Names - Turtle Works<\/title>\n<meta name=\"description\" content=\"A knowledge base written by Turtle Works LLC to help you achieve SharePoint Document Property Names - Turtle Works\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.turtle.works\/knowledge\/sharepoint-document-property-names\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SharePoint Document Property Names - Turtle Works\" \/>\n<meta property=\"og:description\" content=\"A knowledge base written by Turtle Works LLC to help you achieve SharePoint Document Property Names - Turtle Works\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.turtle.works\/knowledge\/sharepoint-document-property-names\/\" \/>\n<meta property=\"og:site_name\" content=\"Turtle Works\" \/>\n<meta property=\"article:published_time\" content=\"2009-11-16T16:58:00+00:00\" \/>\n<meta name=\"author\" content=\"josef.wainz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"josef.wainz\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/sharepoint-document-property-names\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/sharepoint-document-property-names\\\/\"},\"author\":{\"name\":\"josef.wainz\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#\\\/schema\\\/person\\\/cb79278290029b781485a7b61b9b9a0b\"},\"headline\":\"SharePoint Document Property Names\",\"datePublished\":\"2009-11-16T16:58:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/sharepoint-document-property-names\\\/\"},\"wordCount\":194,\"publisher\":{\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#organization\"},\"articleSection\":[\"MOSS\",\"SharePoint\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/sharepoint-document-property-names\\\/\",\"url\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/sharepoint-document-property-names\\\/\",\"name\":\"SharePoint Document Property Names - Turtle Works\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#website\"},\"datePublished\":\"2009-11-16T16:58:00+00:00\",\"description\":\"A knowledge base written by Turtle Works LLC to help you achieve SharePoint Document Property Names - Turtle Works\",\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/sharepoint-document-property-names\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/sharepoint-document-property-names\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/sharepoint-document-property-names\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SharePoint Document Property Names\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#website\",\"url\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/\",\"name\":\"Turtle Works\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#organization\",\"name\":\"Turtle Works\",\"url\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/cropped-TurtleWorks.png\",\"contentUrl\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/cropped-TurtleWorks.png\",\"width\":625,\"height\":250,\"caption\":\"Turtle Works\"},\"image\":{\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#\\\/schema\\\/person\\\/cb79278290029b781485a7b61b9b9a0b\",\"name\":\"josef.wainz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g\",\"caption\":\"josef.wainz\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SharePoint Document Property Names - Turtle Works","description":"A knowledge base written by Turtle Works LLC to help you achieve SharePoint Document Property Names - Turtle Works","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/www.turtle.works\/knowledge\/sharepoint-document-property-names\/","og_locale":"en_US","og_type":"article","og_title":"SharePoint Document Property Names - Turtle Works","og_description":"A knowledge base written by Turtle Works LLC to help you achieve SharePoint Document Property Names - Turtle Works","og_url":"http:\/\/www.turtle.works\/knowledge\/sharepoint-document-property-names\/","og_site_name":"Turtle Works","article_published_time":"2009-11-16T16:58:00+00:00","author":"josef.wainz","twitter_card":"summary_large_image","twitter_misc":{"Written by":"josef.wainz","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.turtle.works\/knowledge\/sharepoint-document-property-names\/#article","isPartOf":{"@id":"http:\/\/www.turtle.works\/knowledge\/sharepoint-document-property-names\/"},"author":{"name":"josef.wainz","@id":"https:\/\/www.turtle.works\/knowledge\/#\/schema\/person\/cb79278290029b781485a7b61b9b9a0b"},"headline":"SharePoint Document Property Names","datePublished":"2009-11-16T16:58:00+00:00","mainEntityOfPage":{"@id":"http:\/\/www.turtle.works\/knowledge\/sharepoint-document-property-names\/"},"wordCount":194,"publisher":{"@id":"https:\/\/www.turtle.works\/knowledge\/#organization"},"articleSection":["MOSS","SharePoint"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"http:\/\/www.turtle.works\/knowledge\/sharepoint-document-property-names\/","url":"http:\/\/www.turtle.works\/knowledge\/sharepoint-document-property-names\/","name":"SharePoint Document Property Names - Turtle Works","isPartOf":{"@id":"https:\/\/www.turtle.works\/knowledge\/#website"},"datePublished":"2009-11-16T16:58:00+00:00","description":"A knowledge base written by Turtle Works LLC to help you achieve SharePoint Document Property Names - Turtle Works","breadcrumb":{"@id":"http:\/\/www.turtle.works\/knowledge\/sharepoint-document-property-names\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.turtle.works\/knowledge\/sharepoint-document-property-names\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.turtle.works\/knowledge\/sharepoint-document-property-names\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.turtle.works\/knowledge\/"},{"@type":"ListItem","position":2,"name":"SharePoint Document Property Names"}]},{"@type":"WebSite","@id":"https:\/\/www.turtle.works\/knowledge\/#website","url":"https:\/\/www.turtle.works\/knowledge\/","name":"Turtle Works","description":"","publisher":{"@id":"https:\/\/www.turtle.works\/knowledge\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.turtle.works\/knowledge\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.turtle.works\/knowledge\/#organization","name":"Turtle Works","url":"https:\/\/www.turtle.works\/knowledge\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.turtle.works\/knowledge\/#\/schema\/logo\/image\/","url":"http:\/\/www.turtle.works\/knowledge\/wp-content\/uploads\/2020\/07\/cropped-TurtleWorks.png","contentUrl":"http:\/\/www.turtle.works\/knowledge\/wp-content\/uploads\/2020\/07\/cropped-TurtleWorks.png","width":625,"height":250,"caption":"Turtle Works"},"image":{"@id":"https:\/\/www.turtle.works\/knowledge\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.turtle.works\/knowledge\/#\/schema\/person\/cb79278290029b781485a7b61b9b9a0b","name":"josef.wainz","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g","caption":"josef.wainz"}}]}},"_links":{"self":[{"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts\/164","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/comments?post=164"}],"version-history":[{"count":0,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts\/164\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/media?parent=164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/categories?post=164"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/tags?post=164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}