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