Rename Video files by EXIF data

[beb]

2ZoSTeR

I've checked this specifically before posting.

My ini: [deleted]
It does have EXT="AVI", but it didn't work for AVI unless it was renamed.

Edit: My bad. It appears deep in the night I was checking MediaInfoWDX.wdx detect string instead of the ExifToolWDX.wdx one.
Now when I add EXT="AVI" there it works like a charm.

Thank you very much.

Of course, it makes things even much simpler for the OP.

[BullFrog]

Tested and it works! This tip helped it so much, I can search the files and I can rename them easily just like the JPG files.

Thank you guys, you are the best!

[Fla$her]

MediaInfo app returns date/time in question as:
Mastered date: 2012-04-22 11:04:30

None of the TC's relevant plugins that are known to me (including but not limited to: TCMediaInfo.wdx(64), MediaInfoWDX.wdx(64), mediainfo.wdx, jpg-comment.wdx(64), ExifToolWDX.wdx(64), exif.wdx(64)) can by default recognize, process and return this date/time tag for the AVI file.

Everything that TCMediaInfo cannot by default, it will be able to do after the appropriate configuration TCMediaInfo.xml. That is, it is not a problem to supplement it with the Mastered_Date field.

[BullFrog]

Sadly the [=exiftoolwdx.DateTimeOriginal] is not equal to the Media creation time and not all video files have this
2016-2022 only 1 video file had this record and no other.
Image: https://i.imgur.com/bxGkI9w.png


*Fla$her
Tried to implement mastered_date but it gives blank field, probably missed something.
Added these lines to TCMediaInfo.xml
Image: https://i.imgur.com/mlPc7eg.png

[beb]

Image: https://i.imgur.com/bxGkI9w.png

Out of curiosity, how do you get such a screen? It looks pretty informative, but I cannot see a way to get it myself.

not all video files have this
2016-2022 only 1 video file had this record and no other.

Of course, they don't.

EXIF is a very useful instrument to handle metadata of the digital cameras' images/photographs (that mostly come as JPG), including the principal date/time data.

Videos aren't like that. Date/time metadata would depend on the specific video format and container standards, to begin with, and finally on how the manufacturer implemented the standards for the specific device and its software/firmware.
As a result, some video files could and would not contain any relevant date/time data at all.
And you will be very lucky if most of your video files do contain such data.

As we can see,
- your "MVI_6735.AVI" file (and its family) contains such data that can be obtained by reading the "DateTimeOriginal" field.
- your "2016-03-07 16-11-02.MOV" (and its family) file contains similar data accessible via the "CreateDate" field.

I checked some of my videos shot with an Olympus camera (.mov) and a Sony mobile phone (.mp4), and ExifTool returned for them a pretty similar set of dates (except .mov has two additional Olympus vendor-specific fields, that Sony's .mp4 doesn't):

ExifTool output (2) ...

Code: Select all

[System]        File Name                       : 20160627 140754 P6277284.mov
[System]        File Modification Date/Time     : 2016:06:27 14:07:54+03:00
[System]        File Access Date/Time           : 2023:01:05 23:53:50+02:00
[System]        File Creation Date/Time         : 2016:06:27 14:07:54+03:00
[QuickTime]     Create Date                     : 2016:06:27 14:07:37
[QuickTime]     Modify Date                     : 2016:06:27 14:07:37
[Track1]        Track Create Date               : 2016:06:27 14:07:37
[Track1]        Track Modify Date               : 2016:06:27 14:07:37
[Track1]        Media Create Date               : 2016:06:27 14:07:37
[Track1]        Media Modify Date               : 2016:06:27 14:07:37
[Track2]        Track Create Date               : 2016:06:27 14:07:37
[Track2]        Track Modify Date               : 2016:06:27 14:07:37
[Track2]        Media Create Date               : 2016:06:27 14:07:37
[Track2]        Media Modify Date               : 2016:06:27 14:07:37
[Olympus]       Date Time 1                     : Mon Jun 27 14:07:37 2016
[Olympus]       Date Time 2                     : Mon Jun 27 14:07:37 2016
FileModifyDate                  : 2016:06:27 14:07:54+03:00
FileAccessDate                  : 2023:01:05 23:59:20+02:00
FileCreateDate                  : 2016:06:27 14:07:54+03:00
CreateDate                      : 2016:06:27 14:07:37
ModifyDate                      : 2016:06:27 14:07:37
TrackCreateDate                 : 2016:06:27 14:07:37
TrackModifyDate                 : 2016:06:27 14:07:37
MediaCreateDate                 : 2016:06:27 14:07:37
MediaModifyDate                 : 2016:06:27 14:07:37
DateTime1                       : Mon Jun 27 14:07:37 2016
DateTime2                       : Mon Jun 27 14:07:37 2016


