Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.

share|improve this question
add comment

3 Answers 3

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.

share|improve this answer
    
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/… –  user1667 Nov 1 '10 at 8:24
add comment

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.

share|improve this answer
    
Thank you, I wonder if you could be more specific? Which function do you suppose would fit our needs? Thanks again. Ravie. –  user1667 Oct 29 '10 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? –  iOnline247 Oct 29 '10 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/… –  iOnline247 Oct 29 '10 at 17:07
add comment
up vote 0 down vote accepted

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/

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.