we have realized recently at a customer's that worklow history is disappearing, which is, as we know (now :(), by design, but we need to get the lost workflow history back. We restored the necessary web app from a 2 months old backup, the history is present there, but we cannot find any way to copy it to the actual site. The documents and libraries are the same (remember, I use a backup of a current web app). We cannot simply use that backup, because it is 2 months old. We tried - in a test environment - also some database operations, but no luck. This wouldnt be acceptable in a production environment anyway. Any help would be very appreciated. Regards, Ravie.
3 Answers
What version of SharePoint are you using? If SharePoint 2010, you should be able to browse the content of database offline and able to export required items from there and then import it back to you live site.
If you want to disable the history clean up operation, you can do it. Visit this for more information: http://technet.microsoft.com/en-us/library/ee662522.aspx
Also, if you want to migrate items from one list to another, you can try using SharePoint Content Migration Wizard: http://spdeploymentwizard.codeplex.com/. I would suggest that you evaluate the configuration settings available while doing the export/import with this tool. The options are same as available with STSADM's -export -import operations.
answered Oct 29, 2010 at 14:23
-
WSS3. We disabled the cleanup, but this does not bring the history :) Finally, we solved it thanks to this thread: social.msdn.microsoft.com/forums/en-US/sharepointworkflow/…– user1667Commented Nov 1, 2010 at 8:24
If you are able to restore the backup to another location, you should be able to iterate through the workflow history using web services and write that data anywhere it's needed. Have a look @ spservices.codeplex.com for a head start.
answered Oct 29, 2010 at 11:02
-
Thank you, I wonder if you could be more specific? Which function do you suppose would fit our needs? Thanks again. Ravie.– user1667Commented Oct 29, 2010 at 12:30
-
I would start by looking at the UpdateListItems operation: spservices.codeplex.com/… Once you grab the item info from the list, you can then update the other list with that information. Make sense? Commented Oct 29, 2010 at 16:42
-
It's probably good to note, your best bet for reporting from Workflow is to write the events directly to an audit list. That way you can control the information and not have to worry about it being automatically deleted. Here's an example too: endusersharepoint.com/2010/08/05/… Commented Oct 29, 2010 at 17:07
We managed to create a feature that would show the WFL history, thanks to this: http://social.msdn.microsoft.com/forums/en-US/sharepointworkflow/thread/b15b27e2-3033-418b-9731-968273d7423e/