topic Re: Issue with FileSize() function? in QlikView

Issue with FileSize() function?

chiru_thota — Wed, 05 Mar 2014 22:13:44 GMT

Hi All,

I am using FileSize() function to get the size of our QVW's and it is working fine.

I have 10 QVW's.Some how for 3 QVW's I am not getting any size when I use

load FileSize() as FS from QVWNAME.QVW. I am not getting any error also.

It is weird.Any QVW internal setting causing this issue ?

Thanks,

Chiru.

Re: Issue with FileSize() function?

Wed, 05 Mar 2014 22:34:14 GMT

Try to load with NoConcatenate statement.

ex. in the load script:

NoConcatenate Load FileSize() as...

Hope this helps.

Re: Issue with FileSize() function?

stevedark — Wed, 05 Mar 2014 22:45:25 GMT

Hi there,

I am surprised it is working at all with a load from a QVW. Is it that you are loading from some QVD's and these are working but the QVW's are not?

If you want to get the size of a number of files I would go for something like this:

for each vFile in FileList('.\*.qv*')

let vFileSize = Alt(FileSize('$(vFile)'), 0);

FileSize:

LOAD

'$(vFile)' as FileName,

$(vFileSize) as FileSize

AUTOGENERATE(1)

;

next

There are a whole bunch of functions that you can run over QVD files that will give you more information about them.

You will find that code will give you the full path to the file in the FileName field. You can either do a Replace function to remove the path, or a mid function based on an index on the last backslash.

Hope that helps,

Steve

Re: Issue with FileSize() function?

chiru_thota — Wed, 05 Mar 2014 22:53:16 GMT

Hi Steve,

No I am not loading from QVD...I want the size of ABC.QVW.

I am writing statement for all my QVW's as there in different folders.One load for each.

Load FileSize() as Size_QVW

FROM ..\..\..\..\..\ABC.qvw

Those statement working fine and fecthing me size except 3 QVW's.

Thanks,

Chiru

Re: Issue with FileSize() function?

rwunderlich — Wed, 05 Mar 2014 23:55:00 GMT

This is not really a good way to use filesize(). You are actually LOADing a QVW, which will have mixed results depending on what filespec parameters you use and what the file actually contains. Steve's recommendation to use the filesize(path) function would be reliable.

-Rob

Re: Issue with FileSize() function?

stevedark — Thu, 06 Mar 2014 00:31:11 GMT

Hi Chiranjeevi,

If the files really are all over the place then you could use an inline load to list the files, and then loop around to get the sizes. The code would be:

Temp_Files:

LOAD

FileName

INLINE [

FileName

..\..\..\File1.qvw

..\..\File2.qvw

];

for i = 0 to NoOfRows('Temp_Files') -1

let vFile = Peek('FileName', i, 'Temp_Files');

let vFileSize = Alt(FileSize('$(vFile)'), 0);

FileSize:

LOAD

'$(vFile)' as FileName,

$(vFileSize) as FileSize

AUTOGENERATE(1)

;

next

DROP TABLE Temp_Files;

I was surprised when you said the technique of loading it in the way you described worked for all but three QVW files. I tried it on a couple and it didn't work on any of them. As Rob says this approach will give you no problems.

Steve

Re: Re: Issue with FileSize() function?

rwunderlich — Thu, 06 Mar 2014 00:47:43 GMT

Or you can simplify your life by using Qlikview Components:

SUB MyFileSub (filepath)

MyFiles:

LOAD

'$(filepath)' as [FilePath],

FileTime('$(filepath)') as [FileTime],

FileSize('$(filepath)') as [FileSize]

AutoGenerate 1

;

END SUB

CALL Qvc.ListFiles('C:\dir1', '*.qvw', -1, 'MyFileSub');

CALL Qvc.ListFiles('C:\dir2', '*.qvw', -1, 'MyFileSub');

CALL Qvc.ListFiles('C:\dir3', '*.qvw', -1, 'MyFileSub');

-Rob

Re: Issue with FileSize() function?

chiru_thota — Thu, 06 Mar 2014 01:38:28 GMT

Thanks a lot Steve&Rob.

New code is easy and working perfect.