Link to home
Start Free TrialLog in
Avatar of Freerider
FreeriderFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Showing documents based on a list

I have an agent which checks a database for errors. When it is finished, it creates a text file of all the document IDs which have an error in them.

I would like to see these documents in a view, rather than have to check the list and search for the document.

Does anyone have any ideas about the best way of doing this?

If the agent identifies the docID, could it then somehow add that document to a view?

Thanks for your help...
ASKER CERTIFIED SOLUTION
Avatar of sloeber
sloeber
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of CRAK
You could also copy or move those document to a folder.
Avatar of Freerider

ASKER

sloeber,

this solution works very well, although there's a bit of work involved (creating the field and populating it for 4000 documents). The problem is, I'm quite sure the person who will correct these documents will NOT remember to change the ErrorList field to "NO". Although I could add it to a button to save and close the document...

anyway,

CRAK,

as long as the moved documents are still visible in the existing views - the formula is something like:

 SELECT Form = "Document"

I would prefer to use this method. Using script, how can I move a document to a folder?

Andrew.
Just use
Call doc.PutInFolder(foldername,True)


If the folder exist he copy your document to this folder else he makes a new folder for you.

!!!!! Now, if the user solved the problem, the document is also still in the folder until he removes the documente from the folder.

Or another solution is that you clear the folder every day, and run the agent to find the errors, every day again.
That's exactly how it works sloeber!
Nice teamwork!

Freerider,
sloebers instruction "PutInFolder()" will keep the document in the original view(s), just as you want. If you have collected all documents in a collection, DocumentCollection.PutAllInFolder(FolderName, CreateOnFail) could be an alternative.

When the documents are no longer required in the folder, either after processing or at a specified interval, use Doc.RemoveFromFolder(name). I probably don't have to warn you about deleting the document...!?
Avatar of snocross
snocross

Freerider, I'm just curious but are you able to gather what type of error happened on each document or just the basic fact that an error occured?  If so then I will provide points to figure out how you did that.  I would like to create a list of all documents in my database that have input validation errors in them and what the error is.

-Snocross
snocross,

I'm only looking for specific errors. There's a field in each document which should contain the attachments. The agent looks at the other fields and checks for attachments, if it contains one, it's an error.

Sorry I couldn't be of more help.
Ok, thanks for the info...