{"id":1425,"date":"2016-02-25T03:21:20","date_gmt":"2016-02-25T03:21:20","guid":{"rendered":"http:\/\/elbsolutions.com\/projects\/?p=1425"},"modified":"2022-02-03T11:24:34","modified_gmt":"2022-02-03T17:24:34","slug":"extracting-sharepoint-library-data-and-attached-files","status":"publish","type":"post","link":"https:\/\/elbsolutions.com\/projects\/extracting-sharepoint-library-data-and-attached-files\/","title":{"rendered":"Extracting sharepoint Library Data and attached files"},"content":{"rendered":"<ul>\n<li>So, using Sharpoint is good &#8230; when you <span style=\"text-decoration: underline;\">don&#8217;t<\/span> have a database or infrastructure to keep, upload and attach meta data to files, however, I have a customer who has a database in Filemaker with all the meta data already, and Filemaker has drag and drop functionality. VERY slick (quite proud of myself &#8211; I might publish that next). Yes you have to script and do a bit of gymnastics, but you can make it do exactly what you require it to do for your own specific task. Well, to extract all the info out of sharepoint to back-annotate the info into Filemaker was made simple by a few people. Here are some powershell scripts that made my life very easy\n<ul>\n<li><a href=\"http:\/\/www.nikcraik.ca\/sharepoint-powershell-script-to-extract-all-documents-and-their-versions\/\">SharePoint PowerShell Script to Extract All Documents and Their Versions<\/a>\u00a0(I commented the versions part OUT of the script)<\/li>\n<li><a href=\"http:\/\/sharepoint.stackexchange.com\/questions\/103639\/get-the-value-of-a-managed-metadata-item\">get the value of a managed metadata item<\/a><\/li>\n<li><a href=\"http:\/\/stackoverflow.com\/questions\/16286281\/export-the-powershell-output-to-a-text-file-in-tab-delimited-format\">make it a tab separated value list once it works on the command line<\/a><\/li>\n<li><a href=\"http:\/\/www.thorntontechnical.com\/tech\/sharepoint\/quick-tip-sharepoint-powershell-get-items-in-a-list-based-on-custom-columns-and-other-hints#.Vs1nVNBvDBM\">filtering items out of sharepoint<\/a><\/li>\n<li><a href=\"http:\/\/www.softvative.com\/blog\/2015\/02\/four-ways-to-get-report-of-sharepoint-folders-and-files-for-a-library\/\">Thinking thoughts &#8211; 4 ways to extract the data from sharepoint<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>So, using Sharpoint is good &#8230; when you don&#8217;t have a database or infrastructure to keep, upload and attach meta data to files, however, I have a customer who has a database in Filemaker with all the meta data already, and Filemaker has drag and drop functionality. VERY slick (quite proud of myself &#8211; I [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1425","post","type-post","status-publish","format-standard","hentry","category-general"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Extracting sharepoint Library Data and attached files - ELB Solutions.com Inc.<\/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:\/\/elbsolutions.com\/projects\/extracting-sharepoint-library-data-and-attached-files\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Extracting sharepoint Library Data and attached files - ELB Solutions.com Inc.\" \/>\n<meta property=\"og:description\" content=\"So, using Sharpoint is good &#8230; when you don&#8217;t have a database or infrastructure to keep, upload and attach meta data to files, however, I have a customer who has a database in Filemaker with all the meta data already, and Filemaker has drag and drop functionality. VERY slick (quite proud of myself &#8211; I [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/elbsolutions.com\/projects\/extracting-sharepoint-library-data-and-attached-files\/\" \/>\n<meta property=\"og:site_name\" content=\"ELB Solutions.com Inc.\" \/>\n<meta property=\"article:published_time\" content=\"2016-02-25T03:21:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-03T17:24:34+00:00\" \/>\n<meta name=\"author\" content=\"Etienne Bley\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Etienne Bley\" \/>\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\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/extracting-sharepoint-library-data-and-attached-files\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/extracting-sharepoint-library-data-and-attached-files\\\/\"},\"author\":{\"name\":\"Etienne Bley\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"headline\":\"Extracting sharepoint Library Data and attached files\",\"datePublished\":\"2016-02-25T03:21:20+00:00\",\"dateModified\":\"2022-02-03T17:24:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/extracting-sharepoint-library-data-and-attached-files\\\/\"},\"wordCount\":184,\"articleSection\":[\"General\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/extracting-sharepoint-library-data-and-attached-files\\\/\",\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/extracting-sharepoint-library-data-and-attached-files\\\/\",\"name\":\"Extracting sharepoint Library Data and attached files - ELB Solutions.com Inc.\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#website\"},\"datePublished\":\"2016-02-25T03:21:20+00:00\",\"dateModified\":\"2022-02-03T17:24:34+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/extracting-sharepoint-library-data-and-attached-files\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/extracting-sharepoint-library-data-and-attached-files\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/extracting-sharepoint-library-data-and-attached-files\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Extracting sharepoint Library Data and attached files\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#website\",\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/\",\"name\":\"ELB Solutions.com Inc.\",\"description\":\"Bringing all your IT Pieces together\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\",\"name\":\"Etienne Bley\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"caption\":\"Etienne Bley\"},\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/author\\\/etienne-bley\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Extracting sharepoint Library Data and attached files - ELB Solutions.com Inc.","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:\/\/elbsolutions.com\/projects\/extracting-sharepoint-library-data-and-attached-files\/","og_locale":"en_US","og_type":"article","og_title":"Extracting sharepoint Library Data and attached files - ELB Solutions.com Inc.","og_description":"So, using Sharpoint is good &#8230; when you don&#8217;t have a database or infrastructure to keep, upload and attach meta data to files, however, I have a customer who has a database in Filemaker with all the meta data already, and Filemaker has drag and drop functionality. VERY slick (quite proud of myself &#8211; I [&hellip;]","og_url":"https:\/\/elbsolutions.com\/projects\/extracting-sharepoint-library-data-and-attached-files\/","og_site_name":"ELB Solutions.com Inc.","article_published_time":"2016-02-25T03:21:20+00:00","article_modified_time":"2022-02-03T17:24:34+00:00","author":"Etienne Bley","twitter_misc":{"Written by":"Etienne Bley","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/elbsolutions.com\/projects\/extracting-sharepoint-library-data-and-attached-files\/#article","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/extracting-sharepoint-library-data-and-attached-files\/"},"author":{"name":"Etienne Bley","@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"headline":"Extracting sharepoint Library Data and attached files","datePublished":"2016-02-25T03:21:20+00:00","dateModified":"2022-02-03T17:24:34+00:00","mainEntityOfPage":{"@id":"https:\/\/elbsolutions.com\/projects\/extracting-sharepoint-library-data-and-attached-files\/"},"wordCount":184,"articleSection":["General"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/elbsolutions.com\/projects\/extracting-sharepoint-library-data-and-attached-files\/","url":"https:\/\/elbsolutions.com\/projects\/extracting-sharepoint-library-data-and-attached-files\/","name":"Extracting sharepoint Library Data and attached files - ELB Solutions.com Inc.","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/#website"},"datePublished":"2016-02-25T03:21:20+00:00","dateModified":"2022-02-03T17:24:34+00:00","author":{"@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"breadcrumb":{"@id":"https:\/\/elbsolutions.com\/projects\/extracting-sharepoint-library-data-and-attached-files\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/elbsolutions.com\/projects\/extracting-sharepoint-library-data-and-attached-files\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/elbsolutions.com\/projects\/extracting-sharepoint-library-data-and-attached-files\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/elbsolutions.com\/projects\/"},{"@type":"ListItem","position":2,"name":"Extracting sharepoint Library Data and attached files"}]},{"@type":"WebSite","@id":"https:\/\/elbsolutions.com\/projects\/#website","url":"https:\/\/elbsolutions.com\/projects\/","name":"ELB Solutions.com Inc.","description":"Bringing all your IT Pieces together","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/elbsolutions.com\/projects\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39","name":"Etienne Bley","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","caption":"Etienne Bley"},"url":"https:\/\/elbsolutions.com\/projects\/author\/etienne-bley\/"}]}},"_links":{"self":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/1425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/comments?post=1425"}],"version-history":[{"count":2,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/1425\/revisions"}],"predecessor-version":[{"id":1427,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/1425\/revisions\/1427"}],"wp:attachment":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/media?parent=1425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/categories?post=1425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/tags?post=1425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}