Posted on 2006-07-06
I have a lotusscript agent imports almost 20000 records from an external data source into a lotus notes database and that's working very well.
However, the data in any of those imported records changes frequently in the external database, so I am having to delete all those records from my lotus database and import them again every night which is cumbersome and I am sure inefficient for the database.
Now I have gone through similar path with Marylin to whom I am very greatful because she has tried to help with one of those tough agents at one stage, but that agent we worked on had static old records, nothing changed expect the daily data which was imported.
In this agent most fields in the records may need to change, product id, supplier, etc, and the change may need to happen on old and new records so doing a checking while import on every field on 20,000 record I believe maybe another nightmare.
It would really appreciate some ideas/ direction on the best way to change this agent so that I don't have to delete and reimport ever record into the database every night.
Thank you all in advance.