Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 - 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
GitFirst - A CI/CD solution for Qlik Sense