topic Store QVD or CSV to FTP in QlikView

Store QVD or CSV to FTP

Mon, 16 Jul 2012 15:24:05 GMT

Hi There,

Is it possible to store a QVD or CSV file to an FTP location from the Script?

For example: Store Table1 into $(FTPLOCATION) Table1.qvd;

Thank you,

GJ.

Re: Store QVD or CSV to FTP

Jason_Michaelides — Mon, 16 Jul 2012 17:45:56 GMT

Not sure, but you could call a .bat file from the script using the Execute function.

Re: Store QVD or CSV to FTP

fernandotoledo — Thu, 02 May 2013 12:49:19 GMT

Have you found a solution yet?

Regards

Fernando

Re: Store QVD or CSV to FTP

blednyi — Tue, 21 May 2013 06:06:52 GMT

You can make patch file (.bat) that you call in script. In that patch file use basic ftp commands, if you need sftp-connection you can use WinScp.exe or WinScp.com software. Below example that uses winscp script properties directly:

In script=

EXECUTE winscp.exe /console /script=filename.txt;

In scriptfile "filename":

Open ftp://username:password@ftpserver

# Change remote directory

cd Testpath

option transfer binary

# transfer file to ftp server

put D:\Users\??\Documents\file.csv

exit

Re: Store QVD or CSV to FTP

chrisbrain — Thu, 05 Dec 2013 13:32:08 GMT

For QVSource users, our File Transfer Connector supports both downloading and uploading files to/from QlikView with both FTP and Secure FTP (SFTP) Servers.

File Transfer Connector For QlikView (SFTP (Secure FTP) & FTP) - QVSource - The QlikView API Connector (Docs)