Link to home
Start Free TrialLog in
Avatar of wjb313
wjb313Flag 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!
Avatar of Joe Klimis
Joe Klimis
Flag of United Kingdom of Great Britain and Northern Ireland image

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
Avatar of wjb313
wjb313
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of wjb313

ASKER

This was the simplest solution and satisfied the software vendor's requirements.