multiple .xml.gz file from FTP

BootCam — Wed, 25 Nov 2020 16:16:04 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,

Re: multiple .xml.gz file from FTP

Gysbert_Wassenaar — Fri, 02 Sep 2016 10:31:16 GMT

But its not working.

What is not working?