Lotus Notes via Automation controller

tbrendel

I have a database in lotus notes and i would control the entries in this database via automation controller.

in the automation controller from lotus notes 6.0
there are many subfields to use, but i have no idea, how to
set it up to make a dokument in lotus notes database.

i have read the manual and some visual basic examples from lotus notes.

all i have is:

---

my global variables are Automation controller
notessession "Lotus Notes Automation Classes".NOTESSESSION
notesdatabase "Lotus Notes Automation Classes".NOTESDATABASE
notesdokument "Lotus Notes Automation Classes".NOTESDOCUMENT

---

CREATE(notessession);
notessession.GETDATABASE('SERVER01','EDV\navision.nsf');



i have no clue to program any further. PLEASE HELP

Christian_Buehl

We are looking for this solution for now about 2 Years but we did not find any help. It seems that nobody is using this interface (Neither IBM/Notes nor Navision is telling here anything of help)
The only thing we found out is:
- we can use the MAPI interface for sending mails from Navision through Notes (But just need to set Notes as mail client in the internet settings, and for 2.01 you need to do a small modification in the CodeUnit mail )

- we just started trying Notes-SQL (ODBC Driver) for the issues we have. We try to access via ADO. Unfortunately first test showed that this interface is not very reliable (may be our configuration is not really good)

- last step is that we wait until Notes is ported to a DB2-Database (which will start with Notes 7.0). This Database can be easily accessed with ADO (we hope)

tbrendel

Hello, thanks for your answer.

I have found the solution for myself.
In MBS - Usergroup and a little probing for myself.

It works with Lotus Notes 6.5 and navision 3.7
At the beginning i have tested it with a local teamroomdatabase
GETDATABASE('','Navkopie.nsf')
because i have problems with the syntax of our lotus server
but i will replicate this database, so that is a good workaround.

Here are the results

---

code

---

CLEAR(NotesSession);
CLEAR(NotesDatabase);

IF NOT CREATE(NotesSession) THEN EXIT;

NotesDatabase := NotesSession.GETDATABASE('','Navkopie.nsf');

IF ISCLEAR(NotesDatabase) THEN MESSAGE('Datenbank nicht gefunden');

NotesDocument := NotesDatabase.CREATEDOCUMENT();
NotesDocument.APPENDITEMVALUE('Form','Hauptdokument');
NotesDocument.APPENDITEMVALUE('Subject','Test Navision Lotus notes');
NotesDocument.APPENDITEMVALUE('tmpFrom','ADMIN');
NotesDocument.APPENDITEMVALUE('Auftragsnr','000001');

NotesDocument.SAVE(1,1);

MESSAGE('Dokument gespeichert');



It works
:P