• Fields to Modify - Target Db

    By Jared Jones 2 decades ago

    Much thanks for sharing this tool.



    I have a question regarding Notes to Notes transfers. In moving (archive, add + delete) docs from source db to target db, I'd like to stamp the document with a new field value. I've tried using the settings on the Advanced–>Fields to Modify - Target Db–>"Fields to modify on CREATE" & "Fields to modify on UPDATE" tabs, but the new field never gets set.



    Is there a way to stamp a document with a new field/value as it is being archived to the target database?

    • I have been frustrated about this too

      By David Jeyachandran 2 decades ago

      Hi Mr Jones,



      I have been frustrated about this too. Sometimes when archiving I wanted to set fields on the archived document but the Data Moving Animal currently does not allow this. When looking at implementing this I was concerned about making the code more complex and performance and dismissed the idea thinking that no one else would be interested. I'm glad you mentioned this.



      It will be very useful for me because I have a large database that I archive regularly and I wanted to set some fields like the following:

      MonthText := @Select(@Month(CreatedDate); "January"; "February"; "March"; "April"; "May"; "June"; "July"; "August"; "September"; "October"; "November"; "December")

      This formula was previously in the Source database views (rather than on the form). Once I have this feature it will allow me to simplify the view formulas in the Target database (eg. MonthText instead of a formula). This will make the archive database much more efficient.



      I will implement this in the next release of the Data Moving Animal. I am currently working on the next release of Notes Reconn (Reporting tool) so it will be quite a few weeks. Hope that you can find a work-around for the moment.



      Thanks again for raising this issue.



      Kind Regards

      David