Ask the Experts

Ask the Experts

• Calculating results for a column in a Lotus Notes view

  Find out what types of calculations can be computed for a column in a Lotus Notes view and the best way to go about it with this expert response.  Continue Reading

• Can I create and copy Microsoft Excel spreadsheets with LotusScript?

  Learn how you can use LotusScript and OLE to create and populate Microsoft Excel spreadsheets, as well as a little bit about Lotus Symphony.  Continue Reading

• Can you use LotusScript to read a text file attached to a Notes doc?

  A user wants to know if it's possible for LotusScript to read an attachment in a Notes document without first detaching it. Find out our expert's response here.  Continue Reading

• Do I use Formula or LotusScript to include a doclink to a Notes view?

  Find out why you can't use Formula language to include a doclink to a specific Lotus Notes view or database and need to use LotusScript instead.  Continue Reading

• Customize the principal field of outgoing email messages

  Learn about different options using LotusScript code and Formula language to customize the principal field of outgoing Lotus Notes email messages.  Continue Reading

• Resolve Notes 8 migration error: 'Database has not been opened yet'

  Upon moving to Lotus Notes 8, some Lotus Notes users received an error message stating: 'Database has not been opened yet.' Find out why here.  Continue Reading

• Give external users access to workflow-based Notes Domino applications

  Discover options you can use if you'd like external users to be able to access a workflow-based Notes Domino application through different configurations.  Continue Reading

• JavaScript error encountered when opening Lotus Notes email

  Learn why you may be encountering a JavaScript error messages when opening HTML-formatted email messages in Lotus Notes.  Continue Reading

• Track incoming and outgoing Lotus Notes email messages

  Learn how to easily keep track of the numbers of incoming and outgoing Lotus Notes email messages to and from your Domino server each day.  Continue Reading

• Can I use LotusScript to merge cells in a Microsoft Word table?

  Read about merging cells in a Microsoft Word table using LotusScript and an Excel example, along with the thought process that goes along with it.  Continue Reading

• Lotus Notes access error: 'database is not opened yet'

  Discover what security settings you need to fix if you encounter the Lotus Notes database error: 'database is not opened yet.'  Continue Reading

• Stop response documents from showing in a Lotus Notes form

  Learn the Formula language code that you can use if you'd like your Lotus Notes form with embedded views to stop displaying all response documents.  Continue Reading

• Repair Lotus Domino server 'Cannot write or create file' error

  Discover what steps you can take if your Lotus Domino server runs out of disk space and you have issues sending and receiving Lotus Notes email messages.  Continue Reading

• Set a value in a field existing in another Lotus Notes database

  Learn the LotusScript code you'll need to use to set a value in a Lotus Notes field that resides in a different Lotus Notes database.  Continue Reading

• Create an automatic scheduled view export in Excel

  Learning how to create an automatic scheduled view export in Microsoft Excel can be a daunting task, but here are some suggestions to do just that.  Continue Reading

• Display Lotus Notes fields as separate entries in one column

  Read about what you'll need to do to display multiple Lotus Notes fields in a single column as separate entries.  Continue Reading

• What is slowing down my Domino server?

  Learn how to combat slow Domino server performance because of a Notes Domino tool using a lot of your CPU.  Continue Reading

• Limit the size of incoming email attachments to a Lotus Domino server

  Learn a few options you can use to limit the size of imcoming email attachments to you Lotus Domino server.  Continue Reading

• Modifying LotusScript code for date and time handling

  Discover some LotusScript code that can be implemented to forward Lotus Notes email messages at specific times.  Continue Reading

• Use LotusScript to create encrypted replicas

  Learn about Lotus Notes database encryption and the levels it can be set at on locally created replicas using LotusScript.  Continue Reading

• Write a LotusScript agent to automate file attachments

  Learn how to create a private, automated LotusScript agent to automate both file attachment and detachment.  Continue Reading

• Creating custom Lotus Notes Domino login forms

  Learn how to create custom login forms for authentication of Lotus Notes usernames and password fields.  Continue Reading

• Using LotusScript to retrieve names of fields on a Lotus Notes form

  Learn what steps to take -- and some code to go along with it -- to retrieve names on a Lotus Notes form using LotusScript.  Continue Reading

