Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

How to download all uploaded Share point Documents

  Asked By: Nichole    Date: Mar 02    Category: Sharepoint    Views: 4626

How can I download all the Documents uploaded on the Share point Server?

I understand that they are all stored in the Database.

Any particular Table I need to look in and how can I download them into the right format?

Share: 

 

10 Answers Found

 
Answer #1    Answered By: Chantal Rosa     Answered On: Mar 02

Use My Network Places in Windows Explorer.

 
Answer #2    Answered By: Kyla Eckert     Answered On: Mar 02

But they are all stored  in the database? Won’t I need a script to do this?

 
Answer #3    Answered By: Damon Garner     Answered On: Mar 02

The easiest way I have seen is to write a small program to connect to the
SiteName_SITE database  and use a ADO.NET DataReader (or other equivalent)
to read the files out of the database. The Table is called Docs, The binary
field with the file is called content, the field with the Filename is
called LeafName. DirName is self-explanatory.

 
Answer #4    Answered By: Alexis Ellis     Answered On: Mar 02

Map a network drive and use xcopy within a batch file?

 
Answer #5    Answered By: Percy Beach     Answered On: Mar 02

No. Don't get caught up on the fact that the documents  are actually in
the database. At some point  in the not too distant future, all file
system files will be in a database  (WinFS - or whatever it will
eventually be called). However, we will continue to have familiar tools,
like Windows Explorer to interact with them.

Consider that we still have a DOS prompt interface even though there
isn't really anything left of DOS in Windows.

 
Answer #6    Answered By: Mary Adams     Answered On: Mar 02

Where on the share  point server can I find all the documents uploaded  by users (xls,pdf,.doc?)

 
Answer #7    Answered By: Laura Walker     Answered On: Mar 02

In the version of share  point that i use, the documents  are stored  in a table  called doc.

Can you please explain how I can access this table using windows explorer as suggested below.

I really wonder you can swing that.

 
Answer #8    Answered By: Alyssa Butler     Answered On: Mar 02

I would strongly advise against directly accessing the database  via
ADO.NET. If you must write a program to get to every document in every
document library, the SharePoint API is the right vehicle to achieve
this task.

 
Answer #9    Answered By: Katy Patton     Answered On: Mar 02

Robocopy (Windows Resource Kit) works better. Xcopy seems to run out of memory on large sites (at least on my workstation). Robocopy also creates a detailed log file to debug problems. For example, I have a script that copies all files in all portals every night to the file system using Robocopy with syntax:

robocopy "\\<virtual server URL>\<path>\<site>" "\\<server>\<shared folder>\<path>\<site>" /E /R:2 /W:2 /A-:RH /LOG:"\\<server>\<shared folder>\<path>\<site>\Robocopy_Log.txt"

FYI: I run this script on workstations only with Office 2003 installed and WebClient service running. I have not been able to get this script to work at all on a server.

 
Answer #10    Answered By: Ana Payne     Answered On: Mar 02

Documents stored  in a Windows XP file system are actually stored in a
proprietary ISAM repository table  called Docs. We are provided with an
interface called Windows Explorer to gain access to these documents. Go
ahead, crack open ILDASM and check. ; ) How can I query the ISAM Docs
table directly?

Answer, you don't.

Documents stored in a SharePoint document library are actually stored in
a proprietary SQL Server database  table called Docs. We are provided
with an interface called Windows SharePoint Services and alternately
(via DAV) Windows Explorer to gain access to these documents. Go ahead,
crack open ILDASM and check. ; ) How can I query the SQL Server Docs
table directly?

Answer, you shouldn't.

 
Didn't find what you were looking for? Find more on How to download all uploaded Share point Documents Or get search suggestion and latest updates.




Tagged: