Scan folder for program information

I think most of us have heard of MediaInfo and it is a very powerful tool. However, I find it doesn't work well with WTV files, such as not showing any audio information.

I'd like to propose a feature request that would scan a folder of files (such as a season of recorded television shows) and export a text file or csv file that would list information about each file in the folder. Currently, I need to open each file in VideoRedo and Ctrl+L to see info for each file in the folder.

The reason for my need, I have been converting mpeg2 tv shows to h264 for better compatibility and I cannot always remember where I left off.
 

Dan203

Senior Developer
Staff member
If your the coding type you could do this with a script using our COM interface.
 
Thank you Dan, but unfortunately I am not good at coding. I Googled the VideoRedo COM interface and found your page with examples, etc. and I'm afraid I'd do more damage than good.

My solution is to run a batch manager converting all the files to Audio only (for speed purposes) and then scroll through the log text file which displays all the source video information as well as the audio information.
 

dlflannery

Moderator
5t

I use the COM interface extensively in my VAP program, see link in my signature. I could probably gen up a program to do what you want with minimal effort. If you are interested please specify exactly what information you want for each file. I would recommend a .tsv output file. (TSV = tab-separated-values, a variation of CSV that has advantages and loads easily in Excel). Normally a first header line is included that indicates the names of the variables.
 
Thank you kind sir. I actually have your VAP installed and intend to use it for future recordings once I get everything organized. Ideally, I'd like the ability to view the same information that is available in the "Program Information" displayed from within VideoRedo. Below is an example of what was output using that technique. Thanks again!

File: Name : M:\Recorded TV\It's Always Sunny in Philadelphia_FXXHD_2017_01_11_21_58_00.wtv
Size : 1.246 GB
Duration : 00:41:56.40
Mux type : WTV
Video: Encoding : H.264
VideoStreamID : x226
Frame rate : 59.94 fps
Encoding size : 1280 x 720
Aspect ratio : 16:9
Header bit rate : 5.000 Mbps
VBV buffer : 774 KBytes
Profile : High/3.2
Progressive : Progressive
Chroma : 4:2:0
Entropy mode : CABAC
Bit rate : 3.250 Mbps
Captioning : EIA 608/708
Audio Stream: 1 (Primary) Codec : AC3
Format : AC3 stream
Channels : 5.1
Language : eng
PID : x224
PES Stream Id : xBD
Bit rate : 384 Kbps
Sampling rate : 48000
Sample size : 16 bits
Audio Stream: 2 Codec : AC3
Format : AC3 stream
Channels : 2.0
Language : spa
PID : x225
PES Stream Id : xBD
Bit rate : 192 Kbps
Sampling rate : 48000
Sample size : 16 bits
 

dlflannery

Moderator
..........
The reason for my need, I have been converting mpeg2 tv shows to h264 for better compatibility and I cannot always remember where I left off.
Do you have some other purpose for what you want? I'm surprised you want all that detailed info just to keep track of where you left off. Also, are you aware of VAP's ability to move input files that have been processed to another folder? Seems like that could be used to keep track. VAP has a single input folder (the "monitored" folder) but if you're processing inputs from an assortment of other folders you can select and move them into the monitored folder. This will be almost instantaneous IF all the folders are on the same drive.

Anyway if you still would like the full details as per your example, it shouldn't be a major programming issue. You're just going to have some mighty long text lines (or wide Excel lines).
 
I have to admit, I was trying to reply quickly and wanted to make sure to use the correct terminology and used the Program Information as a template. I didn't really think beyond that and you are right. The most useful information for my purposes would be:

File: Name : M:\Recorded TV\It's Always Sunny in Philadelphia_FXXHD_2017_01_11_21_58_00.wtv
Size : 1.246 GB
Duration : 00:41:56.40
Mux type : WTV
Video: Encoding : H.264
Frame rate : 59.94 fps
Encoding size : 1280 x 720
Aspect ratio : 16:9
Header bit rate : 5.000 Mbps
Bit rate : 3.250 Mbps
Audio Stream: 1 (Primary) Codec : AC3
Format : AC3 stream
Channels : 5.1
Language : eng
Bit rate : 384 Kbps
Audio Stream: 2 Codec : AC3
Format : AC3 stream
Channels : 2.0
Language : spa
Bit rate : 192 Kbps

