Is it possible to run a report and uplaod the CSV file to an FTP site/folder?
It should be pretty straight forward if the FTP site uses basic username/password credentials. I have the one-step that runs the report save it to a file, then pass the filename and path to a PowerShell script that handles connecting to the FTP server and uploading the file. It is a pretty common request that a file get pushed up to an ftp server for follow-on automation in another system.
ScottExcalibur Data Systems
I have a few questions:- Is your environment hosted?- Could you send me a screen shot of your One-Step and your powershell script?
I don't have an example I can show you at the moment. We have done this with hosted clients and on-premise. The biggest piece is to do this all in a one-step. I generally store the script in the one-step so that I can use a variable to embed the report filename. That makes it cleaner and easier to write. There are tons of PowerShell script examples of how to perform an FTP transfer on-line.