Saturday, May 27, 2006

Microsoft.XMLHTTP and cached data

Once I had a problem with Microsoft.XMLHTTP object. It used cached results from previous fetch.
I solved the problem by appending a unique parameter to the URL, which caused the object to fetch the new result each time.
Something like this:


Sub Initialize
Dim oHTTP As Variant
Dim strUrl As String
Dim strReturn As String

strUrl = ""+cstr(timer())

Set oHTTP = CreateObject("Microsoft.XMLHTTP") "GET", strUrl, False, "", ""
strReturn = oHTTP.responseText
Set oHTTP = Nothing
msgbox strReturn
End Sub

NotesDXLExporter export fails on document with attachment

This is from an my answer to a post on
The problem was that NotesDXLExporter failed to export document in UI to XML if there was an attachment in the document, even if the document was manually saved in UI.

I could reproduce this error.
It happens under following conditions:
a)create a new mail document, add attachment to it, save the document but do not close it. Run the code (agent action or form button).
b)open an existing mail document, add attachment to it, save the document without closing it. Run the code.

It happens only with attachments, adding an inline picture does not generate the error. Triggering a LS agent to perform export results in same error.

Once you closed and re-opened the document, everything works fine until you add a new attachment.

Maybe some antivirus attachment control operations can make Notes think that attachment is new even on "old" documents, but I could not test this.

I could however make the DXLExporter work by programmatically re-opening the document, I guess it's the only solution:

Sub Click(Source As Button)
Dim session As New notessession
Dim doc As notesdocument
Set ws=New NotesUIWorkspace
Set uidoc = ws.CurrentDocument
Set doc = uidoc.Document
Call uidoc.close

Set ws=New NotesUIWorkspace
Set uidoc=ws.editdocument(False, doc)
Set doc = uidoc.Document
Set dxle = session.CreateDXLExporter
Msgbox dxle.Export(doc)
Msgbox dxle.Log
End Sub

Thursday, May 18, 2006

Skype pricing for calls in USA

Skype announced that until December 31, all calls from SkypeOut users living in USA and Canada users to landline AND mobile phones in the USA/Canada are totally free. Unfortunately calls from other countries are priced according to standard rates.
I wonder how soon US Skype accounts will be available for sale on the Ebay. I would guess that many European and Asian companies and private persons would be happy to get those free unlimited calls. As Skype uses IP-number verification for location of the caller, this can be difficult.

Netgear has created a special Skype Wi-Fi phone. It looks like a regular cell phone, but only can make calls using Skype protocoll from Wi-Fi places which does not require logging in. As I understood "looging in" in this case means providing username and password to Wi-Fi net provider using web browser interface. As phone supports WEP, it should be possible to use at home and at most other places. Looks like the price is about 60 USD.

Wednesday, May 17, 2006

Using Media Player object in Lotus Notes mail documents

Watch Flash movie describing how to
use Media Player object in Lotus Notes documents

Lotus Domino and PHP

Read my latest article on IBM DeveloperWorks about PHP interface to data stored in Domino.
There is also a live demo of reading Domino email from PHP. Same demo is available as download.
I also compiled php_notes.dll file which is needed for native API calls from PHP to Notes. For some reason I could not find the compiled version anbywhere on the Internet.


Live demo:

Stylesheets for web tables

Just today found a web site with a lot of tabel stylesheets.
Looks interesting, will try later to apply them to Domino tables.