Moving Excel File from SharePoint to SFTP

skustes — Fri, 19 Jan 2024 23:28:26 GMT

I've created an automation to dump a straight table into an Excel file on SharePoint. Sometimes we will also need to deliver this file to an SFTP destination.

The way I'm doing this is:

Use the "Open File on Microsoft SharePoint" block to open the file that was just created
Then "Read Data from File on Microsoft SharePoint" to extract its contents
- Within the loop, append each item to a variable vFileContents
Then "Write Line to File on SFTP" to write vFileContents into the file
Save and close the file on SFTP

This method does create the file in the correct destination within our SFTP site, however, the resulting file is corrupted. Excel can repair the file and the data is correct, however, it would be nice if I could accomplish this without the final output being corrupted.

Is there a better method to accomplish such a file move from SharePoint to SFTP?

Re: Moving Excel File from SharePoint to SFTP

salmankojar — Fri, 15 Mar 2024 09:41:20 GMT

Hi @skustes

Instead of Reading data from the SharePoint file and writing it in SFTP File, you can directly Copy/Move the file from SharePoint to SFTP using Copy/Move block of SFTP.

Re: Moving Excel File from SharePoint to SFTP

skustes — Fri, 15 Mar 2024 14:01:16 GMT

Thanks @salmankojar, that's the solution I ended up arriving at, as well.

topic Re: Moving Excel File from SharePoint to SFTP in Qlik Automate

Moving Excel File from SharePoint to SFTP

Re: Moving Excel File from SharePoint to SFTP

Re: Moving Excel File from SharePoint to SFTP