Author: Ulrich Krause

Make Attractive Exports Of Categorized Views

While there are plenty of Excel export routines for Notes posted in places like the Notes.net Sandbox, OpenNTF,and several blogs, I wanted a routine that was relatively simple code-wisebut had the ability to produce clean-looking exports even or views withmultiple levels of categorization, hidden columns, and even total columns. ( Kevin Pettitt )

{ Link }


View Navigation

I was looking for a solution to replace the standard view navigation by something more “stylish”. And the solution should be easy to implement.

Domino Web Navigation - old style

I googled and came across an old article written by Bob Obringer ( The Ultimate Domino View Navigator ). His solution can be implemented with just a basic understanding of Domino Web Development.
I built it into an existing database in just a few minutes and the result is impressive.

Domino Web Navigation - new

The navigator can be customized using CSS. So jump over and download the needed files to “pimp” your web views 😉


Coding faster lookups in IBM Lotus Notes and Domino

Level: Intermediate

Raphael Savir, Principal Developer, LS Development Corporation

13 Mar 2007

Read about 11 tips for coding faster lookups in IBM Lotus Notes and Domino. The author looks at the @DbLookup @Formula in Lotus Notes and Domino and describes some new tips for developers to use when coding new applications or troubleshooting performance problems in existing applications.

Read the full article


Comments of Andre Guirard on Designer wishlist items

Hynek Kobelka posted his list of all the items which he likes or dislikes so far in Notes 8. Amongst this list are 2 features, I expected to see in the new Notes 8 client. Computed view headers and embedded views from another database.

Obviously these features will not make it into the Notes 8 codestream. Andre Guirard ( the Project Lead for the Domino Designer client ) posted his comments on this in the Notes/Domino 8 Public Beta Forum.

No computed â??View Titlesâ??. Many have asked for this for years. We really need these to create multi-language applications. Instead we get a new option â??Do not display column titleâ??. What good is this for ? (And is it different from having a blank title ?)

Agreed, this is a much-requested feature that did not make it into 8.0 (we’re not adding more features at this point). We understand the importance of this in creating multilingual apps that have reasonable performance (you don’t want a separate view for each language). This is high on my list of next things I’d like to get into the product. (note: it’s not like I get to decide, but I do get a vote, and I can also bug the decision makers. 🙂 )

If you insert an â??Embedded-Viewâ?? into a Form/Page, then you can select the view from any other database. However once you do this the replica-ID of the target database seems to be â??hardcodedâ??. There is still no option to insert an â??embedded viewâ?? where the source database would be computed. After all these years where we are only such a small step from our goal, we still donâ??t get it. Sorry but that is a REAL disappointment.

Here again, we understand why this is important and it’s high on my personal list. We had to focus on composite application features first, and this got edged out. We had hoped to have time for it.

Seems that we have to wait for another decade …


Undocumented @GetViewInfo Attribute in 7.0.2

There is a new attribute for the @GetViewInfo in the Notes and Domino 8 Public Beta 2.

[IsViewFiltered]
Returns True (1) if the @SetViewInfo command has been used to limit which documents are displayed in the view, False (0) otherwise. This is useful in hide formulas for view actions.

It is not documented in the Notes 7 Designer Help, but it is used in the mailtemplate I’ m using with my 7.0.2 client. According to the Hide-When formula of the “Unfilter” action in the ($Calendar) view, the attribute should work with Notes versions from 7.0.1 and above.

OkToShow := @If(@Version < @Text(258);  0; @GetViewInfo([IsViewFiltered]); 1; 0);

24 March 2007 – ShutDown Day !

It is obvious that people would find life extremely difficult without computers, maybe even impossible. If they disappeared for just one day, would we be able to cope? Be a part of one of the biggest global experiments ever to take place on the internet. The idea behind the experiment is to find out how many people can go without a computer for one whole day, and what will happen if we all participate! Shutdown your computer on this day and find out! Can you survive for 24 hours without your computer?

[ via Heise ]


For those who have TNEFConversion enabled on 7.0.2

As reported by IBM on Technote 1252932 under some circumstances the server can crash when you have TNEFEnableConversion=1 in the servers notes.ini file.
According to SPR# DPOS6PVLFC, this error should have been fixed in Domino 7.0.2 Fix Pack 1 (FP1).

