Welcome to Doom9's Forum, THE in-place to be for everyone interested in DVD conversion.

Before you start posting please read the forum rules. By posting to this forum you agree to abide by the rules.

 

Go Back   Doom9's Forum > Announcements and Chat > General Discussion

Reply
 
Thread Tools Search this Thread Display Modes
Old 29th June 2020, 22:31   #1  |  Link
loninapleton
Registered User
 
Join Date: Jun 2019
Posts: 15
Output sheet view to a text file in MediaInfo

I have been struggling with just making a sheet view text file in MediaInfo. It's probably an easy do in Export ->

But I'm not getting a result. The Export screen with 10 options or whatever it is just makes it confusing.

MediInfo searches keep referencing command line.

Therefore In Win7:

Please give the _steps_ to make a text file in the sheet mode seen in View of MediaInfo. Start with loading the program.
loninapleton is offline   Reply With Quote
Old 30th June 2020, 08:40   #2  |  Link
tebasuna51
Moderator
 
tebasuna51's Avatar
 
Join Date: Feb 2005
Location: Spain
Posts: 5,873
If you want a 'sheet view text file' to be oppened in Excel (Office) or Calc (LibreOficce) you can try the 'CSV' format in Export screen.

If you want a standard text file, to be read be Notepad or Writer (LibreOficce), the 'sheet' mode don't have sense, use the 'text' mode instead.
__________________
BeHappy, AviSynth audio transcoder.
tebasuna51 is offline   Reply With Quote
Old 30th June 2020, 17:03   #3  |  Link
Gavino
Avisynth language lover
 
Join Date: Dec 2007
Location: Spain
Posts: 3,405
Quote:
Originally Posted by tebasuna51 View Post
... don't have sense ...
Teba, the Spanish phrase 'no tiene sentido' is better expressed in English as 'doesn't make sense'.
__________________
GScript and GRunT - complex Avisynth scripting made easier
Gavino is offline   Reply With Quote
Old 30th June 2020, 18:29   #4  |  Link
loninapleton
Registered User
 
Join Date: Jun 2019
Posts: 15
Aside from the language proprietis I _have not understoood_ these verbal descriptions.

Give the steps:

Load MKV > MediaInfo > File > Export > Text Tab >

Here is where I get nothing. They want to deposit the file in MediaInfo program someplace. When I try to
put it on the desktop or give it a name-- all of that. I cannot locate the supposed text file made.
I've tried just saving the "example" and then do a search for it and nother is found. This should be dirt simple.
Giving steps is the simple solution.
loninapleton is offline   Reply With Quote
Old 30th June 2020, 19:20   #5  |  Link
stax76
Registered Lurker
 
Join Date: Jun 2002
Posts: 6,427
Maybe you can get it with another app:

https://github.com/stax76/MediaInfo.NET
stax76 is offline   Reply With Quote
Old 1st July 2020, 00:36   #6  |  Link
tebasuna51
Moderator
 
tebasuna51's Avatar
 
Join Date: Feb 2005
Location: Spain
Posts: 5,873
Yes, my english is poor.
And maybe I can't understand loninapleton.

What is the problem to write the desired location (1) or click in (2) to select folder and name.
Attached Images
 
__________________
BeHappy, AviSynth audio transcoder.
tebasuna51 is offline   Reply With Quote
Old 2nd July 2020, 08:03   #7  |  Link
loninapleton
Registered User
 
Join Date: Jun 2019
Posts: 15
Yes I have got that much now.
But what I see in various 'tags' to for example an MP4
movie seems to require more editing than I want to bother with.

I'll give an example of that base text mode in your example and then show what is requested by a site I use. It can't be that difficult. People do hundreds.

Next time I'll have the samples.
loninapleton is offline   Reply With Quote
Old 3rd July 2020, 00:29   #8  |  Link
loninapleton
Registered User
 
Join Date: Jun 2019
Posts: 15
This is from Media Info. I just deleted the name for personal reasons

