Tips

Tips

• @Unique and @Elements for LotusScript

  The @Unique function in formula is a handy way of removing duplicates. This LotusScript function allows you perform the same function in LotusScript.  Continue Reading

• Copy attachments in LotusScript without detaching

  This procedure copies file attachments from the current Web document to an existing document.  Continue Reading

• Copy names.nsf data and manipulate views

  Create an agent to run in a custom target database with views based on names.nsf data.  Continue Reading

• Upload images into selected documents

  This tip shows you how to import multiple images into a set of selected documents from a folder.  Continue Reading

• Remove unnecessary bookmark icons

  This shows you how to remove unnecessary bookmark icons.  Continue Reading

• Get all email headers using LotusScript

  To prevent repeat spam, the service provider likes us to send the complete headers of the original email so they can analyze it and deal with it -- impossible in Lotus Notes R5.  Continue Reading

• Extract attachments from e-mail

  This agent will help make extracting attachments easier. The agent removes all attachments from the selected e-mails and places them into a folder chosen by the user.  Continue Reading

• Using DXL (Domino XML) to review/modify documents

  This tip shows you how to review/modify documents using DXL (Domino XML).  Continue Reading

• Notes licensing: Not so mysterious

  This article aims to demystify Notes/Domino licensing. I wrote it to help my readers, and also to help myself understand the options more thoroughly.  Continue Reading

• Return ASCII character

  This simple agent allows the user to enter that character, either by copy/paste or by typing, and then returns that ASCII value.  Continue Reading

• What are Notes ID files, and how are they different from regular computer accounts?

  One of the biggest differences between a Notes/Domino system and other software systems is the nature of user accounts  Continue Reading

• Good mail forwarding agent

  This agent copies a new e-mail, strips the CC and BCC fields), inserts the original "Send to" field and then sends the e-mail to any e-mail address specified.  Continue Reading

• Load delimited text file

  This script agent can be used as an alternative to COL files to parse and build Notes documents.  Continue Reading

• Understanding WebSphere Portlets

  If you plan to use WebSphere Portal to provide access to enterprise applications and data, you need to become familiar with the workings of portlets, the building blocks of portals  Continue Reading

• Formula debugger

  There is an undocumented function that is very handy for developers. It's a "formula debugger."  Continue Reading

• Fix client mail rules

  In forums discussing mail rules, a hot topic seems to be, "they just stopped working." This tips discusses how to fix this.  Continue Reading

• Add Admin client without install

  This tip shows you how to add the Admin client to your ND6 Notes client without installing it.  Continue Reading

• Compare field values

  You can use this class to compare field values between two documents.  Continue Reading

• Expand mail folders by default

  This tip show you how to have mail folders expanded when you open your mail database.  Continue Reading

• Use Domino objects in VB to retrieve lists

  This tip gives you code for a form (.frm - VB 6.0) that retrieves a list of Lotus Notes servers and Lotus Notes databases using Domino objects in Visual Basic.  Continue Reading

• LotusScript Floor and Ceiling function

  Since LotusScript does not contain a Floor and Ceiling function, as most languages do, we had to come up with our own.  Continue Reading

• Calculate business days between two dates using Domino directory

  This tip primarily uses LotusScript to calculate business days between two dates using your Domino directory.  Continue Reading

• Run a Web agent on a JavaScript event using any browser

  This article is a "counterpoint" to Luke Leonhard's tip, Run a Web agent on any JavaScript event.  Continue Reading

• JavaScript version of @DBLookup and @DBColumn

  The objective of this tip is to avoid page refreshes while looking up data from the browser.  Continue Reading

• Get all group member names

  This undocumented feature will get all of the names of group members.  Continue Reading

• Check if user is part of a specific group

  Often it is useful to check if the current user is a member of a specific group. The following subroutine allows you to do this.  Continue Reading

• LotusScript library to generate Notes docs in Excel

  I wanted to share a LotusScript library I developed with an OO class description that makes it very easy to use Excel to generate Excel documents.  Continue Reading

• Domino cluster tuning

  Cluster performance tuning will allow you to set the point where a server considers itself "too busy."  Continue Reading

• Meet the Extended ACL

  The dialog box for configuring it is arguably the least intuitive and most complex of any that has ever come out of Cambridge and that is really saying something.  Continue Reading

• Hide parts of forms based on group membership

  Are you tired of writing complicated Hide/When formulas? Try this instead.  Continue Reading

• Retrieve selected documents

  This piece of code helps in retrieving selected documents on the view or the currently opened document.  Continue Reading

• Run a Web agent on any JavaScript event

  Have you ever wanted to run an agent on the Web without having the screen reload? Here is a great solution.  Continue Reading

• Optimize Notes startup for different screen resolutions

  I created a new corporate homepage and found it difficult to optimize it for all screen resolutions.  Continue Reading

• Rich text field workarounds

  Here are two Rich text field workarounds.  Continue Reading

