Author Topic: List all subfolders on multiple drives to text of csv (Read 22771 times)

dcwul62 · « **on:** August 27, 2013, 08:21 AM »

On multiple drives/partitions I have certain rootfolders, like x:\SomeRootFolderName\ with a lot of subfolders.
At regular intervals I create listings of the subfolder-names (not files..) including size, date/time, path and copy paste them into Excel.

Quite some click here, there select all, copy paste, browse down in Excel, then next drrive, select/copy/paste etc.

Tried to find a tool/batch file that can do this.
Where I can edit/add the drives-folders myself and when running it generate a listing to clipboard, which i can paste into Excel?

Have looked at SMF
Thread: Create a file list from multiple folders at https://www.donation...ex.php?topic=31520.0
but I think it can't generate a folderlisting.

Thanks!
=

4wd · « **Reply #1 on:** August 27, 2013, 08:52 AM »

SMF can do it:

Select the folder, and set it so it does folders only:

2013-08-27 23_39_42-SMF - Search my Files - v2.0 (2012-Feb-11).png

List all subfolders on multiple drives to text of csv

Click File-Information to collect, select DirGetSize & Count, then click Search

2013-08-27 23_40_16-SMF - Search my Files - v2.0 (2012-Feb-11).png

List all subfolders on multiple drives to text of csv

After it's done, select the result columns you want, first two are compulsary but that's OK atm, then press Show Report:

2013-08-27 23_40_34-Select Report Data Columns - SMF - Search my Files - v2.0 (2012-Feb-11).png

List all subfolders on multiple drives to text of csv

Select everything and right-click to bring up the menu:

2013-08-27 23_43_32-Search Report - SMF - Search my Files - v2.0 (2012-Feb-11).png

List all subfolders on multiple drives to text of csv

Select the info you want and click Export Data:

2013-08-27 23_44_15-SMF - Export to Clipboard.png

List all subfolders on multiple drives to text of csv

It's output to the clipboard as CSV data.

tomos · « **Reply #2 on:** August 27, 2013, 08:54 AM »

I think you have Directory Opus (?)

menu: Tools > Print/Export folder listing

there's possibly better ways, but you could filter for a non-existant filetype (see shot), then you'll only get folders.

You have the options to just show current columns or select which you want.

List all subfolders on multiple drives to text of csv

4wd · « **Reply #3 on:** August 27, 2013, 08:56 AM »

Or yes, there's DOpus

$:-\$

tomos · « **Reply #4 on:** August 27, 2013, 08:57 AM »

^SMF looks interesting

(and - I'm not sure if they have Dopus)

dcwul62 · « **Reply #5 on:** August 27, 2013, 09:49 AM »

Yes, I am using Opus, but there I have to select each drive and copy paste them into Excel, removing headers, bla bla.
Directory Opus (as far as I know) sofar does not support, say F:\Folder1; G:\Folder2; H:\Folder3 etc. (so it is one-by-one)

@4wd: SMF Yes, I found it, the folder thing.
Regretfully, it converts sizes and dates a bit differently, e.g.
2012.11.07-15:47:48 results in 20121107154748

I think I will stick to Opus and accept the extra copy paste once in a while. Was hoping for a very simple solution.

=

=

skwire · « **Reply #6 on:** August 27, 2013, 10:09 AM »

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

How deep are you going into those root folders you mention? One level? Two? All?

4wd · « **Reply #7 on:** August 27, 2013, 10:39 AM »

Regretfully, it converts sizes and dates a bit differently, e.g.
2012.11.07-15:47:48 results in 20121107154748
-dcwul62 (August 27, 2013, 09:49 AM)

A logical format in a constantly increasing number - makes it really easy to sort data

However, since this is going into Excel I would have thought that a simple data format conversion on the column would fix that - something Excel should be more than capable of doing.

At least with SMF you can do all folders across all drives at once.

rjbull · « **Reply #8 on:** August 27, 2013, 03:00 PM »

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.

4wd · « **Reply #9 on:** August 27, 2013, 09:40 PM »

NOTE: I don't use Excel, I have Softmaker Office which has PlanMaker but I don't see this being that different.

Further to the import into Excel, all fields are Text with the exception of size which is Number:

This is the data output by SMF with a little formatting:

2013-08-28 12_37_00-PlanMaker - [Clipboard_20130828.pmd].png

2013-08-28 12_37_00-PlanMaker - [Clipboard_20130828.pmd].png

To get it after import:

For the date:
2013-08-28 12_41_12-Cell.png

For the size:
2013-08-28 12_41_30-Cell.png

Another note, I use a spreadsheet program on average, once every 5 years - so there's probably a lot easier way to do this. eg. Make a worksheet template and import the data so it appears already formatted.

dcwul62 · « **Reply #10 on:** August 28, 2013, 12:46 AM »

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

How deep are you going into those root folders you mention? One level? Two? All?
-skwire (August 27, 2013, 10:09 AM)

@skwire: only 1 level, so:
x:\basefolder\subfolder1
x:\basefolder\subfolder2
x:\basefolder\subfolder3
etc.

like this:

=
Directory Opus-FolderPrint-28082013 072322.png

Directory Opus-FolderPrint-28082013 072322.png

=

dcwul62 · « **Reply #11 on:** August 28, 2013, 01:09 AM »

@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.

=
SnagIt-28082013 080853.png

=

dcwul62 · « **Reply #12 on:** August 28, 2013, 01:21 AM »

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)

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 · « **Reply #13 on:** August 28, 2013, 02:33 PM »

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)

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 · « **Reply #14 on:** August 28, 2013, 06:26 PM »

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.

