Incorporating Access Client data transfer in a CL.

[redvan]

Is there any way to include a Access Client data upload transfer into a CL?
I have a process I'm trying to automate and that would be the first step, uploading an Excel spreadsheet to a PF on the box.

Mike.

[Vectorspace]

To confirm - you want to be able to run a CL program on the IBMi that will connect to your personal computer somehow, and run the iAccess Client Solutions data upload on your computer to pull a file from your computer into the IBMi.

All triggered form the IBMi itself.

I think so. Though you still have to trigger the process yourself and in my mind it's not the ideal solution. But I'll cover that later.

A quick google shows that iACS data transfers can be run in batch form the PC command line: https://www.ibm.com/support/pages/au...-data-transfer
And on the IBMi side, a 5250 terminal session can use the STRPCCMD command to run a command on your PC.

Of course all this only works when you are logged in via 5250 and you trigger it yourself.

A more general way of doing it, would be to put the excel spreadsheet on a network drive somewhere. The IBMi can then pull the spreadsheet using SFTP, or even directly copy it into an IFS folder if you mount the network drive in the IFS (I know it can be done, but I don't know how) and then import it from there. Then there are various IBMi utilities available that can parse excel spreadsheet formats (though personally I would want the file saved as CSV format instead of excel)