topic Sizes of all the files inside the sub folders of the directories in QlikView

Sizes of all the files inside the sub folders of the directories

qlikviewforum — Sat, 16 Nov 2013 12:29:21 GMT

Hi All,

We are making use of DIRUSE.exe in the following way to get the space details of the directories. But the problem is we are unable to file the filesize of the files in the last folder. It just gives the space details of all the subfolders. Could you please help me out to find out the space details of the files inside the subfolders.

E:\QlikView\DIRUSE /s/m E:\QlikView\Data > E:\QlikView\Data\Size.txt

Size.txt contains sizes of all the sub folders inside E:\QlikView\Data. Header of the output is something like below.

Size(mb) Files Directory

Please help me out on this...

Re: Sizes of all the files inside the sub folders of the directories

jonasheisterkam — Sat, 16 Nov 2013 12:43:11 GMT

If you need it in QV, you can combine the recursive for each example to entering folders and getting each file and then use the filesize function.

if you need it as a batch script, please give some informations like filesys, operating sys etc.

Re: Sizes of all the files inside the sub folders of the directories

swuehl — Sat, 16 Nov 2013 12:54:17 GMT

Seems to work for me, here at my place.

If you are having problems with Windows resource kit executables like diruse.exe, I suggest you post your issue to a Microsoft Windows forum. Your request seems not to be very QV specific.

Re: Sizes of all the files inside the sub folders of the directories

qlikviewforum — Sat, 16 Nov 2013 13:11:16 GMT

Hi Swuehl,

Did you tried using the same DIRUSE.exe by passing the parameters? If so please let me know what parameters you are using? In my case we are passing /s/m. Let me know if anything wrong here.

I know this is issue not specific to QV. But thought of giving it a try by posting it here so that at lease someone who has worked on similar thing can help me out.

Re: Sizes of all the files inside the sub folders of the directories

qlikviewforum — Sat, 16 Nov 2013 13:13:42 GMT

I need it as a batch script or VBScript. We are using Windows Server 2008. Let me know if you need any more details.

Re: Sizes of all the files inside the sub folders of the directories

swuehl — Sat, 16 Nov 2013 13:59:01 GMT

Yes, I used

diruse.exe /s/m "c:\intel" > c:\Temp\diruse.txt

and I got

Size (mb) Files Directory

3.03 2 C:\INTEL

0.00 0 C:\INTEL\ExtremeGraphics

0.00 0 C:\INTEL\ExtremeGraphics\CUI

0.00 1 C:\INTEL\ExtremeGraphics\CUI\Resource

2.57 8 C:\INTEL\Logs

5.60 11 SUB-TOTAL: C:\INTEL

5.60 11 TOTAL: C:\INTEL

It might be a executable / OS version issue, but again, I would suggest that you post your request to a Windows forum, just because I believe you'll find an answer there more easily.

As Jonas said, there are samples here in the forum on how to list the file sizes using the QV script, but if you want to use Windows scripting, there are better sources in the WWW to look for.

Re: Sizes of all the files inside the sub folders of the directories

qlikviewforum — Sat, 16 Nov 2013 14:26:17 GMT

I could see size of the sub folders in above output. I don't see size of the files there. Please correct me if I am wrong. That was the issue I am facing it.

Also please post me the Microsoft Windows URL so that I can post this issue there. Please let me know in case of any issues.

Re: Re: Sizes of all the files inside the sub folders of the directories

swuehl — Sat, 16 Nov 2013 14:56:50 GMT

That's probably because you are using a tool that's coping with directory usage.

You can try with the DIR command

dir /S /A:-D /O:S c:\intel

There is not a single URL for Windows related questions, there are actually myriads of URLs.

You can start with Technet forums social.technet.microsoft.com/Forums/en-US/home or stackoverflow.com

I would suggest that you google for an existing answer, since this request should already been answered.

edit: removed the external links to get this post out of moderation (after 3 days)

Re: Sizes of all the files inside the sub folders of the directories

qlikviewforum — Sun, 17 Nov 2013 09:33:23 GMT