dcwul62 · « **Reply #15 on:** August 28, 2013, 11:21 PM »

@IainB / @rjbull

Thank you both for trying to help me.
It is truly appreciated!

The thing is that I want to have :
- foldernames, sizes, dates, paths
- of subfolders only (not files)
- that are on multiple partitions/drives

so, like

X:\basefolder\subfolder1
\subfolder2
\subfolder3

Y:\basefolder\subfolder-a
\subfolder-b
\subfolder-c

Z:\basefolder\subfolder-001
\subfolder-001
\subfolder-001

=

List all subfolders on multiple drives to text of csv
=

Using Directory Opus resulting into excel sheet like this:

=

List all subfolders on multiple drives to text of csv
=

Regretfully, Directory Opus folderprint, sofar, does not accept multiple folders.

=

List all subfolders on multiple drives to text of csv
=

Thanks
=

IainB · « **Reply #16 on:** August 29, 2013, 01:59 AM »

Sorry, I don't understand.
The worked example using xplorer² that I gave indicates that you set up and save a folder search as described - in your case, one each for:
X:\basefolder
Y:\basefolder
Z:\basefolder

The repetitive task then boils down to:

1. Double-click each of the saved search files (3 of them) and wait for the search to complete and display results.
2. Select All, Copy to Clipboard the selected search results for each (3 copy operations).
3. Paste the search results into spreadsheet (3 paste operations).

You could automate this further.

Would that not provide you with the desired result?

stewcam · « **Reply #17 on:** August 29, 2013, 07:37 AM »

FileLocator Pro can handle this task. Maybe also the freeware version FileLocator Lite (aka Agent Ransack).

rjbull · « **Reply #18 on:** August 29, 2013, 05:13 PM »

The thing is that I want to have :
- foldernames, sizes, dates, paths
- of subfolders only (not files)
- that are on multiple partitions/drives
-dcwul62 (August 28, 2013, 11:21 PM)

I tried putting "directory listing csv" into DuckDuckGo and found quite a lot of relevant postings. One that might suit you is List Maker (I haven't tried it). But I think that whatever application you use, you will have to run it multiple times to cover multiple drives. That's why I'd suggest a command line tool, because then you can put it into a batch file to run it as many times as you want with however many drives you have.

stewcam · « **Reply #19 on:** August 30, 2013, 01:12 AM »

@ rjbull, FileLocator Pro can in fact handle multiple drives in a single pass

krksoft · « **Reply #20 on:** August 30, 2013, 04:28 PM »

Hi, I am the author of Directory Lister Pro and I believe my software can do exactly what you want.
It can list just folder names (by unchecking the "File rows" option on the "Display" page).
It can list all the properties you want (these are selectable on the first page).
You can select as many directories as you want on the tree.
It can save the listing as an CSV file (choose it on the "Output type" page) which can be directly opened in Excel.
In case of any issues I will personally help you get the listing you want.
Various screenshots (including CSV preview) are located on our web site http://www.krksoft.com

/Leszek

stewcam · « **Reply #21 on:** August 30, 2013, 09:52 PM »

@ krksoft - impressive; is there a discount available to DonationCoders?

krksoft · « **Reply #22 on:** August 31, 2013, 02:44 AM »

why not

http://tinyurl.com/q4bmj8e
if the link does not work, the coupon code is donationcoder

skwire · « **Reply #23 on:** September 01, 2013, 11:06 AM »

Welcome to the DonationCoder site, Leszek, and thank you for the wonderful gesture.

dcwul62 · « **Reply #24 on:** September 02, 2013, 01:46 AM »

@krksoft - hello to you - thanks for your input here.
I've downloaded/installed your program and have trying to figure out to get the results exactly the way I like.

a. name of parent folder, without... further listing of the name of any subfolders
b. total size of that folder (incl the size of subfolders)

In Directory Opus, I select all folders (ctrl-a), click tools/print, paste into Excel.

The listings look like this.

=

OpusFolderPrint-Pasted into Excel-02092013 080641.png

List all subfolders on multiple drives to text of csv
=

Directory List Pro - by default seems to add the subfoldernames, e.g.
J:\TestFolders\TestFolder-number-001\some folder

=

Directory List Pro-adds subfoldernames-by default-02092013 082124.png

List all subfolders on multiple drives to text of csv
=

I have been 'playing' with Directory List Pro just for a very short while, so bear with me that I have not found the solution that may indeed be available.

- I cud untag all subfolders one by one..
- indeed the \subfolder names are not listed
- but the total size is not correct
at least, as far as I can see, but I might be missing an option here or there :-)

=

Directory List Pro-without subfoldernames added-incorrect size-02092013 082127.png

List all subfolders on multiple drives to text of csv
=