topic Filesize() not working for URL Path in QlikView

Filesize() not working for URL Path

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to find out the size of a file that is present in a web shared location.

I have used function as below. it is not fetching anything. it is returning null.

Let vSize= FileSize('http://rss.nytimes.com/services/xml/rss/nyt/Science.xml');

but if i use a local drive path of any file instead of URL path, it is working fine.

Any suggestions and references to understand and debug the issue will be very helpful.

Thanks in Advance.

Sunil.

Re: Filesize() not working for URL Path

Anil_Babu_Samineni — Fri, 04 Nov 2016 06:04:30 GMT

Sunil,

For me this is working. Would you check the Host file is working or not

SET vFilePath = 'C:\Users\xxx\Downloads\DDQ.qvw';

Let vSize= Alt(FileSize('$(vFilePath)'),0);

Then, I've created Text object with the Value of =$(vSize)

Re: Filesize() not working for URL Path

jonathandienst — Fri, 04 Nov 2016 06:38:23 GMT

The FileSize function expects a Windows file path - it does not work on a URL.

Re: Filesize() not working for URL Path

Mon, 07 Nov 2016 07:19:56 GMT

Anil,

Thanks for your response.

In my example above, if you click on the link it not working. but copy the URL paste it in URL bar. it opens the XML file.

I have tried with a local drive path.

Let vSize= FileSize('D:\S h.Sunilkumar\Work Area\Temp.xlsx'); It is working fine.

but I need to find the size of a file present in a web shared location, for which I need to specify an URL of the file like the example mentioned above. This seems to be not working.

Re: Filesize() not working for URL Path

Mon, 07 Nov 2016 07:28:25 GMT

Hi Jonathan,

Thanks for your Response.

In the Qlikview help site, it is mentioned that both Windows path and URL address are valid to use in filesize().

PFB the link.

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/FileFunctions/FileSize.htm

Is this an issue with the function itself that Filesize() is not accepting any URL paths?

Sunil.