• How many BlackBerry clients can connect to a Domino server at once?

  Get some Notes Domino and BlackBerry deployment advice and learn why BlackBerry smartphones connect to a BES instead of a Lotus Notes Domino server.  Continue Reading

• Programmatically edit a rich-text field table from within the Lotus Notes client

  Learn about an add-on Domino developers can use to programmatically edit rich-text field tables from within the Lotus Notes client.  Continue Reading

• Troubleshooting Lotus Notes Domino tabbed table problems

  Web Development expert Jens Bruntt outlines three potential issues to consider when troubleshooting Lotus Notes Domino tabbed table problems.  Continue Reading

• Troubleshooting a scheduled agent not running on a Global Notes Architecture (GNA) server

  SearchDomino.com LotusScript expert Cregg Hardwick provides extensive troubleshooting guidelines to a Lotus Notes developer trying to run a scheduled agent on the Global Notes Architecture (GNA) server.  Continue Reading

• Setting up local replication of a Lotus Notes database for offline employees

  SearchDomino.com LotusScript expert Cregg Hardwick explains how to set up local replication of a Lotus Notes database, so employees can access it even if they're offline.  Continue Reading

• LotusScript to extract and move attachments to a Lotus Notes mailbox or file folder

  SearchDomino.com LotusScript expert Cregg Hardwick explains how to extract and email attachments to a Lotus Notes mailbox or file folder of your choice using LotusScript code.  Continue Reading

• Copying a rich-text field with attachments to a Lotus Notes document

  SearchDomino.com's LotusScript expert Cregg Hardwick offers troubleshooting advice to a LotusScript developer trying to copy a rich-text field with several attachments to another Lotus Notes document using the "CopyItemToDocument" and "AppendRTItem"...  Continue Reading

• How to convert Lotus Notes documents to .PDF files

  SearchDomino.com LotusScript expert Cregg Hardwick offers several options to a Lotus Domino administrator and developer looking to convert Lotus Notes documents to .PDF files.  Continue Reading

• Determining the access level of a Lotus Notes user using Formula language

  Learn how you can determine the current access level of a Lotus Notes user by using a simple Formula language cheat code or the NotesACL object.  Continue Reading

• How to enable communication between multiple Lotus Sametime servers

  SearchDomino.com Sametime administration expert Mathew Newman explains-step-by-step how to enable communication between multiple Lotus Sametime servers. You'll learn how to configure your Notes/Domino environment so that clients on one Lotus ...  Continue Reading

• No one can see Lotus Sametime user is online

  A Lotus Sametime user is online, but no one can see her. SearchDomino.com's Sametime administration expert Mathew Newman expert explains how to troubleshoot this problem.  Continue Reading

• Slow Domino server performance and failure on agent managers

  Lotus Notes and Domino Server administration expert Mike Lazar explains how to resolve Lotus Domino Server performance problems and agent manager failures.  Continue Reading

• Routing and replication issues with remote Lotus Domino servers

  Lotus Notes and Domino Server administration expert Mike Lazar offers advice to an administrator who is having weekly routing and replication issues with remote Lotus Domino servers.  Continue Reading

• Replication best practices for Lotus Domino disaster recovery

  When using Lotus Notes database replication for disaster recovery purposes, find out what data you need to include for full recoveries.  Continue Reading

• Lotus Notes error: 'Your current ID does not specify an Internet certificate for signing'

  Lotus Notes and Domino expert Mike Lazar explains the cause and solution to the error: "You have requested to sign this Internet message, but your current ID does not specify an Internet certificate for signing."  Continue Reading

• How to make computed fields recalculate

  When Notes/Domino developers say they want to "update the fields" in tha Lotus Notes view, they usually mean that they want to cause computed fields to recalculate. SearchDomino.com development expert Andre Guirard explains the process and offers ...  Continue Reading

• Accessing documents in a Lotus Notes database

  Notes/Domino development expert Andre Guirard offers a new Notes/Domino developer and DBA some advice on accessing documents in a Lotus Notes database.  Continue Reading

• Adding an action to the Lotus Notes right-click menu

  SearchDomino.com expert, Andre Guirard explains how to add an action "call" to the Lotus Notes right-click menu.  Continue Reading

