lotusscript

Why does this LotusScript halt during a loop?

Hello, I am trying to write a LotusScript to control a motor. The script I have for reading the bits seem to work fine, but I wish to add a stop button. I have all the commands for making the device stop, but the trouble I'm having is that whenever LotusScript is running through a loop, I cannot click on any of the other buttons. Does ...

Lotus Notes - Export emails to plain text file

I am setting up a Lotus Notes account to accept emails from a client, and automatically save each email as a plain text file to be processed by another application. So, I'm trying to create my very first Agent in Lotus to automatically export the emails to text. Is there a standard, best practices way to do this? I've created a LotusS...

Search for a date between given ranges - Lotus

I have been trying to work out what is the best way to search for gather all of the documents in a database that have a certain date. Originally I was trying to use FTsearch or search to move through a document collection, but I changed over to processing a view and associated documents. My first question is what is the easiest way to ...

Lotus view column compare to string/integer

I have a lotus view that stores a number. I need to perform some math against the value, but I am having a lot of problems getting the types to match up. doc.numOfGold = numGold and CInt(doc.numOfGold) = numGold and CInt(doc.numOfGold) = CInt(numGold) and doc.numOfGold = CInt(numGold) all return type mismatch. I've tried changin...

How to Get Current User Name ?

Hi i have a problem like this i have two text boxes(A,B) which i have selected as " Computed when Composed " when 'A' Login then in Text A Current User Login Name Should come automatically, if 'B' Login then 'B' user name should come automatically in 'B' Text and it should be saved when i submit the form to the next level how to do this...

How to get Current Owner name ?

Hi My question is i have 4 Text Box 1) Prepared By 2) Checked By 3) Approved BY 4) Created BY First i will login as Smitha then in " Preapred by " - Smitha name should come automatically n all other text box should be blank, then i will submit the form it goes to our respective HOD now , Nagaraj sir will login as Nagaraj.S then i...

Using a lotus script to change data in a field.Want the data to be multi lined.

Good day, I'll start by saying I work for a small company and have no official training in Notes everything I know I've learned buy trial and error & using other peoples codes. Application: We have a purchase order database that has been running for a very long time and threw the ages people put in supplier names diffirently. Now I fou...

Lotus Script to make text Blink

Hi How to make text Blink using Lotus Script ? ...

LotusScript - Setting element in for loop

I have an array set up Dim managerList(1 To 50, 1 To 100) As String what I am trying to do, is set the first, second, and third elements in the row managerList(index,1) = tempManagerName managerList(index,2) = tempIdeaNumber managerList(index,3) = 1 But get an error when I try to do that saying that the object variable is not ...

Developing a lotus notes database to read info of another database

Hi, I am trying to develop a lotus notes database which can connect to another notes database and extract all the information like forms count, views etc. Any suggestions on how to proceed? Thanks ...

Check if a user can read a file on a UNC-Share

A User on our Windows Client has a function to send Links to Files on our Network-Shares (UNC-Paths) to other Users in our Company. Often these Users does not know if the receipients have access to this Share. A trial and error strategy is not possible because the users that is sending the link is already connected to this share with h...

Replacement for CAPICOM

Hi, all! Now CAPICOM is deprecated, and MSDN recommends to use .net classes from System.Security.Cryptography. But I have one Lotus Notes application, which using CAPICOM from LotusScript code (very similar to VisualBasic) for displaying certificates to users, and get some cert info (Subject and ValidToDate fields). How can I replace ...

How to use a LotusScript function as a document selection routine

Can we use a lotusscript function as a document selection routine inside view selection formula ? Here is my lotus function which determines the selection criteria Function MyFilter(doc As NotesDocument) as boolean 'very complex filtering function '........ End Function and here is the view selection formula that i want to incorpo...

Lotus Notes/Domino Designer 8 - Get User Name from E-mail

I have a bunch of users I am adding to conference. They are contained both in a user's address book and on the Notes server/main company address book. Once I have the e-mail address of a user, is there a way to look up their user name? ...

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 ...

Lotusscript date time issues

I have a couple of dates stored in a view. And I am using getItemValue to retrieve them. Dim repsondedDate As NotesDateTime Set repsondedDate = timePart1doc.GetItemValue("dateResponded") When I try to do the following, I get a type missmatch at run time. Dim dateDifference As double Set dtLocal = New NotesDateTime( Now ) dateDifferenc...

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...

Managing an unstable SQL connection on a Lotus Notes Agent

Hi, I have a working Lotus Notes agent. Running on LN 7. My agent runs every 5 minutes, and it sends some mails whenever it finds some specific records on an Microsoft SQL (2005) table. It usually works ok, but recently it stopped working -more than once now- and won't restart again until the Notes Server is restarted or the Notes admi...

How to get the underlying view of a form using lotusscript

Hi, I am a newbie in lotusscript. We have a legacy lotus notes/domino system. We need to migrate the data from lotus notes to oracle. Lotus domino's data model is entirely different than that of oracle's data model. So, we are creating a relational table per Lotus notes form. I can access the views programmaticaly using lotusscript....

How to get form data using lostusscript

Possible Duplicate: How to get the underlying view of a form using lotusscript Hi, Can anyone give me a code snippet of lotusscript which can export form data with attachment? I failed to export the data to excel using ODBC connection. Thanks in advance. ...