Proud Programmers Blog

Tags: : LotusScript

Thanks to Stephan Wissel who pointed me in the correct direction regarding how to open design elements directly – from the Notes client with LotusScript.

Read more...

Posted by Robert Ibsen Voith At 8:48 AM Location Nøtterøy, Norway | Permalink | Comments (1) |      

Tags: : LotusScript

Ever wanted to launch a database directly in Designer? Yes, then you probably are a developer

Read more to see a snippet of LotusScript code on how to launch the Designer with a specified database.

BTW – wish I could specify a specific designer element, so if you know, please chime in.

Read more...

Posted by Robert Ibsen Voith At 3:58 PM Location Nøtterøy, Norway | Permalink | Comments (7) |      

Tags: : LotusScript

Have you ever wanted to access the Search Bar from LotusScript?

Being able to do so would perhaps remove the need for various homecooked solutions on how to do full text searches and display the results to the user. Even though we do have programmatic access to full text, I have allways felt that something is missing. Why not just use the standard search bar in the Notes client? This post describes how to do exactly that with a couple LotusScript classes, using Windows API functions. You can set and get the text of the Search Bar, and even click the "Search" button programmatically.

Read more...

Posted by Robert Ibsen Voith At 3:18 PM Location Nøtterøy, Norway | Permalink | Comments (3) |      

Tags: : Lotusphere

Last year the official session schedule contained several presentations for download even before Lotusphere. This year I haven’t seen them yet.

Posted by Robert Ibsen Voith At 9:59 AM Location Nøtterøy, Norway | Permalink | Comments (0) |      

Tags: : Microsoft Office Thoughts Windows 7
Have you ever seen the funny "Error "1310: Error writing to file: C:\Config.Msi..." -message when trying to install an application?



..."Verify that you have access to that directory." ...

Read more...

Posted by Robert Ibsen Voith At 10:13 AM Location Nøtterøy, Norway | Permalink | Comments (1) |      

Tags: : Question Lotus Notes

Update 24.JAN.2012: See comment from Brian below on how to fix this issue

The server has been upgraded to Domino 8.5.3 and now my iPhone nor iPad can’t open the mails without getting an error. I can can log in, and see the Inbox fine. All new mails are present, but as soon as I click on a message to open it, I get an error message (“Cannot open page, the URL cannot be shown”. The exact Norwegian error message is “Kan ikke åpne side, Safari kan ikke åpne siden, Feilen var: “URL-en kan ikke vises”). Has anybody seen this?

Posted by Robert Ibsen Voith At 12:18 PM Location Nøtterøy, Norway | Permalink | Comments (8) |      

Tags: : DXL Lotus Notes LotusScript
From time to time I like to completely reinstall Notes, because Notes, like Windows, accumulate issues  (oh, "features" we call them, he he ...) over time. So just like reinstalling Windows once a year, I try to reinstall Notes too. One of the drawbacks with complete reinstallation, is that you loose settings, amongst them  Workplace and Bookmarks. This means that I have to manually recreate my bookmark folder structure, opening up a bunch of databases and remember to add them to bookmarks. Boring, tedious and error-prone.

I have therefore created the Bookmark Export and Import database, which let you export your bookmarks to a backup document, and then later import it again. Below you see a screenshot of my latest backup document;



Yup, nothing fancy in regard of design here The backup document contains two DXL files (which the Export agents creates for you) along with a bunch of other fields to keep track of all relations in the original bookmark.nsf file. Below you see the content of the About-document
Read more...

Posted by Robert Ibsen Voith At 6:24 PM Location Nøtterøy, Norway | Permalink | Comments (14) |      

Tags: : Lotus Notes
Update 24.JAN.2012: Impressed by IBM! IBM contacted me to receive the log files.

Yesterday I wanted to upgrade my Notes installation. Being a developer, I started the notes_designer_admin853_w32en.exe on my Windows 7 x64 Enterprise, and clicked away. At some point in the installation, I got this;



Read more...

Posted by Robert Ibsen Voith At 2:35 PM Location Nøtterøy, Norway | Permalink | Comments (14) |      

Tags: : Import Export Library IEL Excel
One of the features that have been missing in standard Notes, is the ability to import- and export directly to Excel. Yes, you can  write some code achieve this, typically via OLE Automation (CreateObject ...), but that needs a programmer every time. With older versions of Excel, you could also go the long way via conversion to the 1-2-3 Workbook format, but again, pretty cumbersome.

The upcoming Notes Import Export Library (IEL)  can import- and export the newest Excel 2007/2010 files with the xlsx file extension, as well as the older "97-2003 compability mode" files with the xls file extension. This can even be done without having Excel installed at all!


Seeing the highly visible field mapping above, you know exactly what gets imported- or exported.

Read more...

Posted by Robert Ibsen Voith At 6:23 AM Location Nøtterøy, Norway | Permalink | Comments (3) |      

Tags: : Notes Fields Extractor

Starting from release 1.0.0.342 Notes Fields Extractor has two new options; ImageFileNameFormula and AttachmentFileNameFormula. With these options you can specify full Notes @-formulas, and use any field or other content in your documents in the formulas! For example, with the new release you can easily extract all employees images into a single directory, and each image has the EmployeeNumber-field content as the filename. Of course you have some extra run-time variables you can also use in your formulas, such as $(BASEPATH) which is replaced with the current base directory.

Take a look at the updated User’s Guide to get an idea of how this works.

Posted by Robert Ibsen Voith At 12:03 PM Location Nøtterøy, Norway | Permalink | Comments (0) |