Re: Atrium Integrator and AROutput plugin

2014-11-07 Thread Jean-Louis Halleux
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 supp...@arsmarts.com On 06 Nov

Re: Atrium Integrator and AROutput plugin

2014-11-06 Thread Janie Sprenger
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

Atrium Integrator and AROutput plugin

2014-11-05 Thread Janie Sprenger
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

Re: Atrium Integrator and AROutput plugin

2014-11-05 Thread Jean-Louis Halleux
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