Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Store QVD or CSV to FTP

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.

4 Replies
Highlighted
Partner
Partner

Re: Store QVD or CSV to FTP

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

Highlighted
Partner
Partner

Re: Store QVD or CSV to FTP

Have you found a solution yet?

Regards

Fernando

Highlighted
Partner
Partner

Re: Store QVD or CSV to FTP

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

close

exit

Highlighted
Specialist
Specialist

Re: Store QVD or CSV to FTP

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 Connect...