• Create a dynamic table row

  This tip shows you how to create a dynamic table row creation with the help of formula at run time.  Continue Reading

• Solving the decimal separator problem

  Reading a decimal number from a string can bring you a lot of trouble if you support clients with different decimal separators. Here is a simple code to avoid this problem.  Continue Reading

• Closing all objects (WINWORD.EXE)

  How do you shutdown all instances of the WINWORD.EXE without going into the task manager? The answer is very simple -- use the GetObject method to retrieve the object.  Continue Reading

• Dialog list and combo box size limitations

  If your data comes from Domino you can overcome size limitations for the dialog list or the combo box.  Continue Reading

• Link Notes fields with Excel cells

  This is an incredibly easy way to link fields in your Notes document to cells in an Excel spreadsheet  Continue Reading

• Creating a Notes form dynamically

  How to create a Notes form dynamically -- create a form with labels and fields, using LotusScript.  Continue Reading

• Domino and user authentication

  This tip details method used to prevent users from being prompted to enter their name/password several times when attempting to access a database that they do not have permission.  Continue Reading

• All about AdminP Part 1

  AdminP is a program that automates many routine administrative tasks for a Domino environment. This article describes all the components of AdminP.  Continue Reading

• Capture mailbox database size and export to Excel

  Do you have a cap limit on mailbox database size? Have you ever wondered how you could quickly find out the size of all the databases, and then put the data into Excel?  Continue Reading

• Dynamically change background color of a Notes doc

  This tip allows you to change background color on the fly by the user choosing the color on the form itself.  Continue Reading

• Five special characters in DXL

  In XML, there are five predefined entity references used in place of specific characters that would otherwise be interpreted as part of the XML itself.  Continue Reading

• Document unique ID from lookup

  In R6, it's easy to retrieve the document unique ID from a view. @DbLookup has an extra keyword that will return the lookup document unique ID.  Continue Reading

• Simulating dynamic fields and labels

  Often, one must dynamically create labels and fields on the Notes client. This code simulates dynamic fields and labels creation on the Notes Client.  Continue Reading

• Change views selection criteria on the fly

  I was asked to provide a calendar view to users, where they were able to select on the fly what documents were included in the calendar view based on a designated category.  Continue Reading

• Zip from LotusScript in Notes/Domino 6

  LotusScript does not have a native class for compressing files to .zip format -- in this tip, I'll show you how to change that.  Continue Reading

• Find and manage all agents

  This application scans all databases on nominated server(s) and creates reports of all agents found -- including private agents which are normally hidden.  Continue Reading

• Synchronizing your contacts

  This Lotus Notes/Domino utility synchronizes contacts located in your Lotus Notes personal address book with the contacts located in your Domino server based mailfile.  Continue Reading

• Chapter 18: JavaScript and embedded objects

  Get an introduction to what is possible with embedded objects when using JavaScript.  Continue Reading

• Open a Notes database from Word

  This tip shows you step by step how to open a Notes database in Notes client from Microsoft Word.  Continue Reading

• Firefox shortcut to get HTML page info

  Here's a shortcut you can use in Firefox to quickly access HTML page information without having to view source.  Continue Reading

• Create hotspot buttons on the fly using DXL

  Using DXL, learn how to create a hotspot button dynamically and add it to a rich text field on the fly.  Continue Reading

• Using names.nsf undocumented features

  Have you ever wanted to use the "Select Names" Web dialog, as seen in names.nsf and webadmin.nsf in R6.x, in your own R6 Web applications? This tip shows you how to do it.  Continue Reading

• LDAP, Domino and Windows: Making it work

  In this Q&A, Michael Lazar, SearchDomino.com's resident Domino administration expert, answers questions about using LDAP in a mixed Domino and Windows environment.  Continue Reading

• LotusScript error handling

  This tip provides some details about how to write proper error handling routines. It starts with an overview of theory and then presents an example that puts theory into practice.  Continue Reading

• Validating a Notes formula from LotusScript

  This code can be used to validate a Notes formula before using it in an Evaluate() statement or in a call to db.Search(). It will also tell you the offset of any error.  Continue Reading

• Get database by title

  Get a handle to any database anywhere in your Notes environment. This code works by getting the database details from the Catalog, which should be the root and will not move.  Continue Reading

• Open a database to a specific frameset

  Learn how to use formulas to open a database to a specified frameset by setting an environment variable and using computed frames.  Continue Reading

• Modify a rich text field in the UI without having to save and re-open

  With this LotusScript code, you can modify any rich text fields and reflect those changes in the UI without being forced to save the document.  Continue Reading

• Check those LotusScript errors!

  A lesson in proper LotusScript coding.  Continue Reading

• Optimize performance of your LotusScript code

  Ever wondered where the bottleneck is that makes you code so darn slow? With the lsTimer class below, you can easily pinpoint any time-consuming method piece of Lotus script code.  Continue Reading

