Fast view column reader
The code is part of a class. It reads view data into a cache. That cache can of course be used multiple times. Using a NotesViewEntryCollection proved to be a lot slower.
fillCacheR recursively fills the cache with column data. If the data fetched is over 32K, Evaluate won't return an Array, so the request is split in smaller requests, and so on.
setSearch is used to supply the key field or column and values for a series of @DbLookup calls.
LotusScript
Sjef Bosman
You have to login first to use 'My Favorites' feature
So far, no one has added to favorites
Added 2022-Oct-27
Create a Connection Document in the user's NAB
This is the code of the agent used in the Collabsphere Session INF107 - Useful Hacks for Domino Administrators.
Replace Domino Server Name from CN=SERVERDOMINO/O=TEST to your Domino Server Name
LotusScript
Marianna Tomasatti
Overall rating is 5.00 by 1 person(s)
You have to login first to use 'My Favorites' feature
1 user(s) has marked as favorite:
Roberto Boccadoro
Create a Group based on a field (Company Name) in a Person Document
This script was started by me, messed up by me, and fixed by the great Bruce Lill.
My customer has internet registration and we wanted to automate much of the process.
Once someone is registered, then they need some groups created based on their Company name (Field name is CompanyName).
In the code substitute the Domino Server name where you see SERVER/ORG and the adminp will create the group within a minute or so once the user name is selected.
Instructions:
NOTE: Presumes you already have your Directory/NAB (Names.nsf) open
1) From the Notes top menu, click on Create, then click on Agent. In the window that opens, give the agent a name and description
2) Type is Lotusscript and click ok
3) Copy then paste in the code
4) Edit the SERVER/ORG to your server name that this will run on
5) This customer wanted an X in front of the company name but you could remove it or change it as you need for your purpose
6) Save your agent
7) Test the agent by going back to your Directory and going to a test person in the list of users
8) Click on Action from the Notes menu and find your new Agent and click on it to run it
9) Open the Groups list and see if it is there, after a minute or 2
LotusScript
Keith Brooks
You have to login first to use 'My Favorites' feature
So far, no one has added to favorites
Added 2022-Apr-07
Magic Button by Tim Tripcony
Source: Tim Tripcony, 2008 - https://web.archive.org/web/20160121234622/http://avatar.red-pill.mobi/tim/blog.nsf/d6plinks/TTRY-7DZ4GX
Magic button is a formula to be added as a toolbar button in Notes which provides ability to change field value for any field on selected document.
"For as long as I can remember (possibly 2001) I've always maintained some variation on a SmartIcon toolbar button that a former coworker called the "magic button": it allows new fields to be added to a document and existing fields to be overridden or deleted from the document, either while editing the document or while it's selected in a view. I've seen various approaches to this basic concept over the years, and each time I install Notes on another computer, I either consult the Google to find one I've used before or just reconstruct it from memory. It finally occurred to me that if I just posted the one I'm currently using here, not only would it be easier for me to find later, but some of you might find it useful as well. So here's the current incarnation of said magic button..."
#CodeForTim
Formula
Serdar Basegmez
Overall rating is 5.00 by 1 person(s)
You have to login first to use 'My Favorites' feature
So far, no one has added to favorites
Simple (and limited) Xpages export to Excel with no external dependencies
This snippet is useful when your excel export is as simple as just 1 sheet with data tha can be handle in an HTML table.
The idea is to get an XAgent "connected" to a session-scoped managed bean. There is no need to use external libraries.
Feel free to contact me if you have any question or improvement.
@javdev84 - javiersanchezoliva.com
Java
Javier Sanchez
Overall rating is 4.50 by 2 person(s)
You have to login first to use 'My Favorites' feature
So far, no one has added to favorites
Log to Domino using JSON
This XPAGE read json from a POST request and create a log entry in the database. This is useful if you have code in other environments like a c# console application and want to use a Domino database as log storage.
Paste this code into a new xpage and send the json using POST to /db.nsf/xpagename.xsp/logger
You need to create a form named "Log" in the database with the fields specified in the code.
If you try this using Postman you should get "Domino LogEvent registered" as result
XPages
Thomas Adrian
You have to login first to use 'My Favorites' feature
So far, no one has added to favorites
Added 2021-Dec-13
Script to fix a Mail File Location in a Person Document
This is a simple thing, but one that is very valuable, especially when doing server folder or drive changes, email migrations or corporate mergers.
The important piece which people forget is what to do when the syntax is caps or lower case.
This script sets the syntax to lowercase.
Instructions:
NOTE: Presumes you already have your Directory/NAB (Names.nsf) open
1) From the Notes top menu, click on Create, then click on Agent. In the window that opens, give the agent a name and description
2) Select FORMULA
3) Copy then paste in the code
4) Edit the directory name (mail2 in this example) to whatever one you are trying to change that is in the person document.
5) Edit the directory name it should be changed (mail in this example)
6) Save your agent
7) Test the agent by going back to your Directory and go to a test person in the list of users
8) Click on Action from the Notes Menu and find your new Agent and click on it to run it
9) Open the person doc and see if all looks good, if not, check your syntax
Admin Scripts
Keith Brooks
You have to login first to use 'My Favorites' feature
So far, no one has added to favorites
Added 2021-Oct-09
An alternative way to include the newest version of CKEditor 4
CKeditor is developing rapidly, however the implementation in XPages is staying behind.
Pasting content from MS Word for example isn't working anymore like it supposed to do and loading large chunks of content from a Java bean into an inputRichText field is taking like forever.
I created an alternative way of implementing a new CKeditor.
Use the following steps:
0. Your application contains a Javabean "Name" which contains a field "field" and a getter en setter. However any name will do, just change the properties.
1. First download the latest version of CKeditor 4 from the site https://ckeditor.com/ckeditor-4/
2. Open the Navigator view in Domino Designer
3. Paste the CKEditor into: /WebContent/ckeditor4
4. Create a Custom Control with the following name: ckEditor4RichText
5. Paste the code and save the control
6. Add property defenitions to the CC:
fieldName with type: String
toolbar with type String
beanvalue with type: object AND editor: Method Binding Editor
7. Create a XPage and insert the Custom Control:
The toolbar can implement any CKEditor toolbar. this example contains just a basic toolbar.
8. Now compile and watch the magic :)
Note:
You can add any kind of plugin to the CKEditor.
Some advanced knowledge of Domino Designer and Javascript could be handy.
XPages
René vd Weide
You have to login first to use 'My Favorites' feature
So far, no one has added to favorites
Added 2021-Apr-12
Converting Regular Common Name Lists into Notes Hierarchical Names
I prefer to have people in Notes format in groups because no one knows the future, although the names will work in a simple one domain network, there is always something new down the road and the names should be in a proper format.
When given a new application to push out and an ACL with long lists of people, this will do the lookups for you in a few seconds, once you set this up for yourself.
This script works with your PNAB (Personal Name and Address Book) also called contacts list and is the local Notes client names.nsf file.
HOW TO USE THIS CODE:
This will create a button in your Toolbar.
1. Go to File->Preferences->Toolbar->Customize from your Notes client.
2. From the top box, I customize the Universal toolbar so select it from the dropdown.
3. Below the window box of icons, Click on New->Button.
4. Give it a Caption text, I used: Get Notes Names.
5. Popup Help text really is the name that shows when you hover over the icon, I would just repeat the name used in Step 4.
6. Change the icon to something either meaningful to you or whatever will be unique for you to notice it, I use a yellow ball.
7. Paste the code from the code box on this page into the Formula box of your Toolbar Icon window.
8. Click Ok.
9. Click Save Toolbar.
10. Click Ok.
That concludes the code part of this snippet.
HOW TO USE THE CODE:
1. If you don't have the Universal Toolbar showing by default, turn it on by going to View->Toolbar and clicking on Universal.
2. Open your PNAB (Personal Address Book), also called Contacts of your Notes client, it is usually the names.nsf file.
3. Click on Groups from the list of options in your Contacts.
4. Click on New to create a new Group.
5. You can name it anything, I keep a generic empty group for this purpose and call it Converts.
6. In the main field, copy and paste the list of names to get Notes Names from your company NAB/Directory.
7. Click Save and Close.
8. Now with the group you created highlighted/selected, click on the Icon created in the toolbar we created earlier.
9. You will receive a pop-up window one completed stating Found XX emails for XX Notes Names. This is important so you know if you got everyone or if you had any typing mistakes or people who may have left the company.
10. Now if you open the group you will see the Notes Names for everyone in the Comments & Attachments section and can copy and paste those into the new ACL groups or whatever your need.
If you used this and it helped you great! Please rate it and let me know you used the code. I am @Lotusevangelist on Twitter
This was put together with the help of fellow IBM Champions and HCL Ambassadors a long time ago and Jesse Gallagher when I edited this for verification about some questions I had at the time.
Admin Scripts
Keith Brooks
You have to login first to use 'My Favorites' feature
1 user(s) has marked as favorite:
Keith Brooks
Added 2021-Jan-18
Looking up and Converting a List of Notes Names into their Email Address
When asked to pull the email names for a list of Notes names so marketing could export them to an outside mailing list, I figured there had to be a better way than looking them up individually. Luckily, there is.
This version owes a hat tip and thanks to the inspiration code from the amazing Stephan Wissel and this post of his: https://www.wissel.net/blog/2011/10/converting-notes-names-into-internet-addresses.html
I had to adjust the code over time a little bit but I also want to give credit where it is deserved.
HOW TO USE THIS CODE:
This will create a button in your Toolbar.
1. Go to File->Preferences->Toolbar->Customize from your Notes client.
2. From the top box, I Customize the Universal toolbar so select it from the dropdown.
3. Below the window box of icons, Click on New->Button.
4. Give it a Caption text, I used: Get Email Addresses.
5. Popup Help text really is the name that shows when you hover over the icon, I would just repeat the name used in Step 4.
6. Change the icon to something either meaningful (toolbar_ccmail.gif icon perhaps?) or whatever will be unique for you to notice it.
7. Paste the code from the code box on this page into the Formula box of your Toolbar Icon window.
8. Click Ok.
9. Click Save Toolbar.
10. Click Ok.
That concludes the code part of this snippet.
HOW TO USE THE CODE:
1. If you don't have the Universal Toolbar showing by default, turn it on by going to View->Toolbar and clicking on Universal
2. Open your PNAB (Personal Address Book), also called Contacts of your Notes client, it is usually the names.nsf file.
3. Click on Groups from the list of options in your Contacts.
4. Click on New to create a new Group.
5. You can name it anything, I keep a generic empty group for this purpose and call it Converts.
6. In the main field, copy and paste the names to get emails from your company NAB/Directory.
7. Click Save and Close.
8. Now with the group you created highlighted/selected, click on the Icon created in the toolbar we created earlier.
9. You will receive a pop-up window one completed stating Found XX emails for XX Notes Names. This is important so you know if you got everyone or if you had any typing mistakes or people who may have left the company.
10. Now if you open the group you will see the emails for everyone in the Comments & Attachments section.
Cool, right? I taught AA's how to use this and they love it and never bother me anymore.
If you used this and it helped you great! Please rate it and let me and Stephen know you used the code.
I am @Lotusevangelist and Stephan is @notessensei on Twitter
Admin Scripts
Keith Brooks
Overall rating is 5.00 by 1 person(s)
You have to login first to use 'My Favorites' feature
1 user(s) has marked as favorite:
Keith Brooks
Create a Forwarding Address in a Person Doc based on Email Address
This is a simple thing, but one that is very valuable, especially when doing domain changes, email migrations or corporate mergers.
The important piece which people forget is what to do when the syntax is caps or lower case.
This script solves that problem by setting the existing email to lowercase.
Instructions:
NOTE: Presumes you already have your Directory/NAB (Names.nsf) open
1) From the Notes top menu, click on Create, then click on Agent. In the window that opens, give the agent a name and description
2) Select FORMULA
3) Copy then paste in the code
4) Edit the existigname.com to your domain (ex: lotusrocks.com)
5) Edit the newname.com to the new domain (ex: hclrocks.com)
6) Save your agent
7) Test the agent by going back to your Directory and go to a test person in the list of users
8) Click on Action from the Notes Menu and find your new Agent and click on it to run it
9) Open the person doc and see if all looks good, if not, check your syntax
Admin Scripts
Keith Brooks
You have to login first to use 'My Favorites' feature
1 user(s) has marked as favorite:
Keith Brooks
Added 2020-Dec-15
Volt Audit Trail
This can be used to add an audit to a Multi-line entry field, as HTML. To do so:
1. Add a Multi-Line Entry field, and hide on all occasions (e.g. add a rule to "Show" if "Window height in pixels" "Has no value"). Call it "F_AuditText".
2. Add an HTML field below, calling it "F_HTMLAudit".
3. In the page's onShow event, use: page.F_HTMLAudit.setContent(BO.F_AuditText.getValue(). This takes the HTML values stored in "F_AuditText" and renders the HTML on the page, obviously read-only.
4. In your submit buttons or wherever else you want to add to the audit, call:
BO.F_AuditText.setValue(app.getSharedData().addAudit('Submitted') + BO.F_AuditText.getValue()
This gets an audit message "Submitted" and prepends it to the existing audit messages. The audit messages appear most recent first.
JavaScript (Volt)
Paul S Withers
Overall rating is 5.00 by 2 person(s)
You have to login first to use 'My Favorites' feature
So far, no one has added to favorites
Get list of groups user belongs to
Utils.getSession().getUserGroupNameList() will return the groups the user in context belongs to. I use the code above to get a list of groups for a user who is not in the context.
Java
Patrick Kwintensson
You have to login first to use 'My Favorites' feature
So far, no one has added to favorites
Added 2020-May-13
Change OSGI_HTTP_DYNAMIC_BUNDLES in Notes.ini from LotusScript
Call this agent with Agent.RunOnServer to change the value of OSGI_HTTP_DYNAMIC_BUNDLES on a Domino server without using a server configuration document and a server reboot.
OSSetEnvironmentVariableExt with isSoft=true lets the method only a check an internal hard list for forbidden variables, allowing OSGI_HTTP_DYNAMIC_BUNDLES to be changed.
LotusScript
Karsten Lehmann
Overall rating is 5.00 by 1 person(s)
You have to login first to use 'My Favorites' feature
So far, no one has added to favorites
Set/reset LogStatusBar environment variable when needed
When you want to start logging to log.nsf, just put
Dim h As New LogHelper
and delete the object when you want to stop logging.
LotusScript
Sjef Bosman
Overall rating is 5.00 by 1 person(s)
You have to login first to use 'My Favorites' feature
So far, no one has added to favorites