[System]        File Name                       : 20160627 183446 ScreenRecord.mp4
[System]        File Modification Date/Time     : 2016:06:27 18:34:46+03:00
[System]        File Access Date/Time           : 2023:01:05 23:55:03+02:00
[System]        File Creation Date/Time         : 2016:06:30 14:41:58+03:00
[QuickTime]     Create Date                     : 2016:06:27 15:34:47
[QuickTime]     Modify Date                     : 2016:06:27 15:34:47
[Track1]        Track Create Date               : 2016:06:27 15:34:47
[Track1]        Track Modify Date               : 2016:06:27 15:34:47
[Track1]        Media Create Date               : 2016:06:27 15:34:47
[Track1]        Media Modify Date               : 2016:06:27 15:34:47
[Track2]        Track Create Date               : 2016:06:27 15:34:47
[Track2]        Track Modify Date               : 2016:06:27 15:34:47
[Track2]        Media Create Date               : 2016:06:27 15:34:47
[Track2]        Media Modify Date               : 2016:06:27 15:34:47
FileModifyDate                  : 2016:06:27 18:34:46+03:00
FileAccessDate                  : 2023:01:05 23:59:21+02:00
FileCreateDate                  : 2016:06:30 14:41:58+03:00
CreateDate                      : 2016:06:27 15:34:47
ModifyDate                      : 2016:06:27 15:34:47
TrackCreateDate                 : 2016:06:27 15:34:47
TrackModifyDate                 : 2016:06:27 15:34:47
MediaCreateDate                 : 2016:06:27 15:34:47
MediaModifyDate                 : 2016:06:27 15:34:47

It seems you rather have no other option than to research as much as possible of your video files for detecting the full set of possible relevant metadata tags that can represent the date/time info on when they had been taken. And then develop the sorting and renaming methods that could embrace each and all of them.
e.g. Image: https://i.imgur.com/9jfVdus.png:
one column allows sorting and renaming a certain group of files (via ExifTool:DateTimeOriginal), the next column is suitable for doing this with some other files (via MediaInfo:Encoded_Date_General), and so forth...

