Send to File: Directory, Subdir Contents + File Info

[rjbinney]

Trying to get a TXT file with:
- Full filepath+filename
- File size
- Created date

I would like to be able to do this for a master directory, and have it do it automatically for all the subdirs.

If I do:

Code: [Select]

dir /s >Directory.txt
I get a nice list of files + File info, but not the file path.

Directory of B:\Master\Subdirectory 1
11/19/2022 22:04 <DIR> .
11/19/2022 22:04 <DIR> ..
03/10/2014 18:14 43,309,056 00000.MTM
03/10/2014 18:16 54,355,968 00001.MTM
03/10/2014 18:17 46,884,864 00002.MTM

 Directory of B:\Master\Subdirectory 1\Double-Sub

11/19/2022  22:34    <DIR>          .
11/19/2022  22:34    <DIR>          ..
03/31/2014  02:10         5,157,601 S1710001.JPG
03/31/2014  02:10         5,170,611 S1710002.JPG
03/31/2014  03:07         5,023,670 S1710003.JPG

If I do

Code: [Select]

dir /s /b >PathList.txt
I get

B:\Master\Subdirectory 1\00000.MTM
B:\Master\Subdirectory 1\00001.MTM
B:\Master\Subdirectory 1\00002.MTM
B:\Master\Subdirectory 1\Double-Sub\S1710001.JPG
B:\Master\Subdirectory 1\Double-Sub\S1710002.JPG
B:\Master\Subdirectory 1\Double-Sub\S1710003.JPG

Without the file info.

What I'd like is:

03/10/2014 18:14       43,309,056 B:\Master\Subdirectory 1\00000.MTM
03/10/2014 18:16       54,355,968 B:\Master\Subdirectory 1\00001.MTM
03/10/2014 18:17       46,884,864 B:\Master\Subdirectory 1\00002.MTM
03/31/2014  02:10       5,157,601   B:\Master\Subdirectory 1\Double-Sub\S1710001.JPG
03/31/2014  02:10         5,170,611   B:\Master\Subdirectory 1\Double-Sub\S1710002.JPG
03/31/2014  03:07         5,023,670   B:\Master\Subdirectory 1\Double-Sub\S1710003.JPG

Anything in CMD, Win 11, or an app that can help?

[BC_Programmer]

This is a bit closer to what you want.

Code: [Select]

@echo off & for /f %a in ('dir /s /b') do echo %~ta %~za %~fa
Size doesn't have commas and there's no good way (I don't think) of right-padding the size so that things line up in the output text file. It's also rather slow, though assuming it doesn't need to be run frequently that probably isn't of great concern.

You could use semicolons instead of spaces between the variables in the echo, then you could import the file as a CSV into Excel or another spreadsheet program for easier review if necessary.

[rjbinney]

Thanks. This just gave me a long list of the first 12 characters of the filepath onscreen...

I will want to import this into Excel. Sorry to be dense, where would I put the semicolons to create that file? (I'm not sure what the "variables" are... Would it be:

@echo off & for /f %a in ('dir /s /b') do echo %~ta;%~za;%~fa

And where do I specify the name of the output file?

[Hackoo]

Hi 
You can write a batch file with some commands from PowerShell, like this one :

Code: [Select]

@echo off
Title Export Directory Information to CSV File using Powershell and Batch
Set MainDirectory="C:\Path of your Main Directory to be changed to yours\"
Set CSV_File="%AppData%\FilesInfos.csv"
Powershell -C "LS -path "%MainDirectory%" -Recurse | where {!$_.PSIsContainer} | Select-object LastWriteTime,Length,FullName | export-csv -encoding unicode -notypeinformation -path "%CSV_File%""
If Exist %CSV_File% Start "" %CSV_File%