• How to parse the user activity of a Lotus Notes database

  SearchDomino.com expert Cregg Hardwick Explains how to parse the user activity of a Lotus Notes database using LotusScript.  Continue Reading

• How to modify a Lotus Notes signature file using LotusScript

  Learn how to modify a Lotus Notes user's signature using LotusScript.  Continue Reading

• Changing timeout intervals for Domino Web Access authentication

  Learn how to change authentication timeout interval for Domino Web Access logins.  Continue Reading

• Creating and saving a $Links field in the back end

  SearchDomino.com expert Cregg Hardwick offers advice to a Lotus Notes developer trying to create and save a $Links field, and explains potential reasons for doclink failures.  Continue Reading

• Scan all Lotus Notes databases using a LotusScript agent

  SearchDomino.com expert Cregg Hardwick provides LotusScript code that will allow you to access all the Lotus Notes databases on a machine.  Continue Reading

• Calling a LotusScript agent

  SearchDomino.com expert Cregg Hardwick provides code that will call a LotusScript agent.  Continue Reading

• Reducing the size of an .NSF using Lotus Domino compression

  Learn how to reduce the size of a .NSF file to save disk space using Lotus Domino compression.  Continue Reading

• Finding the properties of a doclinked Lotus Notes document

  SearchDomino.com expert Cregg Hardwick explains different options for retrieving the properties of a doclinked Lotus Notes document in Domino R5 or Domino R6.  Continue Reading

• How to override default Lotus Notes print settings

  Discover how to override default Lotus Notes print settings using LotusScript, Formula language or XML.  Continue Reading

• Keeping an editable number field blank in a Lotus Notes document

  SearchDomino.com expert Cregg Hardwick explains how to keep an editable number field blank (not zero) when a user edits a Lotus Notes document.  Continue Reading

• Manipulating the replication and form of profile documents

  SearchDomino.com's expert Brian Mahoney explains how to work around the default replication and form parameters of profile documents, so that the master copy can be different than the local replica.  Continue Reading

• FQDN or IP address in destination server?

  I have a questions about Notes client connection documents. In the Advanced tab under Destination server address, what are the pros and cons of using the server's FQDN or its IP address?  Continue Reading

• Why does new Domino server keep corrupting my log.nsf file?

  I have a brand new Domino server, installed about two weeks ago, running Domino 6.5.4 FP2. I have over 500GB free space and 2GB of RAM, tons more than Domino needs to run efficiently. My log.nsf has corrupted five times since I installed the server....  Continue Reading

• Script to import Excel rows as separate Notes documents

  How can I write a script to import all of the Excel rows into Lotus Notes as one document for each row of the Excel sheet?  Continue Reading

• Unlocking a locked WordPro file

  I am a CLS Notes developer and I had been approached by my boss to see if I would be able to open a WordPro file that is locked. The person who locked it does not know how he did so. He created this file at home and e-mailed it to himself so that he...  Continue Reading

• How to refresh all Lotus Notes documents via a background agent

  SearchDomino.com expert Brian Mahoney helps a Notes/Domino programmer select a method to refresh all documents in a Lotus Notes database via a background agent.  Continue Reading

• Trapping the on-click event of a radio button

  SearchDomino.com expert Andre Guirard explains how to trap the on-click event of a radio button in a Lotus Notes client application.  Continue Reading

• Copying a form object using LotusScript

  How to copy a form object from one database to another using LotusScript.  Continue Reading

• Connecting to a remote DB2 server with LEI

  SearchDomino.com expert Andre Guirard offers advice to a Domino developer on how to connect to a remote DB2 database server using LEI.  Continue Reading

• JavaScript causing errors in Lotus Notes client

  SearchDomino.com expert Andre Guirard troubleshoots why JavaScript might cause errors in the Lotus Notes client when a document has been submitted and is stored in the Notes client.  Continue Reading

• Creating an 'After new mail is delivered' agent

  SearchDomino.com expert Cregg Hardwick explains how to develop and maintain an "After new mail is delivered" Lotus Notes agent.  Continue Reading

• How to create connection documents for a Lotus Notes Personal Address Book

  SearchDomino.com expert Cregg Hardwick explains how to create new or updated connection documents to a Notes/Domino Personal Address Book.  Continue Reading

