I have this problem and I’m looking for a solution. An agent was run on our database to delete duplicate documents and what it actually did was change some response documents of parent documents and add them to other documents as responses. We have nearly a million documents in our database and don’t want to check every single document and change back the resonse documents to their correct parent document. This is what was done before. Is there any easier way of doing this??? Appreciate any help… (desperate!!)
Subject: RE: Response documents gone to wrong parent documents
Changing which document is the parent is the easiest part of the job. You can readjust the response relationships using MakeResponse method in LotusScript or Java – don’t forget to Save also.
The more complicated part of the task is the part you’ve given us no information about – determining which responses are attached to the wrong parents and locating the right parents. Assuming you have a way to do these things automatically, you’re all set. If you can’t think of a way to automate this decision-making process, then that’s the part you need help with.
Subject: RE: Response documents gone to wrong parent documents
Hey Andre, thanks for your reply… I’m basically just trawling through every document in a document collection based on the previous month which the job that created the problem ran on (a db search). I then do a db search based on some details on the document like form name, some fields with names and one field that I know will be different because of the wrong parent, then I create the response doc with the makeresponse and save… the issue i’m having is the sheer volume of processing??? Any ideas?
Subject: RE: Response documents gone to wrong parent documents
Mickey,
If you know the date and time the agent ran, assuming other documents were not amended and saved, could you not just identify the documents using the last modified date?
Subject: RE: Response documents gone to wrong parent documents
So what you’re really asking is how to search a database efficiently? If so, I’ve written about that at some length in my blog, so you can have a look at that. There are many ways to search, appropriate for different situations.
Or, if you’re asking whether there’s a more efficient algorithm than what you are doing, I still don’t feel I understand the task well enough to say. Probably there is.