Hi Swuehl,

Any updates on the questions which I have asked for?

Re: Sizes of all the files inside the sub folders of the directories

qlikviewforum — Mon, 18 Nov 2013 11:36:05 GMT

Any updates from anyone on this? Please help...

Re: Sizes of all the files inside the sub folders of the directories

DavidFoster1 — Mon, 18 Nov 2013 12:03:16 GMT

Why are you using DIRUSE? My first thoughts is that QlikView has its own File functions that should allow you to do exactly what you are trying to do. In particular there is an option in FOR NEXT to call a filelist which I use extensively in incremental file loading.

Re: Sizes of all the files inside the sub folders of the directories

qlikviewforum — Mon, 18 Nov 2013 12:28:50 GMT

We are already using DIRUSE which is very simple way to fetch the space details in a txt. Using QV functions it may be cumbersome. So it would be great if we can get the details using the DIRUSE.exe itself.

Re: Sizes of all the files inside the sub folders of the directories

Bill_Britt — Mon, 18 Nov 2013 16:06:13 GMT

Hi,

Take a look at this.

Bill

Re: Sizes of all the files inside the sub folders of the directories

qlikviewforum — Tue, 19 Nov 2013 05:46:36 GMT

Ok thank you, but may I know how you managed to get the output?

Re: Sizes of all the files inside the sub folders of the directories

swuehl — Tue, 19 Nov 2013 08:55:47 GMT

Have a look at the script of the QV application that Bill attached to his post.

If you can't open the application, the essential part looks like

SET FilePath='Logfiles\A2002_01*.asc';

sub DoDir (Dir)

set NoOfFiles = 0;

//Loop through all files in the directory to check if there are any files beginning with

//"A2002_01" and extension ".asc" in the sub folder "Logfiles".

//For each "A22002_01" file that is found, the variable NoOfFiles will be increased by 1.

for each File in filelist (Dir&'\'&'$(FilePath)')

let NoOfFiles = NoOfFiles + 1;

Load

'$(File)' as Name,

FileSize('$(File)') as Size,

FileTime('$(File)') as FileTime

autogenerate 1;

next File

end sub;

//Call the procedure "DoDir" to check for files in this directory.

call DoDir ('C:\proj\QlikAcademy\AdvancedGroup\ControlStructures\DoDir');

Re: Sizes of all the files inside the sub folders of the directories

qlikviewforum — Tue, 19 Nov 2013 09:55:33 GMT

Hi Swuehl,

I couldn't see the attachment before. Not sure why!

By the way is there is any easy way to get the required data using batch program. As using QV function may be time consuming thats the reason I am trying to avoid that.

Re: Sizes of all the files inside the sub folders of the directories

qlikviewforum — Tue, 19 Nov 2013 10:25:44 GMT

FYI, Using the below batch command managed to list down the list of files but only problem here is it is not showing the file size

DIR /S/B/A <<Directory Path>>

Please help!

Re: Sizes of all the files inside the sub folders of the directories

swuehl — Tue, 19 Nov 2013 10:34:57 GMT

Yes, that's because of the /b argument.

I am giving up on this thread. I've already posted above how you can use DIR to get a list of files incl. file sizes (though the format might not as you want it to be). I've also posted some links to forums where I think you should post questions related to Windows scripting.

You also got a script on how you can do this the QV way.

I can't see why using a small QV script to read in file sizes should take too much time, but anyway, it's up to you how you want to implement things.

Good luck!

Re: Sizes of all the files inside the sub folders of the directories

qlikviewforum — Tue, 19 Nov 2013 11:36:14 GMT

Thanks for all your help. Sorry if I haven't taken your instructions. I did tried using the QV Script but it is taking lots of time as it need to read almost 2TB space details. So gave up using it. Truly speaking while using the batch program it is not taking that much time.

So it would be great if you can suggest me using the batch files. If /b is the problem here I would like to know what is the command I should use. Anyway as sugested I will try to post in Microsoft forum for this.

Thanks again!