Friday, December 29, 2006

SharePoint Document Puller v4.0

SharePoint Document Puller v4.0
Introduction
SharePoint Document Puller is a tool to extract documents from the SharePoint's DB. It works with SharePoint Portal Server 2003 (and WSS 2.0).

I have made several changes in this version. There were requests for new features. I have tried to include everything that people requested. The only thing you will find missing is a progress bar or a status  bar that displays the download status.
History
Version 1.0
Version 2.0Version 3.0
Details
You see a configuration screen when you run the application for the first time.

Use this screen to add your database connectivity details. Select server from Server dropdown. Click (Re)Load to populate the Server dropdown if it's empty. Add Username and Password and click Connect. This will populate the Database dropdown. There is a possibility that some one is using different databases for different instances (portals) of SharePoint. Select the database from the Database and click the Save button. This will save the configuration and next time, you start the application, you will be taken directly to the Download Documents screen. You can also add a connection string. Select the second radio button to enable the text box and add the connection string and click the Save button to save the configuration.
Shortcut keys
Key Functionality Screen
Ctrl+1 Download Documents
Alt+O Download Documents
Ctrl+2 Download Libraries
Alt+E Download Libraries
Ctrl+3 Configuration
Alt+C Configuration
Ctrl+4 About
Alt+A About
Alt+S Select All Items Download Documents
Alt+D Copy Directory Structure Download Documents
Alt+B Browse Download Documents
Alt+V View Documents Download Documents
Alt+P Pull Document(s) Download Documents
Alt+S Select All Items Download Libraries
Alt+D Copy Directory Structure Download Libraries
Alt+B Browse Download Libraries
Alt+V View Sites Download Libraries
Alt+P Pull Document(s) Download Libraries
Alt+L (Re)Load Configuration
Alt+C Connect Configuration
Alt+S Save Configuration
Download Documents
Click View Documents to populate list box with the documents. Select a destination and click Pull Document(s) to download all documents to your hard disk. Check Copy Directory Structure checkbox if you want to copy the directory structure of each file. Similarly, if you want to download complete libraries, select Download Libraries from the menu bar. List box will show you all the libraries that have documents. Select the libraries you want to download, select a destination and click Pull Document(s). Application searches almost all types of files including .doc, .xls, .mdb, .pdf, .gif, .jpg, etc.
Download SharePoint Document Puller v4.0
Published Friday, December 29, 2006 9:41 PM by ssa

Comment Notification

If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using RSS

Comments

 

Krishna said:

Exactly what i was looking for! Thank you so much!

Krishna
December 29, 2006 8:52 AM
 

Neha said:

Excellent tool! Its so easy to use. Can I download PPT files with this tool?

TIA

Neha
December 29, 2006 8:53 AM
 

grayghost said:

Interesting.  So it's a GUI version of the export tool included in Keith Richie's SPUtiliSuite?
December 29, 2006 9:17 AM
 

William V. said:

I am setting up my company's departments in MOSS. This tool will come in handy for downloading and archiving documents uploaded by thousands of users across the company that is scattered in 5 countries. I just tested it with 2003. I like the directory structure feature. It helps when archiving documents as separate zip files. Excellent tool! Thank you.
December 29, 2006 9:47 AM
 

ajaxspider said:

I need a similar tool for MOSS
December 29, 2006 9:48 AM
 

ssa said:

Hi Grayghost,

I didn't know that Keith's utility suite had a similar tool included. Although i tested a couple of utilities from his suite months ago but didn't notice the tool you are talking about. I would like to check that out! :)

Thanks,

SSA
December 29, 2006 9:51 AM
 

Ramba said:

Hi
I just need a list of all files in the sharepoint. It would be nice if you include a feature to publish a list of files available in sharepoint.

Thanks

Ramba
December 29, 2006 9:53 AM
 

ssa said:

Hi Ramba,

I wrote an application years ago :) that did exactly what you are looking for. That application is still available somewhere on my blog. Just search my blog for keywords like explorer, sharepoint explorer. That application generates an excel sheet as an output.

Thanks,

SSA
December 29, 2006 9:56 AM
 

David Moore said:

Nice tool!
December 29, 2006 9:58 AM
 

David Moore said:

Nice tool!
December 29, 2006 9:58 AM
 

Geena said:

I dont know password to the sql server. how can i use the connection string?
December 29, 2006 10:12 AM
 

David Moore said:

Geena,

Try using the trusted connection in the connection string. See the second figure in the post. It contains the connection string! ;)
December 29, 2006 10:14 AM
 

Geena said:

Hey

Thanks for the help. :) you r genius!
December 29, 2006 10:16 AM
 

Joseph said:

can we archive these documents without downloading?
December 29, 2006 10:17 AM
 

grayghost said:

I want to say that the utility is named SPExportWeb which goes and basically dumps the site to the filesystem.  Comes in handy :)
December 31, 2006 12:45 AM
 

ssa said:

Thanks for the info grayghost!
December 31, 2006 1:41 AM
 

Remco Ploeg said:

Good job, great tool!
January 3, 2007 9:30 AM
 

decatec said:

Thanks .... this tool will be perfect for content migrations
January 7, 2007 8:33 AM
 

ssa said:

Thanks Remco!
January 9, 2007 5:48 AM
 

ssa said:

Thanks Decatec!
January 9, 2007 5:49 AM
 

Alberto said:

Fantastic! Thanks!! Is a great tool!
Now, i have a question... and if someone (I... for example) wants that the documents in a site are download and after delete from the site every 5 days... do you know a method for do it?
January 11, 2007 3:02 AM
 

ssa said:

Alberto,

Thanks for liking the tool. You are suggesting a new feature! :) Yes, of course, you can do it. With some extra programming this can be done! I will try to incorporate this feature but it will take time.

Regards,

SSA
January 12, 2007 12:40 AM
 

Alberto said:

Thankt to you.
If you want a help perhaps I can avail you.
I don't know the SharePoint architecture but I have knowledge of SQL Server and some language of programming (Java, VB, C, ASP) ...
In each case i attend your new solutions. :)

Regards,
Alberto
January 12, 2007 4:25 AM
 

ssa said:

Thank you very much Alberto! Thanks indeed for the help offer! My next goal is to create a similar tool for the latest SharePoint server (MOSS 2007).

Regards,

SSA
January 12, 2007 9:03 AM
at

No comments:

Post a Comment