Uploading CSV via SSH Connection?

njaehner · December 19, 2018, 10:47pm

Hello,

I have a Knime workflow that parses an XLS to a specific CSV format, and then writes out via the CSV Writer to a local file.

The last step in this process is I take those CSVs and to manually upload to an SFTP server. I’d like to automate that last step as part of this workflow.

I’ve successfully created the SSH Connection, and added an Upload function. However, I can’t seem to quite figure out how to take the CSVs from the CSV writer and connect them to the Upload function.

Any advice would be appreciated. Thanks!

SimonS · December 19, 2018, 11:40pm

Hi @njaehner,

As far as I know, you can let the CSV Writer write directly to the sftp server, i.e., simply set the sftp path as destination.

I am not 100% sure if it works, but I think so. Let me know if it does!

Simon

oole · December 20, 2018, 10:11am

I think that won’t work, because you’ll need the connection information for SFTP.

I would write the csvs to a temp folder and then list the files in that folder and upload them from there.

You can find an example here: csv_upload.knwf (26.5 KB)