Tuesday, May 26, 2009

Monday, May 4, 2009

export of a versioned list neglects data (WSS v3)

The use of versioning is typically very important to users. At one of my engagements using WSS V2, the IT group discouraged the use of the versioning feature since the storage mechanism (inside WSS) was very inefficient.

In WSS V3 the storage mechanism for versioning was improved and some very nice additional user features for versioning were added. Basically these are: 1) tracking versions by individual meta-data 2) alert notifications showing the old and new values.

Now I have just found out that one feature in V2 was deprecated by these changes. If you export a versioned list to Excel, only the latest version is exported. Apparently this is also true for content deployment in ECM. A user has told me that this exported all data (including previous versions) in WSS V2.

Unfortunately the only work-arounds I have found so far involve code. :-(

I have made some web services code to dump the previous versions. This was written in C#. Another approach is to write an Object Model program to address this limitation. Either approach can be written in C#, VB.Net or PowerShell.

Regards..