Just want to let you know that we had some crashes on our Domino servers yesterday. We have FP1 installed since the day it was available. Looking into the generated NSD Files, we found that the server crashes with exactly the same stacktrace as mentioned in the above technote.

So, be aware when using TNEFEnableConversion=1.


Get Rules From Users Mailfile

A few days ago I was asked to create a report about all rules in all mailfiles. The easiest way to do this is to write an agent to examine the mailfiles.
The result of this scan is stored in a Notes database.
Put the following code into an agent ( start: manually from menue, target: All Selected Documents )

Sub Initialize
	On Error Resume Next
	Dim session As New NotesSession
	Dim NAB As NotesDatabase
	Dim resultDocs As NotesDocumentCollection
	Dim MailFiles As NotesDocumentCollection

	Dim doc As NotesDocument
	Dim NABDoc As NotesDocument
	Dim rtitem As Variant
	Dim MailFileItem As NotesItem
	Dim i As Integer
	Dim NabDocCounter As Integer
	Dim fNAME As String
	Dim logline As String
	Set NAB = session.CurrentDatabase
	Set MailFiles = NAB.UnprocessedDocuments

	Dim RetCode As Integer
	Dim MailServer As String
	Dim MailFile As String

	Dim db_AllDocsCol As NotesDocumentCollection
	Dim db_User As String
	Dim archiveDb As New NotesDatabase( "", "RULEZ.NSF" )
	Dim k As Integer
	For NabDocCounter = 1 To MailFiles.Count
		db_User = ""
		Set NABDoc = MailFiles.GetNthDocument ( NABDocCounter )
		Set MailFileItem = NABDoc.GetFirstItem ( "LastName" )
		db_User = MailFileItem.Text & ", "
		Set MailFileItem = NABDoc.GetFirstItem ( "FirstName" )
		db_User = db_User + MailFileItem.Text

		Set MailFileItem = NABDoc.GetFirstItem ( "MailServer" )
		MailServer = MailFileItem.Text
		Set MailFileItem = NABDoc.GetFirstItem ( "MailFile" )
		MailFile = MailFileItem.Text
		Dim db As New NotesDatabase ("", "" )
		Call db.Open ( MailServer, MailFile )

		If db.IsOpen Then
			Dim dateTime As New NotesDateTime(_
			Cstr(Datenumber(2000, 5, 1)))

			Set resultDocs = db.Search( {@UpperCase(Form)="MAILRULE"}, dateTime,0)
			Call ResultDocs.StampAll ("RuleOwner", db_user)
			For k = 1 To resultDocs.Count
				Set doc = resultDocs.GetNthDocument ( k )
				Call doc.CopyToDatabase ( archiveDB )
			Next
		End If
	Next
End Sub

When the agent finds rules in a mailfile, it copies the documents found into a Notesdatabase defined in the following line of code.

Dim archiveDb As New NotesDatabase( "", "RULEZ.NSF" )

The database itself does not have any design elements except a modified DEFAULT view. The view contains 3 columns.

Column 1: Field RuleOwner
Column 2: Field ConditionList
Column 3: Field ActionList

That’s all !

Technorati:


Create PDF documents on the fly ?? for Free!

Portable Document Format (PDF) is the de facto standard for the secure and reliable distribution and exchange of electronic documents and forms around the world. CutePDF Writer (formerly CutePDF Printer) is the free version of commercial PDF creation software. CutePDF Writer installs itself as a “printer subsystem”.
This enables virtually any Windows applications (must be able to print) to create professional quality PDF documents – with just a push of a button! CutePDF Writer is Vista-ready!


It’s Lotusphere time – and you have to stay at home …

Never mind.

On Monday, there will be information on how to view the Opening General Session online

[ via Ed Brill ]

In addition, there is a Live Blogging from Lotusphere page where you can “instantly” see what Bruce Elgort, Julian Robichaux, Ed Brill and others are writing during the show.

LS 2007 LIVE

This site has been created so that people not attending Lotusphere can still get a feel for the atmosphere and any announcements that are taking place during the General Opening Session.

The site is built by Carl Tyler from Instant Technologies and hosted by connectria

Another announcement by Ed Brill

I’ve been given the green light to announce that 40-plus Lotusphere presentations from the AD, ID, INV, and JMP tracks will be posted as podcasts to developerWorks during March 2007