General
Unique ID : 200511826934187819816573694852055602650 (0x96D92C54D85C27696D87AC2DFDDE95DA)
Complete name Part One.mkv
Format : Matroska
Format version : Version 4
File size : 383 MiB
Duration : 1 h 20 min
Overall bit rate : 662 kb/s
Encoded date : UTC 2017-08-22T20:57:21Z
Writing application : HandBrake 1.0.7 2017040900
Writing library : Lavf57.7.2

Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L4
Format settings : CABAC / 4 Ref Frames
Format settings, CABAC : Yes
Format settings, Reference frames : 4 frames
Codec ID : V_MPEG4/ISO/AVC
Width : 720 pixels
Height : 480 pixels
Display aspect ratio : 16:9
Frame rate mode : Variable
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Writing library : x264 core 148 r2708 86b7198
Encoding settings : cabac=1 / ref=2 / deblock=1:0:0 / analyse=0x1:0x111 / me=hex / subme=6 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=3 / lookahead_threads=1 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=3 / b_pyramid=2 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=1 / keyint=240 / keyint_min=24 / scenecut=40 / intra_refresh=0 / rc_lookahead=30 / rc=crf / mbtree=1 / crf=24.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=20000 / vbv_bufsize=25000 / crf_max=0.0 / nal_hrd=none / filler=0 / ip_ratio=1.40 / aq=1:1.00
Default : Yes
Forced : No
Color range : Limited
Color primaries : BT.601 NTSC
Transfer characteristics : BT.709
Matrix coefficients : BT.601

Audio
ID : 2
Format : AAC LC
Format/Info : Advanced Audio Codec Low Complexity
Codec ID : A_AAC-2
Duration : 1 h 20 min
Channel(s) : 2 channels
Channel layout : L R
Sampling rate : 48.0 kHz
Frame rate : 46.875 FPS (1024 SPF)
Compression mode : Lossy
Delay relative to video : -21 ms
Title : Stereo
Language : English
Default : Yes
Forced : No
Duration_Source : General_Duration

Text #1
ID : 3
Format : VobSub
Codec ID : S_VOBSUB
Codec ID/Info : Picture based subtitle format used on DVDs
Language : English
Default : No
Forced : No

Text #2
ID : 4
Format : VobSub
Codec ID : S_VOBSUB
Codec ID/Info : Picture based subtitle format used on DVDs
Language : French
Default : No
Forced : No

Text #3
ID : 5
Format : VobSub
Codec ID : S_VOBSUB
Codec ID/Info : Picture based subtitle format used on DVDs
Language : German
Default : No
Forced : No

Text #4
ID : 6
Format : VobSub
Codec ID : S_VOBSUB
Codec ID/Info : Picture based subtitle format used on DVDs
Language : Spanish
Default : No
Forced : No

Text #5
ID : 7
Format : VobSub
Codec ID : S_VOBSUB
Codec ID/Info : Picture based subtitle format used on DVDs
Language : Italian
Default : No
Forced : No

Text #6
ID : 8
Format : VobSub
Codec ID : S_VOBSUB
Codec ID/Info : Picture based subtitle format used on DVDs
Language : Dutch
Default : No
Forced : No

Text #7
ID : 9
Format : ASS
Codec ID : S_TEXT/ASS
Codec ID/Info : Advanced Sub Station Alpha
Compression mode : Lossless
Language : English
Default : No
Forced : No

Menu
00:00:00.000 : :Chapter 1
00:02:09.129 : :Chapter 2
00:05:03.428 : :Chapter 3
00:32:31.950 : :Chapter 4
00:48:47.425 : :Chapter 5
01:20:47.885 : :Chapter 6

Then a sample of the desired format. (not the same content)
I don't know how to get there regardless of how simple it may be.
Quote:
MEDIAINFO
Container = Matroska (mkv)
Duration = 00:49:33.984
Filesize = 3.0 GiB
Overall BitRate = 8 600 kb/s

