EXPERT RESPONSE
Using multi-value data in DECS is fairly easy and straightforward, once it is explained to you by someone who has had it properly explained to them. In other words, you're not the first person to ask me these questions. I will provide the best answers possible in the same order you asked them. However, most of your questions are addressed in the DECS documentation supplied with the Domino R5 server.
For starters, I suggest you turn off the Activity wizard. Next, choose the events you wish to monitor and then check the "Multi-value data" option. Now do your field mapping, but think of it backwards from how the DECS Activity UI displays it -- from the external system to Notes, which is the way it really works.
- Sorry, but you cannot move attachments using DECS. This is addressed in LEI 6.0. The only choice you have with R5/DECS is to deal with the attachments programmatically.
- The "Key(s)" fields located within the mapping section are where you identify the field(s) and column(s) that uniquely identify each item. By item, I mean either a single row in the external system or a set of multi-value field(s) on a Notes document. DECS assumes that all the fields you list in the "Field(s)" list are multi-value on the Notes side.
- The Filter Formula is used to further define upon which documents a specific DECS activity should act. If the data document that you are opening meets the Filter Formula, then the associated DECS Activity will act upon the document. Think of and treat the Filter the same as you would a View Selection Formula, except leave off the keyword "SELECT." A simple example is "Status = '1,'" which means that for all the documents (based on their Form) being monitored by the activity, only those that have a Status field with a text value of 1 will be acted upon.
|
