none
How to export all files from a Sharepoint site?

    Question

  • We have a SharePoint site with several subsites and our customer wants that every month we export all the files (PDF, DOC, XLS ...) and put this on a CD-ROM for them. What is the best approach to do this? Are there any good tools for this?
    Monday, March 03, 2008 10:19 AM

Answers

  • Hi

    I came across this thread while trying to figure out how to extract multiple files from a SharePoint library all at once. When selecting more than one file, the download a copy button became unavailable on the SharePoint Website, as well as the extract option from the SharePoint Designer. None of the answers here worked for me (or were simple enough), but I finally came in contact with a SharePoint expert who showed me a simple button to get this done.

    In the SharePoint website, go to the library which stores the files you wish to extract. Click the Library option at the top of the page. Among the many confusing buttons is one that says "Open with Explorer." Click this to open the library in Windows [File] Explorer. From here you can select multiple files and drag&drop or copy&paste into a folder on your local machine!

    Hope this helps someone!

    • Proposed as answer by Shilezi Wednesday, June 13, 2012 6:47 PM
    • Marked as answer by Steven AndrewsEditor Tuesday, July 10, 2012 1:52 PM
    Wednesday, March 21, 2012 10:31 PM

All replies

  • How about using the stsadm cmdline tool like this:

    stsadm.exe -o backup -url http://server/site -filename backup.dat

     

    You can schedule it with "Scheduled Tasks".

    Monday, March 03, 2008 1:27 PM
  • This customer is really only interested in the standalone files. They want a simple directory with all the .PDF, .DOC, .XLS files ... In the command line you suggested we are going to create a backup.dat file. But this would be unusable by our customer.

    Monday, March 03, 2008 1:31 PM
  • Maybe you can use WebServices in your own program?

     

    Good links for information about Sharepoint and Webservices:

     

    http://www.developer.com/tech/article.php/3104621

    and

    http://msdn2.microsoft.com/en-us/library/aa159897(office.11).aspx

     

    I think you should use the DWS.asmx

    Monday, March 03, 2008 3:15 PM
  • Okay here is the deal. We are for Customer A working on Project X on a remote location thus not at the location of Customer A. We use Team Foundation Server and a SharePoint portal. In this SharePoint portal we upload all our architecture documents and other information. The Customer A wants to get a CD every months of all updated versions of all our documents. Due to technical reasons it is not possible to give Customer A remote access to our Sharepoint portal. I just can't imagine that it is not possible to extract all the documents from the sharepoint portal to the file system and then burn a CD from these files.

     

    Monday, March 03, 2008 3:37 PM
  • There's lots of ways to do this - one approach is to use the custom stsadm extension exportlistitem2 found here: http://stsadm.blogspot.com/2007/08/stsadm-commands_09.html

     

    This custom command will dump all the files from a list out to your file system and will mirror the folder structure - it will also create a manifest file containing all properties associated with the documents.

    Monday, March 03, 2008 10:33 PM
  • While I always like Gary Lapointe's custom extensions, and there are many different ways to accomplish what you are trying to do, I think I would try to synchronize the document library folders with a local folder using Microsoft SyncToy.  You could set it up to run as a scheduled task every x days, and then when you are ready to burn the files to CD you have a recent set of them to work with.  The only limitation that I could think of would be getting files that are saved as attachments to lists, but I think you can find those in the folder structure as well.

    Download and install SyncToy:

    http://www.microsoft.com/windowsxp/using/digitalphotography/prophoto/synctoy.mspx 

    Then create a mapped drive to the UNC path of the sharepoint site's document libraries, and save a local copy of the files.

     

    Hope this helps.

    SharePointDave2007

    Tuesday, March 04, 2008 10:49 PM
  •  

    Relating to Synctoy

     

    Is there a way for me to find out the UNC path of my document libraries - do I need to contact my network administrator for this?

     

    Craig

    Wednesday, March 05, 2008 12:29 PM
  • Hi,

    You can develope a simple app which will use SharePoint's built in Webservie Lists.asmx. You can use a method of this web service to download all  attachments.

    Thanks
    Sohel Rana
    Wednesday, March 12, 2008 9:25 AM
  • Your can try mapping a network drive from your local machine to the URL of your document library, just leave off the /Forms/AllItems.aspx part of the URL.

     

    Thursday, May 01, 2008 9:03 PM
  • Create a WEBDAV view of the SharePoint site-- to do this go to Network Places (on your Windows computer) and "Add a new Network Place" to the http URL. As long as you do this with admin credentials that can see everything, you should be able to copy all the files relatively easily this way as you'll just be accessing the files through Windows Explorer as if it was a network share.
    Friday, May 02, 2008 4:45 AM
  • Check out "Exporting documents from SharePoint using RoboCopy / RichCopy utility" article to do just what you need:

    http://www.paulgrimley.com/2010/03/exporting-documents-from-sharepoint.html

    And of course you can always user this Codeplex utility: http://spiefolder.codeplex.com

    Monday, February 28, 2011 6:48 AM
  • Hi I prefere a simple way using Sharepoint Workspace.

    it supports CTRL+C, CTRL+V

    Friday, February 10, 2012 9:21 AM
  • Hi

    I came across this thread while trying to figure out how to extract multiple files from a SharePoint library all at once. When selecting more than one file, the download a copy button became unavailable on the SharePoint Website, as well as the extract option from the SharePoint Designer. None of the answers here worked for me (or were simple enough), but I finally came in contact with a SharePoint expert who showed me a simple button to get this done.

    In the SharePoint website, go to the library which stores the files you wish to extract. Click the Library option at the top of the page. Among the many confusing buttons is one that says "Open with Explorer." Click this to open the library in Windows [File] Explorer. From here you can select multiple files and drag&drop or copy&paste into a folder on your local machine!

    Hope this helps someone!

    • Proposed as answer by Shilezi Wednesday, June 13, 2012 6:47 PM
    • Marked as answer by Steven AndrewsEditor Tuesday, July 10, 2012 1:52 PM
    Wednesday, March 21, 2012 10:31 PM
  • bgreatbri1...that method worked very well I must say
    Wednesday, June 13, 2012 6:47 PM
  • Very slick... I was looking for a way that I could easily explain to a client.  This does it!  Thanks.


    Microsoft Partner Senior Consultant

    Monday, December 24, 2012 3:20 PM
  • Unfortunately after the 2013 upgrade of Office 365 this option does not work. Here is the recap:

    Need to download multiple files FROM sharepoint to the desktop using Explorer :

    Library
    On the Library ribbon click on
    Connect and Export
    Click on "Open with Explorer"

    After the 2013 upgrade you get this error:
    "We're having a problem opening this location in File Explorer.
    Add this web site to your Trusted Sites list and try again."

    Now you go to Internet Explorer Privacy and Security setting and add your Intranet site to the list of trusted sites.
     Come back to the SharePoint Library. You get the same error. This used to work before the upgrade. It is creating a huge mess for my users.

    Friday, June 28, 2013 9:29 PM