Windows Sharepoint Services (WSS) File Extractor

by Posted on

We recently needed a way to extract files from a sharepoint site’s document libraries. With sharepoint all the files are stored in a SQL database so it would seem connecting to the database and pulling all the files out manually wouldn’t be such a hard thing to do. After a fair amount of time googling for such a solution I finally found it over at Mark Jen’s blog. Mark’s solution it turns out didn’t work for WSS 3.0 but in the comments a fella by the name of eric writes:

I have modified the code to work with SharePoint 07. Since the Content is stored in a new table with 07, the query piece needs to be a little different. Just replace line 24 with the sting below. It worked perfectly for me after that.

Find
com.CommandText =

Published by Jess

Experienced as a Web Developer and Web Server administrator since 1994, in 1999 Jess set out to start a Web Hosting Provider that would leverage the latest in cutting edge and innovative technologies and make them available to businesses in a way that was easy to understand, easy to use and affordable. Today Applied Innovations is a recognized leader in Windows Hosting and specializes in ASP.NET, E-Commerce and Advanced Web Application Hosting.

Leave a Reply