I am creating an Excel Migration job that will set hundreds of Requisition Authorisation Rules to ‘Planned’.
This is very much like the topic I raised and got a very good answer that worked well: Excel Migration - Delete User Sites | IFS Community. On this occasion the same principles are not working for me.
Here is the job...
For the Action on Seq 10 I have toggled InLoop and NoExecution.
For Seq 20, I set these attributes…
My source mapping looks like this - I allowed the default Source Columns and assume I don’t need to do anything with the first 4 Method columns…
Having tried many variations, the latest result is set to null upon execution…
In the debug Trace, I see this error…
It looks like it is trying to grab every column and insert the values into the Attr_ variable.
I’m out of ideas now