We have a database that talks to another database (not one of ours) using a Notrix document. Each time the notrix document runs it says that it has updated all of the documents - even though there are no apparent changes.
Is there a way to write some code that could compare the documents before and after and tell me what field has changed ?
Thanks
Paul
Subject: how can i find out which field has been changed ?
Hi Paul,
there is no way to easily tell which fields have changed. I am not very familiar with Notrix (that is to say, I haven’t used it for about 6 years) but this happens in LEI the same way when doing replication type activities. Is your other database a Notes db? If it isn’t then you may need to check into how the records are being sorted. Basically, to different db’s on different systems tend to sort the data in the opposite order so when doing a replication type activity each record is updated top down causing each record in the transfer to require an update (or more likely, a delete and create)… Anyway, I am not sure I am really helping you… but check to see if you can order your data and see if that helps. If this happens each time the activity runs then you may want to simply print out a report of the data on both sides prior to the activity running and just do a visual comparison.
PS. In Notrix there may be a higher level of logging you can turn on to log the actual field updates… not sure about this though. Good Luck!
Cheers,
Mark
Subject: Oh Yeah!
and btw…
are there any agents updating records on either side? It very well could simply be the modified date being updated.