Downloading multiple .xml.gz file from FTP

BootCam — Fri, 20 Sep 2019 09:56:33 GMT

Hi I am trying to get bunch of .xml.gz file from ftp and copying them to my local folder with the below script in qlikview. But its not working.

If i want to copy files from one local folder to another local folder it works. But for ftp it doesnt work.

BatFile:

Load

'This is a batch file test' As [@echo off]

AutoGenerate(1);

Let vDate = Date(Today(),'YYYY-MM-DD');

Let vExt = '*.xml.gz';

BatFile:

FIRST 1 Load

'COPY $(vFile) C:\Users\Documents\TestFolder1\$(vDate)'&'_' & SubField('$(vFile)', '\', -1) As [@echo off]

FROM $(vFile) (txt);

Store BatFile into 'C:\Users\Documents\ABC'.bat (txt);

Drop Table BatFile;

EXECUTE C:\Users\Documents\ABC.bat;

Let me know if you have any questions.

Thnaks,

topic Downloading multiple .xml.gz file from FTP in QlikView