Usha A Dewasthali 7.Jul.15 02:24 PM a Web browser Connector for Notes All Releases Windows
I have a production database that I want to replicate daily to a test database. The designs are identical. I am having issues replicating one field named Install_Date. It is a notes/date time field in both notes databases, but in the prod notes database, it used to be a text field. So there are many old, legacy documents that have it has a text field. Due to some data contraints, we don't want to update the production docs to recompute the value as a notes date/time field. I was hoping it would replicate over as is (text value) to my test environment. The only thing is that in my test db, any document that had the install_date as a text field is blank on my test documents. All fields except for install_date comes over. I have tried replication with Reduced-Precision comparson turned on and off. I have also tried it with a direct transfer and the install_date is blank in my test database if the install_date is a text value in the prod database. I have also tried to use data translation formulas similar to this one:
FIELD Install_Date := @TextToTime(Install_Date)
Any help is appreciated if anyone has ideas on how to take care of this within LEI rather than run an agent to update the source documents to force them to be notes date/time. Thanks!