topic Filelist with URL path in QlikView

Filelist with URL path

Mon, 23 Jul 2012 17:51:07 GMT

Hello,

Is it possible to browse files using Filelist and an http path?

Something like:

for each File in filelist ('http://myserver/directory/*.xls')

Load *

FROM $(File)

(biff, embedded labels, table is Sheet1$);

next File

I tried and I do not get an error but no data either althought it works fine with a local path:

for each File in filelist ('D:\directory\*.xls')

Load *

FROM $(File)

(biff, embedded labels, table is Sheet1$);

next File

Thanks,

Re: Filelist with URL path

Tue, 24 Jul 2012 11:11:14 GMT

is that what you want...?

for each vExt in 'xls'

for each vFoundFile in filelist( '\\myserver\directory'& '\*.'& vExt)

Tab1:

Load

from $(vFoundFile) (biff, embedded labels, table is data$);;

Next vFoundFile;

Next vExt;

//all the files should have "data" sheet

i've just checked and it works for me:)

Re: Filelist with URL path

nstefaniuk — Tue, 24 Jul 2012 12:33:37 GMT

Hi.

In my opinion you can't because the HTTP protocol doesn't support it.

If you request this URL http://files.ubuntu-gr.org/ubuntistas/pdfs/ you will get a HTML page, not a collection of files. Then you can read this HTML page and detect tag <tr><td><a> ...</a></td></tr> but it's not easy.

And the most important: you need to have no index.html in your directory, else you can't get the file listing. In fact it's a 0 level of security for web : if you don't have the exact URL you can't find a file.