FAO ACtheTROLL � Help with batch files

[Bushwhacker]

ACtheTROLL - further to my previous post on exporting Windows Explorer detail. The directory that I am running Print Files on is HUGE and the software keeps hanging !!

You suggested that batch files may be the way forward to get the info I need.

Could you please spell it out (step by step and really slowly!!) as to how I could run batch files to get the detail of a folder called Information on a networked drive ?? The folder location is G:\Information

Many Thanks In Advance

BW

[ACtheTROLL]

hi

just tried it on system32 folder ... took less than a second to create the txt file

the command is
dir /n /o:gn >root.txt

dir = directory listing
/n = long list (full file names)
/o:og = arrange output by putting directories first and sort on name.
>root.txt = sends output to a text file called (in this case) root.txt.

you don't need to use a .bat file to run it ... just open a command window in the folder you're interested in

the easiest way is
in XP right click the folder | use command prompt here
(you'll need to download and install Open Command Window Here
http://www.microsoft.com/windowsxp/downloads/p owertoys/xppowertoys.mspx)

in vista - hold down shift and right click the folder | open command window here


open a command window type dir /? to see all options

once you have the file ... open it ... delete any stuff you don't need

then select all | copy
switch to the spreadsheet and paste
then use data | text to columns (fixed width - if you use space delimited it will split filenames)

however ... if you have files lager than 9,999,999 bits the first digit will spill into the previous column
you'll need to scroll down yo see if everything is clean

alternatively add the /-c switch to remove commas
dir /-c /n /o:gn >root.txt

to import directly to word
as above then just paste the text into word (change the font to a fixed pitch - courrier new is as good as any
and it will look exactly the same as the screen

you could actually copy the text directly from the command screen using copy / paste
(top left click the C:\> icon for the edit op

[ACtheTROLL]

lol ...
continued ....


(top left click the C:\> icon for the edit options)
and loose the >root.txt

phew - slow enough?

[Bushwhacker]

Cheers for that ACtheTROLL - you must be totally out of breath !! Yip that was totally slow enough and I really appreciate your help

Just tried it - but I cannot install the Open Command Window (I am on works PC with a protected C drive).

So I went back to your original method and used the .bat way. Only problem is that by using batch files I only get the contents of the folder BUT I want the contents of the folder, and the contents of all the sub-folders, and the contents of all the sub, sub folders and so on.

The folder I am looking to extract the contents of has 10, 000 sub folders & 68,000 files !!

That is the beauty of the PrintFiles software - it does that, but as I said before - it just keeps hanging. I think it is the size of the folder that is causing the problem.

Any other input is most welcome

Thanks again.

BW

[ChuckFickens]

change AC's command from dir /n /o:gn >root.txt to

dir /s /n /o:gn >root.txt

The addition of the /s will list sub folders

[Bushwhacker]

Thanks ChuckFickens,

Problem solved.

Thanks again

BW