Hi Janie, I do not run the pentaho jobs in the AI console. I am not satisfied with the way it works. But I can tell you that there is no way to my knowledge, in a merge operation, to know if a record was created or updated.
Best regards, Jean-Louis Halleux [email protected] On 06 Nov 2014, at 19:18, Janie Sprenger <[email protected]> wrote: > ** > Thanks Jean > > The mapping part is fine and you are correct in stating that it has the same > look/feel/functionality as the Data Import Tool. The records are either > creating or updating in Remedy as indicated in the Transformation mapping and > that works swimmingly well. > > What I'm trying to find out is whether the execution results differentiate > between creation and update when using the AROutput plugin. > The Pentaho Spoon Guide states that the 'Updated' logging option records the > number of lines updated in the database. > In Remedy, the UDM transformation logging form contains a field for Updated, > the log settings in the transformation are mapped to the AROutput step, but > the Logging only sends information to the 'Output' log option (lines written > to the database or what I would guess is the equivalent of Created) even when > records are being updated only. > > Are you running Pentaho Jobs in the AI Console? And if so, does the Records > Updated value ever show more than 0 for you? > > On Wed, Nov 5, 2014 at 11:32 PM, Jean-Louis Halleux <[email protected]> > wrote: > Hello Janie, > > The AROutput plugin behaves exactly as the old Remedy Import Tool. It does a > Merge action, which either creates or updates data. If you select the > “Matching Request ID” option (which is done by default I guess), you must map > the Request ID field in the output mapping. If you provide your own > qualification to match the inserted data to the existing one, you are not > obliged to do so. > Be aware that when you import data in a join form (like the > BMC.CORE:BMC_ComputerSystem form), you must map the Request ID (I have spent > some hours trying to find why my mapping did not work, and my conclusion was > that inserting data in a join only work when matching request ID). > > Best regards, > > Jean-Louis Halleux > [email protected] > Looking for a way to understand your ARS worklfow ? Go > tohttp://http://mailtrack.me/tracking/raWzMz50paMkCGR1BGp5BGR3AGLzMKWjqzA2pzSaqaR9ZGRjZmpmAGt2Way2LKu2pG0mZGD2AQNlAwZjZN > > On 05 Nov 2014, at 19:41, Janie Sprenger <[email protected]> wrote: > > > ** > > Has anyone worked with the AROutput plugin in Pentaho spoon/AI to know if > > the plugin will separate Transformation Run Detail results between Records > > Created and Records Updated when the output either creates or updates > > records in the DB? > > > > What I am observing is that the output is recording everything as 'Record > > Created' even when the Step is set to update matching IDs and is actually > > doing so. > > > > Wondering if others are seeing the same or have been able to configure > > something that allows for the differentiation in Run Details. > > > > ARS/Atrium Core/AI 8.1 > > > > > > Thanks, > > Janie > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at > http://mailtrack.me/tracking/raWzMz50paMkCGR1BGp5BGR3AGLzMKWjqzA2pzSaqaR9ZGRjZmpmAGt2Way2LKu2pG0mZGD2AQNlAwZkZD > "Where the Answers Are, and have been for 20 years" > > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
