lotusscript

In a LotusScript Agent how do you get the name of the current server?

In a LotusScript Agent that is being run via WebQueryOpen, how do you get the name of the current server? ...

Any other IDEs for Lotus Notes other than Domino Designer?

Are there any other IDEs worth my time for Lotus Notes development? We're doing mostly LotusScript development and would kill for features of Eclipse or Visual Studio, like "Show Declaration". I know there's an Eclipse plugin for Java development in Notes, but seems like it only does Java, and we have too many pieces of legacy code in Lo...

Programmatic Creation of a Notes Link Hotspot (URL)

Earlier versions of the Notes client would automatically turn a sent URL into a clickable link for the recipient (regardless of mail client) but with 6.5 (and presumably later) this no longer happens; that is, the URL is sent as plain text. The Notes UI allows it to be done via the Create->Hotspot->Link Hotspot menu but this gets tedious...

I need the sum of two columns in a view.

I found this code that goes through and prints out csv for both columns. I later parse and count the two columns. I want to count it here instead of printing and counting later. I've been mucking around but couldn't figure it out. Dim entry As NotesViewEntry Dim vc As NotesViewEntryCollection Dim rowstring As String Dim session As Ne...

How do I Use a Date in an Array in GetAllEntriesByKey?

Hi, I'm trying to use the current day in GetAllEntriesByKey by passing an array. The array so far looks like this Dim keyarray(2) As Variant keyarray(0) = "FF Thompson ADT" Set keyarray(1) = dateTime I would like to say this Set vc = view.GetAllEntriesByKey(keyarray, False) Here is a row of what it looks like when it work...

Can I return a List from a LotusScript Function?

I want to return a List from a Function in LotusScript. eg. Function myfunc() List As Variant Dim mylist List As Variant mylist("one") = 1 mylist("two") = "2" myfunc = mylist End Function Dim mylist List As Variant mylist = myfunc() Is this possible? If so, what is the correct syntax? ...

Can anyone offer feedback on my LotusScript agent?

Hi there I'm not a developer and so am unaware of best practices. I created this to bypass manual data copying of log data. This agent is for a single feed which I'll copy and adjust for each additional one. For the specified feed it reads the log for the last time processed and number of files processed so far today and for yesterday...

dynamic LotusScript multi dimensional arrays

I was just doing some yicky code and I thought, instead of using three dynamic arrays, as such: dim x() as string, y() as string, z() as string It will be nicer to have a 3 dimensional dynamic array. But; the help and my fumbling experiments has not revealed the method of defining them. This does not work: dim x()() or dim(,2) or d...

Sending formatted Lotus Notes rich text email from Excel VBA

...

MSXML2.DomDocument.3.0 invalid characters

Hello, I'm receiving the following error when parsing XML as answer from a webservice. An invalid character was found in text content. The webservice sends answers with some characters as Ψ for example or HTML structured tests malformed with " or < and > characters. The code used is: Set var_xmlPostObject = CreateObject("MSXML2.Ser...

Print NotesEmbeddedObject contents to browser

I have notes document with rich text field. In this RTF there is attachment placed. I would like to redirect (print) this attachment contents in Domino Agent accessed from web browser. I know I can save NotesEmbeddedObject on disk and then read it and post... but this does not satisfy myself. I am looking for in-memory solution. ...

How to import Microsoft Office constants (msoTrue, ppLayoutText...) into LotusScript?

I am trying to programmatically make a PowerPoint presentation from the contents of a Lotus Notes document. This is relatively straight-forward using CreateObject("Powerpoint.Application") but I fail to find a way to access the various constants that are used in VBA. One solution is of course to hard-code the (ten or so) values into my...

How to export Rich Text fields as HTML from Notes with LotusScript?

I'm working on a data migration task, where I have to export a somewhat large Lotus Notes application into a blogging platform. My first task was to export the articles from Lotus Notes into CSV files. I created a Agent in LotusScript to export the data into CSV files. I use a modified version of this IBM DeveloperWorks forum post. And...

How to add X-header to outgoing mail with LotusScript

I am looking for the Lotus Script which would add X-header to the outgoing e-mail if it has particular item in the list. The item value is set from the custom checkbox, added to one of templates. I also would like to know where to add this script in designer view (querysend event?). Thanks. ...

Upload TXT or CSV file Using WinHTTP and LotusScript

'Declare long Dim lng_resolveTimeout, lng_connectTimeout, lng_sendTimeout, lng_receiveTimeout As Long 'Declare integer Dim int_serverCredentials As Integer 'Declare variants Dim var_submitObject As Variant 'Set values int_serverCredentials = 0 lng_resolveTimeout = 120000 'miliseconds = 2 minutes lng_connectTimeout = 1200000 lng_sendT...

What is the meaning of the small "6" on some Domino agents?

Some agents in an ancient Lotus Notes application has a difference in agent-enabled behaviour that I cannot explain: This is the agent list read in R7.0.3: Here is the agents in the same database, read with R8.5: I've checked the following but haven't found any difference between the agents: Inheritance: They inherit from the sa...

How to get full name of the owner of mail file in Lotus Notes

Provided that I have the mail file name and the server, how do I retrieve the fully qualified name of the user it corresponds to in the form "CN=xxx/O=yyy" using LotusScript? To start with, I have the user's username - the part before @ in the email: i.e. [email protected] I also know server, on which this user is registered, so I use ...

How to change a field value of a document (LotusScript)?

Hello. In a new LotusNotes form I have a computed-value field ("NewOrdProdUID") which is set correctly with the unique ID of another existing document. I want to change the value of the field "NewProdAvail" in the existing document by means of LotusScript. I tried with this: Sub Querysave(Source As Notesuidocument, Continue As Variant) ...

Reading a remote URL in Domino LotusScript

I have a remote RSS feed which has to be transformed into Notes documents using LotusScript. I've looked through the documentation, but I can't find how to open a remote URL in order to retrieve its contents. In other words, some sort of wget- or curl-like functionality. Can anyone shed some light on how to do this? Using Java is not an...

Share a LotusScript library between databases

Is it possible to create a LotusScript library in one database and then access it from another database? Without simply copying the library into each database that needs to use it. What I would like to achieve is a single location where I can update the library and not have to manually copy it over to each database that is using it. I ...