Video
Codec info = AVC High@L4 CABAC / 4 Ref Frames
Resolution = 1920x1080
Display AR = 1.778 (16:9)
Bitrate = 7 765 kb/s
Framerate = CFR 25.000
Samples = YUV, 4:2:0, 8 bits
Encoder = x264 - core 160 r3000 33f9e14

Audio
Codec info = AC-3
Channels = 2 (2/0/0)
Bitrate = 192 kb/s CBR
Samplerate = 48000
Languaje = Spanish

Audio
Codec info = E-AC-3
Channels = 6 (3/2/0.1)
Bitrate = 640 kb/s CBR
Samplerate = 48000
Languaje = Italian

Subs
Format = UTF-8
Languaje = Spanish

Subs
Format = UTF-8
Languaje = Spanish

Subs
Format = UTF-8
Languaje = Italian

Last edited by tebasuna51; 3rd July 2020 at 11:27. Reason: Modify info
loninapleton is offline   Reply With Quote
Old 3rd July 2020, 11:38   #9  |  Link
tebasuna51
Moderator
 
tebasuna51's Avatar
 
Join Date: Feb 2005
Location: Spain
Posts: 5,873
You must use the MediaInfo command line version.

Read the ...MediaInfo\Contrib\CLI_Help.doc and you can create a loninapleton.txt file (attached) to format the output and used like this:

C:\Portable\MediaInfo\MediaInfo.exe --Inform=file://C:\Portable\MediaInfo\loninapleton.txt "your_input.mkv" >Your_info.txt
Attached Files
File Type: txt loninapleton.txt (840 Bytes, 8 views)
__________________
BeHappy, AviSynth audio transcoder.

Last edited by tebasuna51; 3rd July 2020 at 11:47.
tebasuna51 is offline   Reply With Quote
Old 3rd July 2020, 19:12   #10  |  Link
loninapleton
Registered User
 
Join Date: Jun 2019
Posts: 15
Ok this is helpful. I didn't know if CLI was a function of the program or a CLI in an operating system. I'll review what you've shown. Very likley more questions will follow.

Apologies for an inappropriate attachment.
loninapleton is offline   Reply With Quote
Old 3rd July 2020, 19:31   #11  |  Link
loninapleton
Registered User
 
Join Date: Jun 2019
Posts: 15
Can I make a template in Notepad for the whole path needed and just change out the individual file name? And is this invoked at
the CMD prompt?

In the example

C:\Portable\MediaInfo\MediaInfo.exe --Inform=file://C:\Portable\MediaInfo\loninapleton.txt "your_input.mkv" >Your_info.txt

I'd have to do by rote the path at C:

c\my folder >subfolder > mkv name

I am not knowledgeable on handling directory trees and such at system. Can you help with the needed string. Then I could paste from a Notepad template.

I'll try some practice but some sort of streamlining would be helpful.
loninapleton is offline   Reply With Quote
Old 4th July 2020, 12:20   #12  |  Link
patul
Registered User
 
Join Date: Sep 2005
Posts: 75
Am a lazy person and never care enough to find better solution, but for multiple files operations, I usually just create a batch file, by first creating the list of the files to be processed:

Quote:
dir /b *.mkv > output.txt
Then I will open the output.txt in text editor, using column mode, add the additional commands. In your case will be

Quote:
C:\Portable\MediaInfo\MediaInfo.exe --Inform=file://C:\Portable\MediaInfo\loninapleton.txt " ==> as prefix
" >Your_info.txt ==> as suffix
If it's too complex to handle using text editor, I would use excel instead. Then I will save it as batch file (*.bat) and run it.

There's also PowerShell that can do this in one liner set of commands using pipes, but I've never been particularly fond of PowerShell.
patul is offline   Reply With Quote
Old 4th July 2020, 15:27   #13  |  Link
StainlessS
HeartlessS Usurer
 
StainlessS's Avatar
 
Join Date: Dec 2009
Location: Over the rainbow
Posts: 8,221
This seems to work

MediaInfo.BAT [or MediaInfo.CMD]
Code:
REM https://forum.doom9.org/showthread.php?p=1917515#post1917515
REM https://forum.doom9.org/showthread.php?p=1908619#post1908619

