Solved

Showing documents based on a list

Posted on 2001-09-18
8
207 Views
Last Modified: 2013-12-18
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...
0
Comment
Question by:Freerider
  • 2
  • 2
  • 2
  • +1
8 Comments
 
LVL 4

Accepted Solution

by:
sloeber earned 50 total points
ID: 6489905
The best thing you can do is make an extra field
name it ErrorList or something like that.
In you agent, the moment he found an error in the document, change the value from that field to Yes
thisdocument.ErrorList = "Yes"

Make a new view, named eg. ==> "Errorview"
With selection Select ErrorList = "Yes"

Now, you see all the document with an error.

PS : Dont forget to change the value back to No, when you solved the problem.
0
 
LVL 13

Expert Comment

by:CRAK
ID: 6489987
You could also copy or move those document to a folder.
0
 

Author Comment

by:Freerider
ID: 6490317
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.
0
Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

 
LVL 4

Expert Comment

by:sloeber
ID: 6490458
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.
0
 
LVL 13

Expert Comment

by:CRAK
ID: 6490620
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...!?
0
 
LVL 5

Expert Comment

by:snocross
ID: 6491691
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
0
 

Author Comment

by:Freerider
ID: 6492657
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.
0
 
LVL 5

Expert Comment

by:snocross
ID: 6493222
Ok, thanks for the info...
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Word Pro Conversion utility 13 35
Mobile Iron iphone stop receiving new mails 6 1,375
Send a link through lotus notes automated mail 11 152
Migrating from Lotus Notes to Office 365 2 148
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question