Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.

Labels (1)
4 Replies
Jason_Michaelides
Partner - Master II
Partner - Master II

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

fernandotoledo
Partner - Specialist
Partner - Specialist

Have you found a solution yet?

Regards

Fernando

blednyi
Partner - Contributor II
Partner - Contributor II

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
Partner - Specialist II
Partner - 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...

beeido.com - BI | Software | Qlik Integration Services