NB Also, I think it would be a good idea to use both ExifTool and MediaInfo tools to retrieve metadata of the video files.
Secondly, it's not a bad idea to still keep an original filename upon renaming since it may (in case of some vendors) represent the date when a file was taken.
(As you can see, my approach in naming files is very similar to yours, my .mov file has the name "20160627 140754 P6277284.mov" where 'the '20160627 140754" part represents its original date and time and is the result of my renaming, while the "P6277284" part is the original name which at least partially represents the date [627 = month 6 day 27] regarding Olympus naming convention (and could be useful wherever all the other dating sources get somehow lost).

[Dalai]

Tried to implement mastered_date but it gives blank field, probably missed something.
Added these lines to TCMediaInfo.xml
Image: https://i.imgur.com/mlPc7eg.png

This should work:

Code: Select all

<source name="MasteredDate" field="Mastered_Date"/>
<column name="Mastered Date">MasteredDate</column>

Optionally you can add

Code: Select all

coltype="ft_datetime"

to the <column> tag, but only if you're certain that the field is properly detected as date field.

Note that the fields offered by MediaInfo are case-sensitive! Something like "Mastered_date" won't work! The "AddCheck" functions are not necessary.

And, as I said: Look through your video files and compile a list of fields/attributes you need and post it here if you need help with similar modifications.

---

The general rule for adding fields and columns to TCMediaInfo.xml is this: The source tag's name attribute must match the column tag's value, like this:

Code: Select all

<source name="SomeCustomIdentifier" field="FieldNameFromMediaInfo(allprops.txt)"/>
<column name="SomeOtherIdentifierToShowAsColumnNameInTotalCommander">SomeCustomIdentifier</column>

Regards
Dalai

[BullFrog]

Out of curiosity, how do you get such a screen? It looks pretty informative, but I cannot see a way to get it myself.

The left one is this: https://totalcmd.net/plugring/wdx_guide2.html
Fastest way to check if it works.

The right one is windows 10, right click, Properties

Here is a sample file where the OriginalDate is blank but media creation time is still there (and this is what I want to use, it is there on every file)
https://drive.google.com/file/d/1IVbKzGFrBkzAmZy9xkBsO5cHtqnSRWe9/view?usp=share_link

Thank you, added but it still gives blank

[Fla$her]

Thank you, added but it still gives blank

Are the sections followed? Was TC restarting?

[beb]

The left one is this: https://totalcmd.net/plugring/wdx_guide2.html
Fastest way to check if it works.

Great tool, and may be very useful. Thank you.

And returning back to your case:

• Using ExifToolWDX plugin:

To make ExifToolWDX plugin workable with both your AVI(s) and MOV(s) for your purposes you may use:
for AVI:

Code: Select all

[=exiftoolwdx.DateTimeOriginal.Y-M-D h-m-s]

for MOV:

Code: Select all

[=exiftoolwdx.CreateDate.Y-M-D h-m-s]

with the EXT="AVI"|EXT="MOV" within the plugin's detect string in the [ContentPlugins] ini section

Code: Select all

20=%commander_path%\plugins\wdx\ExifTool\ExifToolWDX.wdx
20_detect=EXT="JPG"|EXT="JPGE"|EXT="TIF"|EXT="TIFF"|EXT="NEF"|EXT="AVI"|EXT="MOV"

• Using MediaInfo family plugins

for MOV:
All the MediaInfo, TCMediaInfo, MediaInfoWDX plugins can process date/time in question right out of the box as Encoded Date family tags(s)

Code: Select all

[=mediainfo.encoded date.Y-M-D h-m-s]
[=tcmediainfo.Encoded Date.Y-M-D h-m-s]
[=mediainfowdx.Encoded_Date_General]

• That's how it looks: Image: https://i.imgur.com/UK7qhX6.png

• See also:

2016-10-29 19-39-06.mov MediaInfo app report: dates only

Code: Select all

MediaInfoLib - v21.03
Encoded date                             : UTC 2016-10-29 18:39:03
Tagged date                              : UTC 2016-10-29 18:39:03
File creation date                       : UTC 2023-01-06 07:51:47.587
File creation date (local)               : 2023-01-06 09:51:47.587
File last modification date              : UTC 2023-01-06 07:51:48.505
File last modification date (local)      : 2023-01-06 09:51:48.505
Encoded date                             : UTC 2016-10-29 18:39:03
Tagged date                              : UTC 2016-10-29 18:39:03
Encoded date                             : UTC 2016-10-29 18:39:03
Tagged date                              : UTC 2016-10-29 18:39:03

2016-10-29 19-39-06.mov MediaInfo app report: default output

Code: Select all

General
Complete name                            : E:\Downloads\OneDrive\TEST\EXIF\AVI\VID\2016-10-29  19-39-06.mov
Format                                   : MPEG-4
Format profile                           : QuickTime
Codec ID                                 : qt   2011.07 (qt  )
File size                                : 4.32 MiB
Duration                                 : 1 s 502 ms
Overall bit rate mode                    : Variable
Overall bit rate                         : 24.1 Mb/s
Encoded date                             : UTC 2016-10-29 18:39:03
Tagged date                              : UTC 2016-10-29 18:39:03
TAGS                                     : 8"R

Video
ID                                       : 1
Format                                   : AVC
Format/Info                              : Advanced Video Codec
Format profile                           : High@L4.1
Format settings                          : 1 Ref Frames
Format settings, CABAC                   : No
Format settings, Reference frames        : 1 frame
Codec ID                                 : avc1
Codec ID/Info                            : Advanced Video Coding
Duration                                 : 1 s 502 ms
Bit rate mode                            : Variable
Bit rate                                 : 20.5 Mb/s
Width                                    : 1 920 pixels
Height                                   : 1 080 pixels
Display aspect ratio                     : 16:9
Frame rate mode                          : Constant
Frame rate                               : 29.970 (30000/1001) FPS
Color space                              : YUV
Chroma subsampling                       : 4:2:0
Bit depth                                : 8 bits
Scan type                                : Progressive
Bits/(Pixel*Frame)                       : 0.330
Stream size                              : 3.64 MiB (84%)
Language                                 : Japanese
Encoded date                             : UTC 2016-10-29 18:39:03
Tagged date                              : UTC 2016-10-29 18:39:03
Color range                              : Full
Color primaries                          : BT.601 NTSC
Transfer characteristics                 : BT.601
Matrix coefficients                      : BT.601
Codec configuration box                  : avcC

Audio
ID                                       : 2
Format                                   : PCM
Format settings                          : Little / Signed
Codec ID                                 : sowt
Duration                                 : 1 s 502 ms
Source duration                          : 1 s 520 ms
Bit rate mode                            : Constant
Bit rate                                 : 1 536 kb/s
Channel(s)                               : 2 channels
Channel layout                           : L R
Sampling rate                            : 48.0 kHz
Bit depth                                : 16 bits
Stream size                              : 282 KiB (6%)
Source stream size                       : 285 KiB (6%)
Language                                 : Japanese
Encoded date                             : UTC 2016-10-29 18:39:03
Tagged date                              : UTC 2016-10-29 18:39:03

Report created by                        : MediaInfoLib - v21.03

2016-10-29 19-39-06.mov MediaInfo app report: maximum output

Code: Select all

General
Count                                    : 332
Count of stream of this kind             : 1
Kind of stream                           : General
Kind of stream                           : General
Stream identifier                        : 0
Count of video streams                   : 1
Count of audio streams                   : 1
Video_Format_List                        : AVC
Video_Format_WithHint_List               : AVC
Codecs Video                             : AVC
Video_Language_List                      : Japanese
Audio_Format_List                        : PCM
Audio_Format_WithHint_List               : PCM
Audio codecs                             : PCM
Audio_Language_List                      : Japanese
Complete name                            : E:\Downloads\OneDrive\TEST\EXIF\AVI\VID\2016-10-29  19-39-06.mov
Folder name                              : E:\Downloads\OneDrive\TEST\EXIF\AVI\VID
File name extension                      : 2016-10-29  19-39-06.mov
File name                                : 2016-10-29  19-39-06
File extension                           : mov
Format                                   : MPEG-4
Format                                   : MPEG-4
Format/Extensions usually used           : braw mov mp4 m4v m4a m4b m4p m4r 3ga 3gpa 3gpp 3gp 3gpp2 3g2 k3g jpm jpx mqv ismv isma ismt f4a f4b f4v
Commercial name                          : MPEG-4
Format profile                           : QuickTime
Internet media type                      : video/mp4
Codec ID                                 : qt  
Codec ID                                 : qt   2011.07 (qt  )
Codec ID/Url                             : http://www.apple.com/quicktime/download/standalone.html
CodecID_Version                          : 2011.07
CodecID_Compatible                       : qt  
File size                                : 4530275
File size                                : 4.32 MiB
File size                                : 4 MiB
File size                                : 4.3 MiB
File size                                : 4.32 MiB
File size                                : 4.320 MiB
Duration                                 : 1502
Duration                                 : 1 s 502 ms
Duration                                 : 1 s 502 ms
Duration                                 : 1 s 502 ms
Duration                                 : 00:00:01.502
Duration                                 : 00:00:01;15
Duration                                 : 00:00:01.502 (00:00:01;15)
Overall bit rate mode                    : VBR
Overall bit rate mode                    : Variable
Overall bit rate                         : 24129294
Overall bit rate                         : 24.1 Mb/s
Frame rate                               : 29.970
Frame rate                               : 29.970 FPS
Frame count                              : 45
Stream size                              : 429536
Stream size                              : 419 KiB (9%)
Stream size                              : 419 KiB
Stream size                              : 419 KiB
Stream size                              : 419 KiB
Stream size                              : 419.5 KiB
Stream size                              : 419 KiB (9%)
Proportion of this stream                : 0.09481
HeaderSize                               : 425976
DataSize                                 : 4104299
FooterSize                               : 0
IsStreamable                             : Yes
Encoded date                             : UTC 2016-10-29 18:39:03
Tagged date                              : UTC 2016-10-29 18:39:03
File creation date                       : UTC 2023-01-06 07:51:47.587
File creation date (local)               : 2023-01-06 09:51:47.587
File last modification date              : UTC 2023-01-06 07:51:48.505
File last modification date (local)      : 2023-01-06 09:51:48.505
TAGS                                     : 8"R

Video
Count                                    : 378
Count of stream of this kind             : 1
Kind of stream                           : Video
Kind of stream                           : Video
Stream identifier                        : 0
StreamOrder                              : 0
ID                                       : 1
ID                                       : 1
Format                                   : AVC
Format                                   : AVC
Format/Info                              : Advanced Video Codec
Format/Url                               : http://developers.videolan.org/x264.html
Commercial name                          : AVC
Format profile                           : High@L4.1
Format settings                          : 1 Ref Frames
Format settings, CABAC                   : No
Format settings, CABAC                   : No
Format settings, Reference frames        : 1
Format settings, Reference frames        : 1 frame
Internet media type                      : video/H264
Codec ID                                 : avc1
Codec ID/Info                            : Advanced Video Coding
Duration                                 : 1502
Duration                                 : 1 s 502 ms
Duration                                 : 1 s 502 ms
Duration                                 : 1 s 502 ms
Duration                                 : 00:00:01.502
Duration                                 : 00:00:01;15
Duration                                 : 00:00:01.502 (00:00:01;15)
Bit rate mode                            : VBR
Bit rate mode                            : Variable
Bit rate                                 : 20480000
Bit rate                                 : 20.5 Mb/s
Width                                    : 1920
Width                                    : 1 920 pixels
Height                                   : 1080
Height                                   : 1 080 pixels
Stored_Height                            : 1088
Sampled_Width                            : 1920
Sampled_Height                           : 1080
Pixel aspect ratio                       : 1.000
Display aspect ratio                     : 1.778
Display aspect ratio                     : 16:9
Rotation                                 : 0.000
Frame rate mode                          : CFR
Frame rate mode                          : Constant
Frame rate                               : 29.970
Frame rate                               : 29.970 (30000/1001) FPS
FrameRate_Num                            : 30000
FrameRate_Den                            : 1001
Frame count                              : 45
Color space                              : YUV
Chroma subsampling                       : 4:2:0
Chroma subsampling                       : 4:2:0
Bit depth                                : 8
Bit depth                                : 8 bits
Scan type                                : Progressive
Scan type                                : Progressive
Bits/(Pixel*Frame)                       : 0.330
Stream size                              : 3812451
Stream size                              : 3.64 MiB (84%)
Stream size                              : 4 MiB
Stream size                              : 3.6 MiB
Stream size                              : 3.64 MiB
Stream size                              : 3.636 MiB
Stream size                              : 3.64 MiB (84%)
Proportion of this stream                : 0.84155
Language                                 : ja
Language                                 : Japanese
Language                                 : Japanese
Language                                 : ja
Language                                 : jpn
Language                                 : ja
Encoded date                             : UTC 2016-10-29 18:39:03
Tagged date                              : UTC 2016-10-29 18:39:03
Buffer size                              : 20480000 / 20480000
colour_description_present               : Yes
colour_description_present_Source        : Stream
Color range                              : Full
colour_range_Source                      : Stream
Color primaries                          : BT.601 NTSC
colour_primaries_Source                  : Stream
Transfer characteristics                 : BT.601
transfer_characteristics_Source          : Stream
Matrix coefficients                      : BT.601
matrix_coefficients_Source               : Stream
Codec configuration box                  : avcC

Audio
Count                                    : 280
Count of stream of this kind             : 1
Kind of stream                           : Audio
Kind of stream                           : Audio
Stream identifier                        : 0
StreamOrder                              : 1
ID                                       : 2
ID                                       : 2
Format                                   : PCM
Format                                   : PCM
Commercial name                          : PCM
Format settings                          : Little / Signed
Format settings, Endianness              : Little
Format settings, Sign                    : Signed
Codec ID                                 : sowt
Codec ID/Url                             : http://www.apple.com/quicktime/download/standalone.html
Duration                                 : 1502
Duration                                 : 1 s 502 ms
Duration                                 : 1 s 502 ms
Duration                                 : 1 s 502 ms
Duration                                 : 00:00:01.502
Duration                                 : 00:00:01.502
Source duration                          : 1520
Source duration                          : 1 s 520 ms
Source duration                          : 1 s 520 ms
Source duration                          : 1 s 520 ms
Source duration                          : 00:00:01.520
Bit rate mode                            : CBR
Bit rate mode                            : Constant
Bit rate                                 : 1536000
Bit rate                                 : 1 536 kb/s
Channel(s)                               : 2
Channel(s)                               : 2 channels
Channel positions                        : Front: L R
Channel layout                           : L R
Sampling rate                            : 48000
Sampling rate                            : 48.0 kHz
Samples count                            : 72096
Bit depth                                : 16
Bit depth                                : 16 bits
Stream size                              : 288288
Stream size                              : 282 KiB (6%)
Stream size                              : 282 KiB
Stream size                              : 282 KiB
Stream size                              : 282 KiB
Stream size                              : 281.5 KiB
Stream size                              : 282 KiB (6%)
Proportion of this stream                : 0.06364
Source stream size                       : 291840
Source stream size                       : 285 KiB (6%)
Source stream size                       : 285 KiB
Source stream size                       : 285 KiB
Source stream size                       : 285 KiB
Source stream size                       : 285.0 KiB
Source stream size                       : 285 KiB (6%)
Source_StreamSize_Proportion             : 0.06442
Language                                 : ja
Language                                 : Japanese
Language                                 : Japanese
Language                                 : ja
Language                                 : jpn
Language                                 : ja
Encoded date                             : UTC 2016-10-29 18:39:03
Tagged date                              : UTC 2016-10-29 18:39:03

Report created by                        : MediaInfoLib - v21.03

• NB

We can see a certain relative time shift comparing date/time reflected in the current filename to the ones from tags that is dependent on the time settings in the camera (at the time of recording), PC (upon the data access time), regarding local time vs UTC and DST values.

[BullFrog]

Create date works with wrong timezone (I guess but not sure)
In this picture this video was taken 6:30 but create date gives 5:30:
Image: https://i.imgur.com/pexmDfr.png

TCMediainfo gives a proper value for Encoded Date, I won't find a proper AIO solution

[Dalai]

Thank you, added but it still gives blank

For me this works with your AVI video. However, as Fla$her already pointed out, the lines need to be in the correct XML tags (like the ones in your screenshot showing the XML's differences) and the plugin needs to be reloaded after making changes to TCMediaInfo.xml. To do that, either restart TC or use the cm_UnloadPlugins command (on a button or in TC's command line).

Regards
Dalai

[beb]

Create date works with wrong timezone (I guess but not sure)
In this picture this video was taken 6:30 but create date gives 5:30...

One-hour time shift is a typical result of DST recognition.
For instance, my 2015 Olympus camera didn't have a setting to automatically switch on/off the daylight summer time.
So whenever I forgot to timely switch it manually, all the pictures/videos that fell into that period would have gained a time shift of EXIF date/time compared to the PC system date/time (which is local date/time regarding time zone and DST, if the latter is applicable).