Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Jason_Michaelides
Luminary Alumni
Luminary Alumni

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

fernandotoledo
Partner
Partner

Have you found a solution yet?

Regards

Fernando

blednyi
Partner
Partner

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

chrisbrain
Specialist II
Specialist II

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