Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Not sure, but you could call a .bat file from the script using the Execute function.
Have you found a solution yet?
Regards
Fernando
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
For QVSource users, our File Transfer Connector supports both downloading and uploading files to/from QlikView with both FTP and Secure FTP (SFTP) Servers.