Lotus Script to send alerts for missing docs

Posted on 2007-10-16
Last Modified: 2013-12-18

Can someone provide a LS agent that will do the following:

Look to a view to determine "users" (Depositors) needing an alert
Look to a view (Activity Reports) that displays documents, categorized by week (monday date)

Send each individual alert when documents are missing?  Using the last Monday date in the view (Activity Reports) and based on the prior week (this agent will run at the start of the current week, so reports are not yet due) a less complicated way might be to count the number of weeks (reports) from last date in view, to prior week of current week the agent runs, and if they don't match -- then send an alert.  Ideally if which reports can be identified (weeks) that is better -- but not critical.

This is urgent.  Thanks!!
Question by:AliciaVee
    LVL 63

    Expert Comment

    SO all the depositors get alerts, or only those that have relevant documents.

    Please supply more details.


    Author Comment


    Sorry -- wasn't clear. Only users that are missing reports get an alert.  I have a view that determines depositors (this is used for something else) -- not categorized, sorted on first column

    Person 1
    Person 2
    Person 3

    I have a view that has all reports, sorted by date, with name of person in 2nd colum

    So, if Person 2 only has 2 reports, but should have 3, they should get an alert.  Ideally, would like the dates to be listed (you are missing reports for the following dates:.....) but I'm having enough trouble trying to get this to work, I'm not sure it is even possible at this point.  Can you help?
    LVL 31

    Expert Comment

    How is this different than the earlier question you asked, when you started off assuming you could use a sort of "reverse newsletter"?

    Author Comment


    The only difference is the way i have explained it -- the need is the same, or maybe now a bit simpler (not critical to provide the exact dates missing).  I haven't received a solution -- I tried using your suggestion, but am still lost / stuck on how to resolve.  I thought if I presented another question, with a clearer explanation, I might get new folks providing a solution.  Not sure this is working either.
    LVL 31

    Accepted Solution

    Code I gave you should work, as I recall, you just needed to add the paqrts that would:

    1) retrieve list of users to process
    2) loop through that list, running the second half of the code for each run through the loop (i.e., once per user)
    LVL 1

    Expert Comment

    Forced accept.

    EE Admin

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
    I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now