Extracting sharepoint Library Data and attached files
- So, using Sharpoint is good … when you don’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 – 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
- SharePoint PowerShell Script to Extract All Documents and Their Versions (I commented the versions part OUT of the script)
- get the value of a managed metadata item
- make it a tab separated value list once it works on the command line
- filtering items out of sharepoint
- Thinking thoughts – 4 ways to extract the data from sharepoint
Faisal Masood
December 7, 2016Thanks for thoughtful information