I have developed an Intranet using Lotus Notes as the main document repository. Some of the things we wanted to do were too slow in Notes, so we built a SQL Server database that maintains copys of certain fields from the notes database. It works well apart from one problem - keeping the Notes DB and the SQL Server DB in sync. At the moment, when you save a document, it does: Command([FileSave]); URLOpen(... and we pass the values from the relevant fields to an ASP script that Inserts/updates the SQL Server DB. If we are creating a new record then we pass a flag on the URL to identify this. The 2 problems we are seeking a solution to are as follows: 1. If 2 documents have the same title, or the user changes the title, then we don't know which to update in SQL Server. We can pass fields that are visible on the form, but cannot seem to pass NoteID or NoteUNID. 2. We use the Java views (client request), using Move to Trash and Empty Trash to delete documents. We need a way of passing the NoteIDs of the records that are deleted back to the ASP script. We tried writing a script that compares documents in both DBs and deletes it if it no longer exists, but it is very slow. Maybe there is an easier way to keep the 2 dbs in sync? Due to client confidentiality we cannot let anyone into the live system, so we would require an example script in a demo nsf that we could port over.
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
Lotus Notes (Windows) Release 5.