connecting python and lotus notes: not opened

threaderslash · 10-21-2009, 01:50 AM

Hi Everybody,

Hope someone can point me some direction...

I got python linking to lotus notes, under Eclipse IDE. The code is:

Code:

import pythoncom
import pywintypes
from win32com.client import Dispatch
session=Dispatch("Lotus.NotesSession")
session

print pythoncom.CreateGuid()

try:
session.Initialize("password")
db = session.getDatabase("local", "C:\Program Files\lotus\notes\data\mydata.nsf")

agent=db.getAgent("($All)")
doc = db.CreateDocument()
view = db.GetView("($All)")
doc = view.getFirstDocument()

testvar = doc.getItemValue("($All)")

except pywintypes.com_error: raise

but the compiler gives me the error:

Code:

".nsf has not been opened yet"

Any suggestion? Thanks.

ordinary · 10-22-2009, 11:56 AM

The first thing I notice is that you are using a Windows path in the "db = ..." line. Is this program supposed to run on a Windows box or a Linux box?

Oh, yeah, on slightly closer examination, there are other Windows dependencies. Does Eclipse run on Windows? I don't even know.

All I know is that if this is a Linux program, the Windows dependencies need to go, and if it's a Windows program you'd get better advice on a Windows forum.

Good luck.

threaderslash · 11-04-2009, 04:42 PM

At the end of the day we discovered that you can get access to Lotus Notes using ODBC - NotesSQL. It work fine and for what we need much better than win32com.