Add a program doc to compact Lotus Notes databases automatically

This is a useful workaround for external salespeople with large local replicas, for example. These users need to simply leave their computers on at night for the doc to compact all of their Lotus Notes databases. This is easier than sending out batch files that require users to sign in and close their Lotus Notes clients.

To get started, follow these steps.

1. Create a copy of the pernames.ntf
2. Copy the Server\Programs view from your Public Address Book (PAB) template and paste it into the pernames.nsf. Rename this: Programs.
3. Copy the Server\Program form from the Public Address Book (PAB) template and paste it into the pernames.nsf. Rename this: Program.
4. Create an agent called Program Doc.
5. Set the form selection to equal the Program form; the field CmdLine should not contain -A.

Note: The latter is important because if you use local archiving, a program doc is created automatically when you set up local archiving. You can check this initially by opening the hidden view $Programs. If you use local archiving, or have in the past, you will one there showing Compact -A.

6. Add this Formula language code to your agent:
7. Set the runtime to Agent List Selection, and set it to run on All Documents in Database.
8. In the Programs view, add an action called Create Program Doc with a button using the following Formula language code:
9. In the "Hide Action When Formula is True", put this code in:
10. Finally, replace the design of your PAB with the new template. Instead of seeing pernames.nsf, you should see the new copy of pernames.nsf. Go to the "Programs" view and click on the button. Your program doc is now set to run Compact -B daily at 2 a.m. on your local machine.

Do ...

To read more you must become a member of SearchDomino.com

As an existing member of the TechTarget network please activate your SearchDomino.com account 

By joining SearchDomino.com you agree to receive email updates from the TechTarget network of sites, including updates on new content, magazine or event notifications, new site launches and market research surveys. Please verify all information and selections above. You may unsubscribe at any time from one or more of the services you have selected by editing your profile or unsubscribing via email.

TechTarget cares about your privacy. Read our Privacy Policy

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Database LotusScript code rebuilds corrupted busytime.nsf file How to move Notes databases off Domino 8 servers and save disk space Top 10 Lotus Notes/Domino administration tips of 2008 Batch file runs scheduled Lotus Notes database maintenance tasks Fix and update Lotus Notes documents with limited access Programmatically replace the design of Lotus Notes databases More efficient local Lotus Notes database replication Remove orphaned Lotus Notes documents on Domino databases with a 'virtual delete' Detect and fix 'Manager' access control list settings in Lotus Notes Domino Copy Lotus Notes databases from the Domino Server console command line Lotus Notes Domino Database Management LotusScript agent parses ACL to Microsoft Notepad Domino Domain Monitoring hints and gotchas LotusScript code rebuilds corrupted busytime.nsf file LotusScript agent automates selective mail file replication Configuring Domino Domain Monitoring (DDM) How to move Notes databases off Domino 8 servers and save disk space What is Notes 8.5's DAOS (Domino Attachment and Object Storage) feature? LotusScript agent indexes Lotus Notes/Domino databases An introduction to Domino Domain Monitoring (DDM) 'Customize this view' options are disabled in Lotus Notes databases Lotus Notes Domino Formula Language View hidden fields on Lotus Notes/Domino forms Case-insensitive @Unique version combines fields on Lotus Notes forms Do I use Formula or LotusScript to include a doclink to a Notes view? Top 10 Lotus Notes/Domino coding and development tips of 2008 Provide rich-text formatting via the Profile document and Formula Top 10 Formula language tips Using Formula language code to sort Lotus Notes messages by subject How to create dynamic JavaScript in Notes Domino without formulas Stop response documents from showing in a Lotus Notes form Formula language button manages Deny Access list searches

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

you have comments on this tip? Let us know.

This tip was submitted to the SearchDomino.com tip library by member Justin Eiseman. Please let others know how useful it is via the rating scale below. Do you have a useful Lotus Notes, Domino, Workplace or WebSphere tip or code snippet to share? Submit it to our monthly tip contest and you could win a prize.

Rate this Tip To rate tips, you must be a member of SearchDomino.com. Register now to start rating these tips. Log in if you are already a member. Submit a Tip DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.