• Change view design or scheduled agent runtimes

  This LSX lets you use LotusScript to set a parameter doc (NotesDocument) with view criteria (formulas, settings, columns, etc) and then build it.  Continue Reading

• Let users filter any view

  Here's a great little Action (or Agent) that lets a user filter any categorized view based on whichever category they choose.  Continue Reading

• Quickly parse URL parameters

  Tired of cutting out ParentUNID and Count Start when submitting a page from browsers? This function makes a list of parameters and their corresponding values, if any.  Continue Reading

• Monitoring cluster replication

  Domino server clusters are an excellent way to provide for failover in the event of server outage. But they provide little benefit if the data on the servers is not kept in sync.  Continue Reading

• Password expiration for Notes IDs

  You should strongly consider enabling password expiration for Notes IDs. Here are step-by-step instructions on how to do it.  Continue Reading

• A better way to track field changes

  If you really to ensure fields have changed, and in an easy way, don't use computed fields to display -- just use LotusScript.  Continue Reading

• Print all attachments using shellExecute in Windows

  This script prints all attachments on a Notes doc's Body field. You do not need to know the attachment names ahead of time, or the app that needs to be invoked to print them.  Continue Reading

• Calculate U.S. holidays for any given year

  Add U.S. holidays to your server's holiday list with this code.  Continue Reading

• @Word in LotusScript

  This function in LotusScript is equivalent to @Word function.  Continue Reading

• Creating replica stubs

  Creating replica stubs is a good way to distribute small files via your mail system. Here's how to do it.  Continue Reading

• Import from Excel

  This code allows you to import data from an Excel sheet directly (without saving it first as a Lotus 1-2-3 file).  Continue Reading

• The four levels of WebSphere Application Server

  To help you get a handle on the key differences of each, here's a look at the four levels of WAS.  Continue Reading

• Send HTML email with embedded images

  This tip describes how to send an e-mail with HTML and embedded images.  Continue Reading

• Repair local databases on desktop

  This tip explains how to use nfixup and ncompact to repair local DBs on a desktop such as PAB and a local archive.  Continue Reading

• Finding and disabling hidden return receipts

  This tip explains how to find and disable hidden return receipts.  Continue Reading

• Delete current viewing document over the Web

  This tip explains to use @Formulas and @Commands instead of LotusScript to delete a current document on the Web.  Continue Reading

• Andre Guirard on Java vs. LotusScript

  We asked SearchDomino.com expert and IBM Lotus developer Andre Guirard which was better -- LotusScript or Java. His response -- "They're each better than the other one."  Continue Reading

• Efficient use of deny lists

  This month's security tip presents some ideas for using deny lists efficiently.  Continue Reading

• Easy steps for monitoring application size

  Karen Fishwick, author of Exam Cram 2: Lotus Notes and Domino 6 System Administrator, offers methods and tools to help you control, minimize and monitor the size of your DB.  Continue Reading

• Domino Web traffic analyzers

  Chuck Connell offers his product comparisons and recommendations on Web log traffic analyzers for Domino.  Continue Reading

• Recycle the right way

  Find out the right way to recycle Java objects.  Continue Reading

• The best $$ReturnGeneralError

  How to make integrated error handling look nice in a Domino Web application.  Continue Reading

• Getting mail.box database

  A warning on which DB to look for when sending mails using LotusScript and making the doc directly in mail.box.  Continue Reading

• Programmatically create HTML e-mails

  Learn how to create HTML email in Lotus Notes programmatically.  Continue Reading

• Categorizing views based on related multi-valued fields

  How to show related multi-valued fields sorted in a view.  Continue Reading

• Setting mail quotas

  This is the first in a series of admin tips by Domino book author Karen Fishwick, including her latest Exam Cram 2: Lotus Notes and Domino 6 System Administrator.  Continue Reading

• Build list of views, and open selected view via LotusScript

  How to build a list of all views in the current DB and then open the selected view in the specified frame within a frameset.  Continue Reading

• Sorting search results

  How to sort search results in ways other than the three options given: relevancy, oldest or newest.  Continue Reading

• Drive away the incorrect unread mail count problems

  How to fix the occasional problem of incorrect unread mail count on the database icon in Notes' workspace.  Continue Reading

• Printing message tracking results

  How to print the results of a message track.  Continue Reading

• Delete a collection of documents

  How to exclude documents in a collection that will cause an error when a user tries to delete the collection.  Continue Reading

• Sort collection like a view

  How to sort a collection the same way a view is sorted.  Continue Reading

• DateTime problem solved in agents

  How to solve problems with dateTime in LotusScript agents running on the server with different dateTime settings.  Continue Reading

• Creating sequence numbers

  How to create numbers in sequence in a workflow application.  Continue Reading

• Check public key for Notes IDs

  This tip illustrates the importance of the Check public key feature, especially in conjunction with Check password.  Continue Reading

• Using the open DB dialogue box to get DB paths and RepID

  This tip describes how to link DBs together without hard coding the DB paths.  Continue Reading