Main Area and Open Discussion > General Software Discussion

List all subfolders on multiple drives to text of csv

<< < (3/6) > >>

dcwul62:
Was hoping for a very simple solution.-dcwul62 (August 27, 2013, 09:49 AM)
--- End quote ---

How deep are you going into those root folders you mention?  One level?  Two?  All?
-skwire (August 27, 2013, 10:09 AM)
--- End quote ---
@skwire: only 1 level, so:
x:\basefolder\subfolder1
x:\basefolder\subfolder2
x:\basefolder\subfolder3
etc.

like this:

=

=

dcwul62:
@4wd - yes, thanks.
Indeed, one can adjust the cell-format/properties.
from default into ####-##=## ##-##-## (for the date)
and for the size in some other format.

I tried it again.

However, frankly speaking, bottom line Opus is much easier, quicker.
SMF launch takes much longer, it requires (a lot of) more clicks for this simple task.
Yes, SMF has much more features, etc.
However, in my case I won't be needing those.
In Excel it requires time for adjustments, bla bla.

So, bottomline, I think, in this case Opus, though not entirely meeting 'my demand' (multi folder print), is still the best solution.

=

=

dcwul62:
You might get some mileage from the Unix "LS" command.  A port of the brute command line version is included GNU utilities for Win32 (UnxUtils.zip), but I don't think it does CSV natively.  However, there's a WinGUI version of LS that does.  It's been mentioned on DC numerous times, including:

* Re: Karen's Directory Printer - copy content of a directory to txt file or print it
(this earlier post of mine includes a copy of LS)
* LS - File List Generator (for Windows)
* Re: External Drive Content Lister?
(includes portablefreeware link to LS) A minor problem is that this LS doesn't exit cleanly, it appears to crash on exit!  But it still works well.
-rjbull (August 27, 2013, 03:00 PM)
--- End quote ---

Thanks fo the tips. I have looked at these and some other tools.

Actually I think they are designed to list/print the contents, however, not just the folderpaths/foldernames/size/date-time

Sofar I have not found a tool that can do this job - I mean, in an easy/simple few clicks way.

=

rjbull:
Actually I think they are designed to list/print the contents, however, not just the folderpaths/foldernames/size/date-time-dcwul62 (August 28, 2013, 01:21 AM)
--- End quote ---

Branch of my directory tree:  WinGUI LS settings:
                   
LS output:
"[Path]","[Folder name]","[Save date]","[Size]"
"C:\Users\R.J. Bull\Junk\","CIS_Work","2009-09-15 21:22:26","0 Byte"
"C:\Users\R.J. Bull\Junk\","LPTDOS","2009-09-15 21:22:26","0 Byte"
"C:\Users\R.J. Bull\Junk\","Old_Junk","2009-09-15 21:22:56","0 Byte"
"C:\Users\R.J. Bull\Junk\","T2100-JUNK","2009-09-15 21:23:05","0 Byte"
"C:\Users\R.J. Bull\Junk\","Temp_images","2013-04-17 21:35:44","0 Byte"
"C:\Users\R.J. Bull\Junk\","Temp_screenshots","2013-04-17 21:35:06","0 Byte"
"C:\Users\R.J. Bull\Junk\","zip221","2009-09-15 21:23:05","0 Byte"
"C:\Users\R.J. Bull\Junk\","ZZ_T2100","2009-09-15 21:37:25","0 Byte"

Total number of folders = 8
Sum of file sizes = 0 Byte

IainB:
Using xplorer², I just tried this now:

* 1. Open xplorer².
* 2. Select desired Root Directory in a Pane.
* 3. Press: Ctrl+F (for FIND).
* 4. Ensure "Named" = *.* (it usually is by default).
* 5. Untick "files" (so it's folders only, otherwise files and folders are selected by default).
* 6. Untick "search subfolders" (we're only going 1 level deep).
* 7. Click OK and wait for search to complete.
* 8. When the search results come up, select/deselect those columns for display that you want/don't want. Display shows columns for Folder Name, Folder Size, Creation or Modification Date/Time, Path.
* 9. Press Ctrl+D (replaces <folder> with folder size).
NB: at this point you could Ctrl+A (select all) and copy all items (Ctrl+C or Ctrl+P) in the search results (including column names) to Clipboard, and then paste into Excel for immediate use.
* 10. Saved Search as "DCF dcwul62-01.x2fnd".
NB: At this point you have a repeatable search/display pattern of the above, to run whenever required at some future point.
To repeat in future is a simple 2-step process:

* 1. Activate the saved search file.
* 2. Ctrl+A (select all) and copy all items (Ctrl+C or Ctrl+P) in the search results (including column names) to Clipboard, and then paste into Excel for immediate use.
I haven't tried it, but you could probably automate this further using AutoHotKey or AutoIT.

Hope this is of some use/help.

Navigation

[0] Message Index

[#] Next page

[*] Previous page