I think it's responding as expected. If you change a single field value in dataset A then all the data from the CI will be merged with dataset C; the recon engine only knows that something has changed, not exactly what has changed.
It should not, however, overwrite an attribute in dataset C if that attribute was written by dataset B and this attribute has a higher weight in dataset B than in dataset A. The fact that a user changed a data value in dataset C should not affect the recon job as the attribute will still be flagged as having been updated by dataset a or b. To stop a value in dataset C being overwritten by dataset a or b you can include dataset c in the precedence set with a lower default weight than either dataset a or b but with the attribute you want to preserve at a higher weight than a or b. Then, assuming you have defer if null always on, either a user or dataset a or b will be able to set it but once it has a value then datasets a and b will not be able to modify it again. To be more in control it would be better if users updated data in a third source dataset and the recon engine merged this as well. This is the sandbox concept that works ok from the Atrium Console but is very buggy from asset management. Cheers Peter -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sergio Tomillero Sent: 09 November 2010 15:04 To: arslist@ARSLIST.ORG Subject: Re: Reconciliation Engine. Cannot merge data from two datasets to a destionation one Hi Peter, If I modify a value in Dataset C, and I launch the job, happens nothing because I have not done any modification in Dataset A or Dataset B. That is Ok, but: If I modify a value in Dataset A or Dataset B, if I have previouslly modified a value in dataset C, only Dataset A information is exported, without taking into account the weights, so Dataset A record replaces the commun data. Example: Dataset C: - Record ID001 is a merge of Dataset A & Dataset B: ID: ID001 Name: Name of ID001 in dataset A Description: Description of ID001 in dataset B - I manually modify a value of this record that has no weight, for instance the Reception Date - I save the changes and go to Dataset A. Dataset A: - I manually modify a value that has no weight, for instance Installation Date - I launch the job Result: In dataset C I only have Dataset A information: ID: ID001 Name: Name of ID001 in dataset A Description: Description of ID001 in dataset A Any idea about this behavior and how to resolve this? Thank & regards, Sergio Tomillero -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Reconciliation-Engine -Cannot-merge-data-from-two-datasets-to-a-destionation-one-tp5718360p5721231 .html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