REM We DO NOT LIKE SPACES IN FILE NAMES (REM == REMark ie comment)
REM We DO NOT LIKE ACCENTS IN FILE NAMES.

setlocal

REM Where to Find MediaInfo CLI version, eg "C:\Portable\MediaInfo\MediaInfo.exe"
set MEDIAINFO="C:\BIN\MediaInfo.exe"

REM Where to Find Inform.txt template, eg "C:\Portable\MediaInfo\loninapleton.txt"
set INFORM="C:\BIN\Inform.txt"

REM Where to get INPUT files, No terminating Backslash, "." = current directory (ie same dir as .Bat or .Cmd file)
set INDIR="."

REM Where to place OUTPUT files (MUST exist), No terminating Backslash. "." would be same as .bat file, ".\OUT" = OUT folder in same directory as bat file.
set OUTDIR=".\OUTPUT"


REM Below, can add INPUT extensions as eg *.WEBM (SPACE separated, Batch Processes all INPUT type files in INDIR)
FOR %%A IN (*.AVI *.MKV *.MP4 *.MOV *.QT *.3GP *.DVB *.VOB *.MPG *.MPEG *M2P *.PS *.TS *.DIVX *.XVID *.FLV *.WMV *.ASF *.MXF) DO (

%MEDIAINFO%  --Inform="file://%INFORM%"  "%INDIR%\%%A"    >"%OUTDIR%\%%~nxA.txt"

)
Pause
You need edit (see REM's) for you system, my MediaInfo CLI version is in C:\BIN\

Modified from bat here:- https://forum.doom9.org/showthread.p...19#post1908619
which was originally written by someone else, and just has some mods by me.

Here is result of 2 files out of about 8 I tested with, no probs. (I used Tebasuna51 loninapleton.txt RENAMED to C:\BIN\Inform.txt)

big_buck_bunny_720p_h264.mov.txt
Code:
MEDIAINFO
Container = MPEG-4 (mov)
Duration = 00:09:56.462
Filesize = 397 MiB
Overall BitRate = 5 590 kb/s

Video
Codec info = AVC Main@L3.1 2 Ref Frames
Resolution = 1280x720
Display AR = 1.778 (16:9)
Bitrate = 5 147 kb/s
Framerate = CFR 24.000
Samples = YUV, 4:2:0, 8 bits
Encoder = 

Audio
Codec info = AAC LC 
Channels = 6 (3/2/0.1)
Bitrate = 448 kb/s CBR
Samplerate = 48000
Languaje = English
LowBitrateAnime.mkv.txt
Code:
MEDIAINFO
Container = Matroska (mkv)
Duration = 00:03:28.683
Filesize = 1.8 MiB
Overall BitRate = 71.3 kb/s

Video
Codec info = AVC High@L4 CABAC / 16 Ref Frames
Resolution = 720x480
Display AR = 1.778 (16:9)
Bitrate = 
Framerate = CFR 23.976
Samples = YUV, 4:2:0, 8 bits
Encoder = x264 - core 80 r1373+1 85eb400

Audio
Codec info = AAC HE-AACv2 / HE-AAC / LC 
Channels = 2 / 1 / 1 (1/0/0)
Bitrate =  
Samplerate = 48000 / 48000 / 24000
Languaje =
I used OUTPUT directory in same directory as BAT file, it MUST exist.
EDIT: Processes all media files with target file extensions that are within the INDIR input directory.

EDIT: As well as NOT liking SPACES in file names, it dont like accents either. [either can break CLI functionality]

EDIT: To change output format, just edit the INFORM text file [in this/my case] "C:\BIN\Inform.txt" as per MediaInfo_CLI docs.
__________________
I sometimes post sober.
StainlessS@MediaFire ::: AND/OR ::: StainlessS@SendSpace

"Some infinities are bigger than other infinities", but how many of them are infinitely bigger ???

Last edited by StainlessS; Yesterday at 14:22.
StainlessS is offline   Reply With Quote
Old 4th July 2020, 20:43   #14  |  Link
loninapleton
Registered User
 
Join Date: Jun 2019
Posts: 15
This certainly looks like a good solution which I can simply
change some input information. I cannot understand how others are doing it: multicolored text, centering. But how to get that from MediaInfo text files is confounding.

I'll review what I can of this. I prefer to print to paper but during my house stay during the Superbug I have not gotten to a library where I would do it.

Is the batch file tested so it actually runs. Any tips on doing this so I don't run into any jams.
loninapleton is offline   Reply With Quote
Old 4th July 2020, 20:45   #15  |  Link
StainlessS
HeartlessS Usurer
 
StainlessS's Avatar
 
Join Date: Dec 2009
Location: Over the rainbow
Posts: 8,221
It runs just fine on my system and paths, should not be too difficult to alter for yours, just no SPACES or Accents in your filenames.
__________________
I sometimes post sober.
StainlessS@MediaFire ::: AND/OR ::: StainlessS@SendSpace

"Some infinities are bigger than other infinities", but how many of them are infinitely bigger ???
StainlessS is offline   Reply With Quote
Old 4th July 2020, 20:48   #16  |  Link
loninapleton
Registered User
 
Join Date: Jun 2019
Posts: 15
After reading more carefully, I see I may have been missing any and all MediaInfo CLI. Is this a separate install. Or is it found in
the MediaInfo folder? If not, where should it go? Apologies for going through such a base level tutorial..
loninapleton is offline   Reply With Quote
Old 4th July 2020, 21:14   #17  |  Link
StainlessS
HeartlessS Usurer
 
StainlessS's Avatar
 
Join Date: Dec 2009
Location: Over the rainbow
Posts: 8,221
https://mediaarea.net/en/MediaInfo/Download/Windows

See under "Interface" column. I think it comes with the doc supplied by a user some years ago.

EDIT: Actualy its not supplied, so here it is [ User contribution, MediaInfo CLI_Help.Doc] :- http://www.mediafire.com/file/5m0gah...I_Help.7z/file
__________________
I sometimes post sober.
StainlessS@MediaFire ::: AND/OR ::: StainlessS@SendSpace

"Some infinities are bigger than other infinities", but how many of them are infinitely bigger ???

Last edited by StainlessS; 4th July 2020 at 21:19.
StainlessS is offline   Reply With Quote
Old Yesterday, 00:25   #18  |  Link
tebasuna51
Moderator
 
tebasuna51's Avatar
 
Join Date: Feb 2005
Location: Spain
Posts: 5,873
Quote:
Originally Posted by StainlessS View Post
EDIT: Actualy its not supplied, so here it is [ User contribution, MediaInfo CLI_Help.Doc] :- http://www.mediafire.com/file/5m0gah...I_Help.7z/file
Is supplied only in 32 bits versions, I don't know for what.

Here is a big list of key names, I don't remember how I make it and can't guarantee than work all, but you can try:
Attached Files
File Type: 7z MediaInfoKeys.7z (9.8 KB, 2 views)
__________________
BeHappy, AviSynth audio transcoder.
tebasuna51 is offline   Reply With Quote
Old Yesterday, 00:37   #19  |  Link
StainlessS
HeartlessS Usurer
 
StainlessS's Avatar
 
Join Date: Dec 2009
Location: Over the rainbow
Posts: 8,221
Thanks Teb, I had only looked at x64.

Code:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\root>mediainfo
Usage: "MediaInfo [-Options...] FileName1 [Filename2...]"
"MediaInfo --Help" for displaying more information

C:\Users\root>mediainfo --help
MediaInfo Command line,
MediaInfoLib - v0.7.88
Usage: "MediaInfo [-Options...] FileName1 [Filename2...]"

Options:
--Help, -h
                    Display this help and exit
--Help-Output
                    Display help for Output= option
--Help-AnOption
                    Display help for "AnOption"
--Version
                    Display MediaInfo version and exit

--Full , -f
                    Full information Display (all internal tags)
--Output=HTML
                    Full information Display with HTML tags
--Output=XML
                    Full information Display with XML tags
--Output=EBUCore
                    Full information Display with EBUCore compliant XML tags
--Output=...y
                    Template defined information Display
--Info-Parameters
                    Display list of Inform= parameters

--Language=raw
                    Display non-translated unique identifiers (internal text)


--LogFile=...
                    Save the output in the specified file
--BOM
                    Byte order mark for UTF-8 output

--Ssl_CertificateFileName=...
                    File name of the SSL certificate.
                    The default format is "PEM" and can be changed
                    with --Ssl_CertificateFormat.
--Ssl_CertificateFormat=...
                    File format of the SSL certificate.
                    Supported formats are "PEM" and "DER"
--Ssl_PrivateKeyFileName=...
                    File name of the SSL private key.
                    The default format is "PEM" and can be changed
                    with --Ssl_PrivateKeyFormat.
                    Note: private key with a password is not supported.
--Ssl_PrivateKeyFormat=...
                    File format of the SSL private key.
                    Supported formats are "PEM" and "DER"
--Ssl_CertificateAuthorityFileName=...
                    File name of the SSL certificate authorities
                    to verify the peer with.
--Ssl_CertificateAuthorityPath=...
                    Path of the SSL certificate authorities
                    to verify the peer with.
--Ssl_CertificateRevocationListFileName=...
                    File name of the SSL certificate revocation list.
                    The format is "PEM"
--Ssl_IgnoreSecurity=...
                    Does not verify the authenticity of the peer's certificate
                    Use it at your own risks
--Ssh_PublicKeyFileName=...
                    File name of the SSH private key.
                    Default is $HOME/.ssh/id_rsa.pub or $HOME/.ssh/id_dsa.pub
                    if the HOME environment variable is set, and just
                    "id_rsa.pub" or "id_dsa.pub" in the current directory
                    if HOME is not set.
                    Note: you need to set both public and private key.
--Ssh_PrivateKeyFileName=...
                    File name of the SSH private key.
                    Default is $HOME/.ssh/id_rsa or $HOME/.ssh/id_dsa
                    if the HOME environment variable is set, and just
                    "id_rsa" or "id_dsa" in the current directory
                    if HOME is not set.
                    Note: you need to set both public and private key.
                    Note: private key with a password is not supported.
--Ssh_KnownHostsFileName=...
                    File name of the known hosts
                    The format is the OpenSSH file format (libssh2)
                    Default is $HOME/.ssh/known_hosts
                    if the HOME environment variable is set, and just
                    "known_hosts" in the current directory
                    if HOME is not set.
--Ssh_IgnoreSecurity
                    Does not verify the authenticity of the peer
                    (you don't need to accept the key with ssh first)
                    Use it at your own risks
Maybe something like this for big list, in C:\Z\ directory
Code:
MediaInfo -f --Info-Parameters --Language=raw >C:\Z\MI_Info_Parameters.txt
EDIT:
The raw parameter names are those names required for extraction of data, ie not human language style names for output(which might be converted to non English and also contain eg SPACES).
Looks like above outputs same text file as attached above by Tebasuna51.
__________________
I sometimes post sober.
StainlessS@MediaFire ::: AND/OR ::: StainlessS@SendSpace

"Some infinities are bigger than other infinities", but how many of them are infinitely bigger ???

Last edited by StainlessS; Yesterday at 01:13.
StainlessS is offline   Reply With Quote
Old Yesterday, 01:00   #20  |  Link
tebasuna51
Moderator
 
tebasuna51's Avatar
 
Join Date: Feb 2005
Location: Spain
Posts: 5,873
Quote:
Originally Posted by loninapleton View Post
I cannot understand how others are doing it: multicolored text, centering.

multicolored text,
centering.

That's are options when you write in the web.

Paste your info and edit it. You can see that here but not in Notepad.
__________________
BeHappy, AviSynth audio transcoder.

Last edited by tebasuna51; Yesterday at 01:07.
tebasuna51 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 05:45.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.