I like the idea of TSV for Excel purposes. I can always massage the output, but if the items listed above were the column headers (obviously filename column would be very long), that would be the most useful to me to not only see where I left off, but I often have missing episodes that I have on a keyword search and will fill in those episodes. I could run your program on a series and see where I stand as far as versions and compatibility with various players.

Thank you so much!
 

Dan203

Senior Developer
Staff member
FYI the COM interface has a simple function for grabbing that info as XML.
 

dlflannery

Moderator
@tangoalpha,

Where do you want the output TSV file to go?

Some options:
Folder containing video files that are analyzed?
Folder you select?
Fixed folder?

Also, any naming preferences for it? If located in the folder containing video files, could have a fixed name like vrdFileInfo.tsv.

Also, do you actually care about the "header bit rate" ? (The bit rate usually is more significant.)

In an effort to limit the number of columns, I plan to provide the first two audio stream's data. Is that a problem?
 
Regarding output, I guess I would envision selecting a TV series folder and having the output saved to the same folder. I could always move it if I wasn't satisfied where it was saved.

Naming convention for the file itself: Could you have a default as you suggest with an option to save as? vrdFileInfo.tsv is a very descriptive name and if it is saved to the folder with the files, I think that would work just fine.

I agree with you again, bit rate would be more useful than header bit rate.

However, regarding the audio, would it be possible to list the first 4 streams? As it turns out, that is the difference in a lot of my versions. The main thing I'm looking for in the audio is AC3 or AAC and the number of channels and the bitrate. Language is not critical. (I intend to use this with movies as well where I have different variations of video resolution and containers with different audio)

Thanks again!
 

dlflannery

Moderator
OK try ver. 1.0 in attached zip. Just extract the two files to any folder although folders in the program files folder trees are not recommended.

Create a shortcut to the .exe file for convenience. Just launch and hit the "start" button.

Up to four audio tracks are output, as you desired. If a data value isn't available "NA" is output.

The output file is "vrdFileInfo.tsv" and is placed in the folder containing the videos analyzed.

I have an old public domain Excel substitute. When I import the .tsv into it, it interprets aspect ratio values as time data (because of the colon), e.g.,
4:3 is displayed as 4:30 AM and 16:9 is displayed as 4:09 PM. I can force a proper display by imposing a different format to those cells. All other data seems to come through OK. Check out your spreadsheet program in regard to this type of issue.

Note this program only works with the COM function distributed with TVS5.
 

Attachments

This is fantastic! Thank you!

After using it on several folders, I was wondering, would it be possible to add the ability to run the program against a parent folder? Meaning, right now, I run it against a folder that contains one season of episodes. Would it be possible to run it against the series folder, which contains a folder for each season? The output could be one file, or separate files to each folder.

BTW, it opens great into Excel. The aspect ratio is displayed 16:09.
 
That's it! You are the man. I browsed around for a donate button for your efforts, but I couldn't locate one. I know the amount I donate will likely be an insult, but if enough people find it useful and donate, it might be of value. Please send me a PM or some way to donate via Paypal and I'll gladly do so.

Thank you very much!
 

dlflannery

Moderator
That's it! You are the man. I browsed around for a donate button for your efforts, but I couldn't locate one. I know the amount I donate will likely be an insult, but if enough people find it useful and donate, it might be of value. Please send me a PM or some way to donate via Paypal and I'll gladly do so.

Thank you very much!
I appreciate the thought, but I just do this for fun.
 
Hello Mr dlflannery,
After having used the VrdMediaInfo 1.1 for nearly 3 years, I attempted to use it today after upgrading to Windows 10 and VRD 6 and it threw the error

"VBS script file: "videoFileInfo54.vbs" is missing from run time folder"

I assume this is because I didn't install VRD 5 when I installed Windows 10. I only installed VRD 6.

Any chance in your free time that there is an update that could be made to VrdMediaInfo 1.1?

Thank you for the many years of use I got from this
 
Top Bottom