• Error restoring an NSF archive file: 'File truncated - file may have been damaged'

  SearchDomino.com expert Chuck Connell helps a Lotus Domino administrator troubleshoot a "File truncated – file may have been damaged" error when attempting to restore an archived NSF file.  Continue Reading

• Importing data from Microsoft Excel to a Lotus Notes form

  SearchDomino.com expert Brad Balassaitis explains how to use LotusScript to dynamically import data from an Excel spreadsheet to a Lotus Notes form with a dialog list formula.  Continue Reading

• Error creating product object

  A Lotus Domino developer is receiving the error, "Error creating product object" when trying to connect to a DB2 table using an LCLSX agent. SearchDomino.com expert Brad Balassaitis explains how to track down the source of the error.  Continue Reading

• Opening Notes document from cmd prompt

  A developer wants to know how to open a Notes document from the cmd prompt.  Continue Reading

• Impact of user manually compacting mail database

  This administrator wants to know the impact of an individual user manually compating their mail database.  Continue Reading

• How to rename a server

  This user wants to know how to rename a server.  Continue Reading

• Can I use Formula to get value of category that a doc is in?

  A user needs to get the value of the category a document is in, and wants to know if he can get this value using Formula.  Continue Reading

• HTML link works even though HTML text is ignored

  This developer is trying to send an HTML anchor link, and wants to know why the HTML text is ignored, shows as source code, and yet the link still works.  Continue Reading

• Back-end replication between two domains not working

  This administrator has a replication issue between two servers in two domains. Front-end replication works fine, but when replication is initiated through server console, it does not work.  Continue Reading

• Calculating size of database

  This Lotus Notes user wants to know how to calculate the exact size of a database.  Continue Reading

• Does a Notes file have a maximum size?

  This person wants to know if a Notes file can be of unlimited size, or is 64GB the maximum.  Continue Reading

• Can creation date (@created data) of Lotus Notes document be modified?

  A user wants to know if the creation date (@created data) of a Lotus Notes document can be modified.  Continue Reading

• Creating Lotus Archive profile in background in R6

  A developer moving from R5 to R6 wants to know if it is possible to create the Lotus Archive profile in the background in the new version.  Continue Reading

• Create several response documents after main doc is created

   Continue Reading

• Is LotusScript needed to validate fields on form?

  A Lotus Notes developer wonders if he needs to learn LotusScript to resolve a problem that stems from trying to validate several fields on a form.  Continue Reading

• Create dynamic table in Domino Designer 6

  This Domino Designer 6 user wants to create a dynamic table so that a user can insert or remove lines.  Continue Reading

• Error locating an entry for Domino certifier

   Continue Reading

• Unable to log into Sametime through Notes with SSO

  In this Ask the Expert, Mathew Newman helps an administrator who's trying to access Sametime by logging in through a Notes client set up with a single sign-on.  Continue Reading

• Moving data (text) from Lotus database to Oracle

   Continue Reading

• Wants to refresh field, not entire form

   Continue Reading

• Using Java API to access folders/objects inside Domino server

   Continue Reading

• Agent cannot encrypt e-mail message

   Continue Reading

• Wants to create view selection formula for documents

   Continue Reading

• Computed subform formula does not work

   Continue Reading

• Uninstall Domino from OS400 iSeries server

   Continue Reading

• Which Notes files should I copy when user changes PC?

   Continue Reading

• Include Domino logs in Windows Event Viewer

   Continue Reading

• Deleting email isn't reducing disk space

   Continue Reading

• Converting Picklist to LotusScript

   Continue Reading

• Can I use an Outlook client in a Domino environment?

   Continue Reading

• Why am I getting schedmgr and validation errors?

   Continue Reading

• How many mail rules can I have on a Notes client?

   Continue Reading

• Why can't I extract embedded objects in the body of a message using LotusScript?

   Continue Reading

• Agent runs manually, but not when scheduled

   Continue Reading

• Getting WebQuerySave agent to run

   Continue Reading

• Accessing Excel file through LotusScript without MS Office installed

   Continue Reading

• Inbox pointers to documents have disappeared

   Continue Reading