How to connect to FTP Server and load all the files from the particular folder

Wed, 05 Nov 2014 15:46:48 GMT

Hi,

Please let me know how to automatically connect to ftp server and load all the files from that particular location.

I have a sample script but it is not working or connecting

let vDataFolder ='ftp://';

for each vFile in filelist('$(vDataFolder)*.xls*')

let vFileName = mid(vFile, index(vFile, '\', -1) + 1);

//define ODBC connection for Data Source by mentiong Variable

//ODBC CONNECT32 TO [Excel Files;DBQ=$(vFile)];

OLEDB CONNECT32 TO [Provider=MSDASQL.1;Persist Security Info=True;Extended Properties="DSN=Excel Files;DBQ=$(vFile);DriverId=790;MaxBufferSize=2048;PageTimeout=5;"];

tables:

SQLtables;

DISCONNECT;

FOR i = 0 to NoOfRows('tables')-1

LET sheetName = purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39));

//IF wildmatch('$(sheetName)', 'Sales*') THEN

Sales:

LOAD * , '$(vFileName)' as FileName

FROM $(vFileName) (biff, embedded labels, table is [$(sheetName)]);

//END IF

DROP TABLE tables;

EXIT Script;

Please help me to solve this issue.

Re: How to connect to FTP Server and load all the files from the particular folder

marcus_sommer — Wed, 05 Nov 2014 17:05:05 GMT

It's not possible in this way - have some explanations and alternatively here:

Re: For Each File in Filelist - FTP load is not working?

Re: FTP data import into script

- Marcus

topic How to connect to FTP Server and load all the files from the particular folder in QlikView

How to connect to FTP Server and load all the files from the particular folder

Re: How to connect to FTP Server and load all the files from the particular folder