Lotus Notes Database Sync

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.

## Deliverables

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.

## Platform

Lotus Notes (Windows) Release 5.

Taidot: Tietokannan hallinto, tekniikka, MySQL, PHP, tietojärjestelmäarkkitehtuuri, Ohjelmistojen testaus, SQL, Web hosting, Verkkosivun hallinta, Verkkosivujen testaus

Näytä lisää: lotus database, script writing program, repository.db, lotus, lotus notes, document database, database record keeping, database program java, can save code database, sql database sync, port source java, php sync, sync code, repository database, php repository, sync sql server, intranet document, intranet php system, php sync database, port java program

Tietoa työnantajasta:
( 165 arvostelua ) Tampa, United States

Projektin tunnus: #2855797

2 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


See private message.

$85 USD 14 päivässä
(10 arvostelua)

See private message.

$85 USD 14 päivässä
(0 arvostelua)