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 <supp...@arsmarts.com> 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 > supp...@arsmarts.com > Looking for a way to understand your ARS worklfow ? Go to > http://mailtrack.me/tracking/raWzMz50paMkCGR1BGZjAGZ4ZmVzMKWjqzA2pzSaqaR9ZGRjZmpmAGt2Way2LKu2pG0mZGVkZmx4AGRjBt > > On 05 Nov 2014, at 19:41, Janie Sprenger <jrsrem...@gmail.com> 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 www.arslist.org > "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"
