Advertisement

05.09.2008 at 07:35AM PDT, ID: 23389473
[x]
Attachment Details

Emotying POFU folders

Asked by dragon-it in Lotus Notes, Lotus Domino Email Server

I have an application I am writing a search screen for which is fine.  I collect the documents together into document collections using db.search etc., which is fine and plenty fast enough for what is required.  I then put the resulting dc into a shared POFU folder to display embedded in the form to the user before exporting to a complex Excel format they require....  This folder is then used as the source of the data for the Excel report and is sorted into the way required for the exported worksheet by further LS code.

We are working on lowest common denominator, R5(.08!) at the moment...

If the users change their search criteria I clearly need to clear the search folders before the next search is added to them.  At the moment i do it like this:

Set searchfolder=db.getview(foldername)
Set vec=searchfolder.allentries
Print "Removing old documents from folder"
counter=counter+1
SetStatus "Removing old documents from folder for .... report",counter
If vec.count >0 Then Call vec.RemoveAllFromFolder(foldername)

The delay here can be quite long once no. of docs gets 500-1000, it often takes longer to clear the folder than to search the db. for the results they want, and because of the format required I have to keep two foldes - one "unfiltered" being their raw data choice and then a second based on effectively a manual join with another view to remove documents from certain criteria that is used for different parts of the Excel reports.

No I wouldn't have designed the db like that but it is there and that can't change!

On quite  few occasions it will come back with "the network operation did not complete in a reasonable time" while clearing the folders

So.... is there any other way of clearing such a folder more quickly that I have missed?  If I step through a loop of documents and remove each then that is of course even slower.  Removing the private folder itself is an option (I use this with some versioning code in QueryOpen to determine if the user's version of the folder is out of date) but how can I then get LS to be able to re-create the POFU folder, at the moment it prompts the user saying design has changed, closes the uidoc and asks them to re-open.  If I don't do this then the embedded folder shows as the design of the default view in the db instead of the correct POFU one.

It's Friday afternoon and any suggestions welcome, if I don't respond straight away sorry but will come back soon as I can.

thanks

SteveStart Free Trial
 
Loading Advertisement...
 
[+][-]05.09.2008 at 08:20AM PDT, ID: 21533762

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Lotus Notes, Lotus Domino Email Server
Sign Up Now!
Solution Provided By: fgrushevsky
Participating Experts: 1
Solution Grade: A
 
 
[+][-]05.10.2008 at 04:18AM PDT, ID: 21538503

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.14.2008 at 03:00PM PDT, ID: 21569091

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_EXPERT_20070906