Hello Dave,

I think that the Data Management module of ARSmarts could answer to your requirements.

Indeed, the reason why the approvals matching the Changes are not modified is probably because the workflow doing that job is not firing on Merge, and so is not triggered by your import.

The solution would be to trigger the workflow firing on Modify, through a Modify All operation.  Unfortunately, this does not seem possible through the standard Remedy interface.

What I would try is to use the ARSmarts Data Management module. Using ARSmarts Data Management, you can query your Change form to find the relevant Changes, and then perform a Modify All operation, putting the Changes in the desired Status, and the required values in the desired fields.

There is also a possibility that Active Links fire to enter some values in hidden fields.  Using ARSmarts Browser, you can find out what these AL are, and what they do, and then during the Modify All operation described above, insert the desired values in the these hidden fields so as to trigger the workflow.

I realize that my explanation might be a little cryptic, but if you want to bring it a step further, I'd be happy to send you a few screenshots to illustrate what I have in mind.  (I don't think that I can send screenshots on the ARSlist, so this would have to be via your own email).

Looking forward to hear from you,
Kaïs.
[email protected]

On 09/04/2019 12:28, Dave Barber wrote:
All,

We have a large number of open changes, at various stages from draft through to scheduled for approval from years gone by.  I'm hoping to cancel them via a "simple" AR Import.  CSV file with the change ID, and then map the various fields.

For the change request itself, this seems to work fine. But open approvals against them - they don't get touched.

But I am getting nowhere with doing a similar import against either CHG:ChangeAPDetailSignature (which seems to do nothing) or against AP:Signature (where you have to use zTmpAppRequest to match the CRQ reference - but the import fails).

Has anyone done such an "automation" before?  Any suggestions/pointers?

Regards

Dave Barber


-- 
ARSList mailing list
[email protected]
https://mailman.rrr.se/cgi/listinfo/arslist

Reply via email to