lotus-notes

Lotus Notes Xpage, how to get event handle (onKeyPress) in SSJS ?

I am new to xpages in Lotus Notes and need to work with the "onKeyPress" Event. With the following CodeSnippet Client Side Javascript works fine. if (thisEvent.keyCode!=13) { doNothing(); } How can I do the same for Server Sided Javascript (SSJS) ? I need to get a handle on the Event. ...

Problem in connecting Oracle 11g through JDBC thin driver ( Domino Java )

Hi, I'm unable to connect Oracle 11 database remotely using following piece of code. However, same code works fine if I try to connect Oracle 9 database which is installed on my machine. What is missing ? ( I'm not getting any error, Lotus Notes hangs ) import lotus.domino.*; import java.sql.*; import oracle.jdbc.*; public class Jav...

Nhibernate and Lotus Notes via ODBC

I have to import data from a Lotus Notes database via ODBC. The source data are all varchar fields while some columns actually contain dates and numbers. I mapped those colums with NHibernate to the appropriate types which works for loading but not for comparing (using criteria, e.g. Restrictions.Eq("StoreId", 123)). Whenever I execute ...

Working with categorized Views with totals in Lotus Notes Designer

Hi, I have two forms with two views. That needs to access data from one another. I have a view that has been categorized and computes the total value per data. My problem now is, on a separate view, I need to extract the subtotals from view #1. For Example; On View #1, I have columns named Country (C1), State/City (SC) and Populati...

Stored Procedure via Notes Java Agent

Hello, I am trying to get a stored procedure to be able to be called from a java agent in Lotus Notes. I have been able to get these type(s) of agents to work fine as far as moving data to and from db2 tables, and I have also been able to run the stored procedure from Iseries Navigator using the same username/password that I am using fo...

ColdFusion & Lotus Notes Calendar integration

In an enterprise scenario where a ColdFusion application is used to register for a event, would it be possible to programmatically add an entry into the calendar of a person? Google has given me some partial idea's like connecting via JDBC/ iCalendar, etc... Any ideas & experiences are appreciated Thanks! ...

How to copy file to remote server in Lotusscript

Hi, I want to create a Lotus Notes agent that will run on the server to generate a text file. Once the file is created, I need to send it to a remote server. What is the best/easiest way to send the file to a remote server? Thanks ...

Notes 7.0.3 Client throws Error in compile JavaScript on a form with not much JavaScript. Any ideas as to a potential cause?

Straight to the question and then the background. What would cause a Notes 7.0.3 client to throw a JavaScript error "Error in compile JavaScript"? Followup Question: what's a good tool for tracking JS errors in the Notes Client? My suspcions: - flaky JS written by developer(s) - unusual input by user - memory management issues (Win...

A little buggy: Code to create, save,& open a Lotus Draft Email thru VBA

This function was written to create a Lotus email, populate it, save it to the Drafts section, and then open it for the user to edit. However, it has 2 problems: It doesn't always open the right draft email for editing. It sometimes produces a "Notes Error - Specified command is not available from the workspace." error message. (The e...

Implementing a moderated internal mailing list with Lotus Domino

Hi In Lotus Notes, I use Groups to implement "internal" mailing lists ("internal" because only users with Lotus Notes accounts can be member of the groups). Is there an easy way to moderate emails sent to this group? Let's say I have a group (everyone-in-the-office) and Alice sends an email to everyone-in-the-office. I would like mode...

How can I use Perl to open the Inbox through the Lotus Notes API?

I am able to open Lotus notes api using Perl, without errors, also I can get list of views that includes Inbox, but when I try to read messages from that view it appears empty? What might I be doing wrong? (in fact it seems like something might of changed on notes side as this code used to work before) Result of code below: NAME of View...

Truncated Mails in Lotus notes

Hi: I am reading mails using Interop.Domino dll but in few cases my program hangs for a particular mail, after going through the document properties i found that the mail is truncated as a blue torn page symbol appear on it and the size property is (40K +truncated) , so is there any other property through which i can programmatically id...

Import Lotus Notes Database into Access/SQL - What about Documents?

I have a few Lotus Notes 'databases' that i'd like to import into Access or SQL. I think I have most of the steps down (install NotesSQL ODBC driver, setup ODBC connection to Lotus DB, import data into Access), but I can't figure out what to do with all the documents, eg: Word Files, PDF Docs, Excel Workbooks that were in the Lotus DB. ...

Lotus Notes: RichText Item

Okay, here's the deal. I am using C# with the Domino API. I have some rich text data that I want to insert into a lotus notes rich text field. NotesDocument.ReplaceItemValue just inserts the text as is with no formatting. NotesDocument.CreateRichTextItem gives me a NotesRichTextItem object that I can use for manually creating RichText ...

Problem using sendmail activity in workflow sharepoint

Hi, I have a breakline problem using sendmail activity in a Sharepoint VS workflow. I use < br/ > for the breakline, everything is ok in live mail&outlook but when i try it in lotus note all my text is inline. How can i fix this problem ? ...

How can I test if the user is logged into Lotus Notes using VBA?

My Excel application sends email updates using Lotus Notes and I am having trouble finding a quick and reliable way of ensuring that that the user is logged in to Notes. If the user is not logged into Notes before they perform an operation that calls Notes then the code stalls on Set NotesDocument = NotesMailFile.CreateDocument as Excel...

Lotus Notes API Error in loading DLL

My client is using Lotus Notes 8.0.2. I am trying to use the following VBScript to call the Notes API to send an email: dim objNotesSession, objNotesDatabase, objNotesItem, objNotesRichTextItem set objNotesSession = CreateObject("Lotus.NotesSession") Call objNotesSession.Initialize("[password here]") set objNotesDatabase = objNotesSess...

Redirect from Web query open agent on Lotus Domino?

Doe anyone know a way of redirecting to another webpage from lotus domino web query open agent? The print statement does not seem to work. A possible workaround would be very appreciated! Something on that subject can be found here but it seem kind of flaky. http://www-10.lotus.com/ldd/46dom.nsf/55c38d716d632d9b8525689b005ba1c0/552ac51d...

JCR (JSR-170) connector for Lotus Notes

I'm looking for JCR (JSR-170) connector for Lotus Notes Domino Server 7 for integration between our customer Domino server and our software. Does anybody has an experience in dealing with such JCR connector? I found only day.com connector but not sure it if fits me. ...

Retrieving data from lotus NotesDatabase using lotusScript

Hi, I am new in lotusScript and lotus notes. I can retrieve data from database using notesView. Here is path of my lotusScript code for that: Sub getViewData Dim session As New NotesSession Dim db As NotesDatabase Dim mainDoc As NotesDocument Set db = session.CurrentDatabase Dim collection As NotesDocumentCol...