I just updated the Sharepoint Database Exporter.  It now supports Sharepoint 2007.

For more details, see the my original post here.

No comments

Watch Your Time is a freeware application that helps you keep track of what you’ve done within a day. Its source code is also available under the GPL version 2 license.

Watch Your Time features:

• It works without installation.
    (you can run it from a USB key)
• It performs time logging by asking what you are doing every x minutes.
• It records your time data within an XML file.
• It remembers your last tasks for a period of time of your choice.
• It is able to aggregate what you’ve done by task, project and day.
• It is FREE.

Screenshots:

• Watch Your Time
• Statistics Generator

Requirements:
It is built using the .NET Framework 1.1 and should run within any environment that is able to run the framework. I also succeed to run it in Ubuntu using Mono (without the system tray icon).

Download locations:

• Watch Your Time v1.1.6.0 - Binaries only
• Watch Your Time v1.1.6.0 - Srouces and binaries
• Alternate location: Watch Your Time v1.1.6.0 - Sources and binaries on Softpedia
  It has received the “100% CLEAN award granted by Softpedia” (quite normal for an open source software ;))

Additional notes:
Anyone interested in requesting a feature or contributing to the application is welcome to do so by posting a comment to this page.

Read more

2 comments

Hi,

Some months ago I was experimenting with Windows Sharepoint Services and found out that my machine was not powerfull enough to run Windows 2003, SQL Server and Sharepoint at a decent speed. I had data in Sharepoint I wanted to keep so I did an SQL Server backup of the database. I tought that I would re-setup everything easily after a machine upgrade… I was wrong! I never succeeded to restore the database backup in a running Sharepoint environment (I learned the hard way that I should have used WSS backup utilities instead of relying only on a database backup).

From that moment I decided to explore how Microsoft stores its data within Sharepoint. I found out about Docs and UserData tables and I thought I could develop a little tool to extract my data. In the mean time I discovered the Sharepoint Database Explorer from James Edelen. I was happy that I would’nt have to code it myself :)… The tool is nice, but it didn’t allow me to export custom lists and metadata…

As a learning experience, I decided to build an exporter program. It happens that I find it usefull in a couple of situations… So I decided to share in case anybody would have the same needs than I had!

***** Updated (2008-02-21) *****

Features (v1.1.0.1):

• It is possible to preview the pending version (checked-out and saved, but not yet checked-in) of a file.
  (on both: WSS 2.0 and WSS 3.0) (see this screenshot)
• Bug fix regarding the extraction of document librarie items when files are checked-out.

Features (v1.1.0.0):

• Connects to either Sharepoint 2003 or Sharepoint 2007 database structure (automatic detection).
• It is possible to preview the version history of a file and to export individually a previous version of a file.

Features (v1.0.0.1):

• Connects to Sharepoint 2003 databases directly
• Does not rely on a working Sharepoint environment… it only connects to the database
• You can preview the list contents (see screenshots)
• It is possible to export individual files from the preview window.
• You can export custom list attachments and document library files
• You can export metadata

Metadata is exported in an xml file. For attachments, you have the choice to export them in a folder or to embed them in the xml.

Known issues:

• When a list is not customized (kept as-is — no additional fields added), Microsoft does not store the column mapping (Sharepoint field name mapping to SQL Server column name). They probably store them in a resource file so its faster to retrieve than querying the database. For us, that means we have to hardcode the mapping for each list type (Custom List, Contact List, Discussion List, Calendar, etc.). For this reason, some list types may not export well.

Screenshots:

• Preview tab - Attachment history
• Preview tab - Custom List
• Preview tab - Listitem with attachment
• Export tab
• XML sample

Download (Latest Version):

• Sharepoint Database Exporter (v1.1.0.1) - Binaries Only
• Sharepoint Database Exporter (v1.1.0.1) - Sources and Binaries
• License (New BSD License)

Add-On:

• XSL Transformation to convert output into an HTML Table
  (use this to import to an older Excel spreadsheet that does not have native XML support)

Download (Previous Versions):

• Sharepoint Database Exporter (v1.1.0.0) - Binaries Only
• Sharepoint Database Exporter (v1.1.0.0) - Sources and Binaries

• Sharepoint 2007 Database Exporter - Alpha 1 - Binaries
• Sharepoint 2007 Database Exporter - Alpha 1 - Sources and Binaries

• Sharepoint 2003 - Database Exporter (v1.0.0.1) - Binaries Only
• Sharepoint 2003 - Database Exporter (v1.0.0.1) - Source and Binaries

Final Notes:
This work is done on my free time, but I encourage to post bugs and feature requests so I can take a look when I’ll have time.

Also if you made your own modifications, feel free to post them back so I can integrate them, of course giving you the credits for what you’ve done…

56 comments