Project Description
Export version history can be used to export the version history of SharePoint 2010 List items to Microsoft Excel. It provides button in Ribbon to do bulk export and also in the ECB menu to export single items.
Deployment steps:
Go to the site collection where you want to activate the feature. The feature is scoped at Site collection level.
Usage:
Create a Task List and enable versioning in this list. Add few tasks to it and modify the tasks so that different versions are created.
Export version history can be used to export the version history of SharePoint 2010 List items to Microsoft Excel. It provides button in Ribbon to do bulk export and also in the ECB menu to export single items.
UPDATE 9/5/2013
On popular demand I have included two more features in Export version history.
- Export View Version History - Exports all items present in current view.
- Export List Version History - Export all the items present in the list.
CAUTION: The application may slow down as the number of items in a view/list increases along with the number of versions supported by the list.
Adding Solution:
stsadm.exe -o addsolution -filename C:\NY.ExportVersionHistory.wsp
Deploy Solution:
stsadm.exe -o deploysolution -name NY.ExportVersionHistory.wsp -immediate -allowgacdeployment
stsadm.exe -o addsolution -filename C:\NY.ExportVersionHistory.wsp
Deploy Solution:
stsadm.exe -o deploysolution -name NY.ExportVersionHistory.wsp -immediate -allowgacdeployment
Export version History feature will be available in all types of lists like, Custom Lists, Tasks Lists, Document Libraries, Calenders etc as it is associated with item content type.
For a user to use Export Version History, ViewListItems permissions are required.
The Export Version History button in the ribbon is enabled only, if the current list has versioning enabled and at least one item is selected in the list view webpart. Similarly ECB Menu item for exporting version history of an individual item is available only when the given list has versioning enabled.
Create a Task List and enable versioning in this list. Add few tasks to it and modify the tasks so that different versions are created.
Select the items to export.
Following is the exported file in Excel:
Single item can be exported either from ribbon or also from ECB Menu item as shown:
Export version History behaves exactly the same way as Out of the box Version History works, that is:
- It only shows modified fields in each version.
- It shows versions based on draft item security.