{"id":995,"date":"2012-02-29T23:40:36","date_gmt":"2012-03-01T07:40:36","guid":{"rendered":"http:\/\/blog.brainlitter.com\/2012\/02\/29\/nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint\/"},"modified":"2012-02-29T23:40:36","modified_gmt":"2012-03-01T07:40:36","slug":"nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2012\/02\/29\/nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint\/","title":{"rendered":"Nifty 2 Minute Tip of the Day \u2013 Use Harmon.IE to update managed metadata across multiple documents at once in SharePoint"},"content":{"rendered":"<blockquote><p>Ok, this one will be short. I\u2019m tired and I\u2019m about ready to throw my laptop out of the window as the Internet access at this hotel is BRUTAL tonight. So apologies if this is a little disjointed, but the gist is here.<\/p><\/blockquote>\n<h2>The Challenge<\/h2>\n<p>If you have a whole bunch of documents in a SharePoint library (note, this won\u2019t help with a list I\u2019m afraid, at least at this writing) and you want to update their managed metadata (in my case, it was a bunch of documents moved from one site collection to another, in a different farm), you\u2019ll quickly learn that managed metadata columns are not available in the Datasheet view.<\/p>\n<p><a href=\"\/wp-content\/uploads\/brainlitter\/2012\/02\/SNAGHTML2e205b1c.png\"><img loading=\"lazy\" decoding=\"async\" style=\"padding-left: 0px;padding-right: 0px;padding-top: 0px;border: 0px\" title=\"SNAGHTML2e205b1c\" src=\"\/wp-content\/uploads\/brainlitter\/2012\/02\/SNAGHTML2e205b1c_thumb.png\" alt=\"SNAGHTML2e205b1c\" width=\"240\" height=\"211\" border=\"0\" \/><\/a><\/p>\n<p>Figure 1 : While Managed Metadata is really handy for identifying content&#8230;<\/p>\n<p><a href=\"\/wp-content\/uploads\/brainlitter\/2012\/02\/SNAGHTML2e208171.png\"><img loading=\"lazy\" decoding=\"async\" style=\"padding-left: 0px;padding-right: 0px;padding-top: 0px;border: 0px\" title=\"SNAGHTML2e208171\" src=\"\/wp-content\/uploads\/brainlitter\/2012\/02\/SNAGHTML2e208171_thumb.png\" alt=\"SNAGHTML2e208171\" width=\"240\" height=\"50\" border=\"0\" \/><\/a><\/p>\n<p>Figure 2 : But if I want to bulk update a whole bunch of documents, I can&#8217;t use the datasheet capabilities<\/p>\n<h2>The Solution<\/h2>\n<p>One of my favourite SharePoint add-ins in recent memory is Harmon.IE for a number of reasons, including price (free, unless you need the enterprise features). And tonight, I have another reason to like it. Updating managed metadata for a number of documents, at once.<\/p>\n<ul>\n<li>First off, get Harmon.IE \u2013 go to <a href=\"http:\/\/harmon.ie\">http:\/\/harmon.ie<\/a><\/li>\n<li>I\u2019m not going to go into details about installing it or the key reasons to use Harmon.IE, as they do a good job on their website so I\u2019m going to assume you have it installed and connected to Outlook (yep Outlook, Harmon.IE is an IE integrated tool, but that connects you to your SharePoint libraries and that is the secret here\u2026<\/li>\n<\/ul>\n<p><a href=\"\/wp-content\/uploads\/brainlitter\/2012\/02\/SNAGHTML2e210ea2.png\"><img loading=\"lazy\" decoding=\"async\" style=\"padding-left: 0px;padding-right: 0px;padding-top: 0px;border: 0px\" title=\"SNAGHTML2e210ea2\" src=\"\/wp-content\/uploads\/brainlitter\/2012\/02\/SNAGHTML2e210ea2_thumb.png\" alt=\"SNAGHTML2e210ea2\" width=\"94\" height=\"240\" border=\"0\" \/><\/a><\/p>\n<p>Figure 3: so the trick is, get the documents listed that are related and need bulk metadata processing and&#8230;<\/p>\n<p><a href=\"\/wp-content\/uploads\/brainlitter\/2012\/02\/SNAGHTML2e216d16.png\"><img loading=\"lazy\" decoding=\"async\" style=\"padding-left: 0px;padding-right: 0px;padding-top: 0px;border: 0px\" title=\"SNAGHTML2e216d16\" src=\"\/wp-content\/uploads\/brainlitter\/2012\/02\/SNAGHTML2e216d16_thumb.png\" alt=\"SNAGHTML2e216d16\" width=\"240\" height=\"177\" border=\"0\" \/><\/a><\/p>\n<p>Figure 4 : Set that metadata<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ok, this one will be short. I\u2019m tired and I\u2019m about ready to throw my laptop out of the window as the Internet access at this hotel is BRUTAL tonight. So apologies if this is a little disjointed, but the gist is here. The Challenge If you have a whole bunch of documents in a &hellip; <a href=\"https:\/\/regroove.ca\/brainlitter\/2012\/02\/29\/nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint\/\"><\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[14,334,450],"tags":[553,554,555],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Nifty 2 Minute Tip of the Day \u2013 Use Harmon.IE to update managed metadata across multiple documents at once in SharePoint - Brainlitter - Inside the mind of Sean Wallbridge<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/regroove.ca\/brainlitter\/2012\/02\/29\/nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Nifty 2 Minute Tip of the Day \u2013 Use Harmon.IE to update managed metadata across multiple documents at once in SharePoint - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"Ok, this one will be short. I\u2019m tired and I\u2019m about ready to throw my laptop out of the window as the Internet access at this hotel is BRUTAL tonight. So apologies if this is a little disjointed, but the gist is here. The Challenge If you have a whole bunch of documents in a &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/brainlitter\/2012\/02\/29\/nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2012-03-01T07:40:36+00:00\" \/>\n<meta name=\"author\" content=\"Sean Wallbridge\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sean Wallbridge\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2012\/02\/29\/nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint\/\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/2012\/02\/29\/nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint\/\",\"name\":\"Nifty 2 Minute Tip of the Day \u2013 Use Harmon.IE to update managed metadata across multiple documents at once in SharePoint - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2012-03-01T07:40:36+00:00\",\"dateModified\":\"2012-03-01T07:40:36+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2012\/02\/29\/nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/brainlitter\/2012\/02\/29\/nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2012\/02\/29\/nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Nifty 2 Minute Tip of the Day \u2013 Use Harmon.IE to update managed metadata across multiple documents at once in SharePoint\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/\",\"name\":\"Brainlitter - Inside the mind of Sean Wallbridge\",\"description\":\"Dad. Husband. Drummer. Learner of Things.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\",\"name\":\"Sean Wallbridge\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"caption\":\"Sean Wallbridge\"},\"url\":\"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Nifty 2 Minute Tip of the Day \u2013 Use Harmon.IE to update managed metadata across multiple documents at once in SharePoint - Brainlitter - Inside the mind of Sean Wallbridge","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":"https:\/\/regroove.ca\/brainlitter\/2012\/02\/29\/nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint\/","og_locale":"en_US","og_type":"article","og_title":"Nifty 2 Minute Tip of the Day \u2013 Use Harmon.IE to update managed metadata across multiple documents at once in SharePoint - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"Ok, this one will be short. I\u2019m tired and I\u2019m about ready to throw my laptop out of the window as the Internet access at this hotel is BRUTAL tonight. So apologies if this is a little disjointed, but the gist is here. The Challenge If you have a whole bunch of documents in a &hellip;","og_url":"https:\/\/regroove.ca\/brainlitter\/2012\/02\/29\/nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2012-03-01T07:40:36+00:00","author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/brainlitter\/2012\/02\/29\/nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint\/","url":"https:\/\/regroove.ca\/brainlitter\/2012\/02\/29\/nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint\/","name":"Nifty 2 Minute Tip of the Day \u2013 Use Harmon.IE to update managed metadata across multiple documents at once in SharePoint - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2012-03-01T07:40:36+00:00","dateModified":"2012-03-01T07:40:36+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/brainlitter\/2012\/02\/29\/nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/brainlitter\/2012\/02\/29\/nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/brainlitter\/2012\/02\/29\/nifty-2-minute-tip-of-the-day-use-harmon-ie-to-update-managed-metadata-across-multiple-documents-at-once-in-sharepoint\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"Nifty 2 Minute Tip of the Day \u2013 Use Harmon.IE to update managed metadata across multiple documents at once in SharePoint"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/brainlitter\/#website","url":"https:\/\/regroove.ca\/brainlitter\/","name":"Brainlitter - Inside the mind of Sean Wallbridge","description":"Dad. Husband. Drummer. Learner of Things.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77","name":"Sean Wallbridge","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","caption":"Sean Wallbridge"},"url":"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/995"}],"collection":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/comments?post=995"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/995\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=995"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=995"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}