Avatar of wjb313
wjb313
Flag for United States of America asked on

Extract Files from SharePoint Foundation 2010

I have a client that recently deployed a custom Microsoft CRM implementation (third-party module on top of CRM) that also integrates with SharePoint Foundation 2010. The third-party module is vertical-specific to the staffing industry and the integration with SharePoint allows them to upload resumes, legal documents, etc... that are linked with the individual records within the CRM.

They are not pleased with the product and are now in the process of migrating away from it to a hosted applicant tracking system. They need to have the docs that are in the system extracted for upload to the new system with the caveat that each doc needs to retain the record ID that it is associated with in CRM so when it is uploaded it will link up with the correct record in the new system.

We don't have anyone on staff with any real knowledge of SharePoint (and we have zero knowledge of either of the applications involved) so I'm hoping someone can give me some guidance on how to extract files from SharePoint while maintaining the data that links it to the record it was uploaded to originally.

Thanks!
Microsoft SharePointMicrosoft Dynamics

Avatar of undefined
Last Comment
wjb313

8/22/2022 - Mon
Joe Klimis

First you need to look at the meta data  SharePoint for each document  to see if the CRM is stored against each document

The use PowerShell to extract the document  to a new location , may be storing the id in the document name. or creating a  lookup table
This may give you some pointers Here


to extract the documents look here http://blogs.msdn.com/b/varun_malhotra/archive/2012/02/08/sharepoint-2010-powershell-download-all-files-in-document-library-to-network-share-file-share.aspx
ASKER CERTIFIED SOLUTION
wjb313

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
wjb313

ASKER
This was the simplest solution and satisfied the software vendor's requirements.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes