Hey,
I'm currently trying to improve my video editing workflow and was hoping to use ExifTool to do so, however I don't know enough about programming to make it work and trying to read up on the documentation & various forum posts dealing with similar issues as well as asking AI (yep, I'm that desperate) didn't help much either:
My goal is to write a program that renames all video files in a folder based on their "User Rating" value (that's what it's called in the Exiftool .txt file I usually create) in one go.
I'd like them all to be renamed to "[User Rating]R + "_" + [Original file name]" if the [User Rating] is > 0.
This would allow me to quickly find the videos which I rated as "good" (in camera) in my video editing program, by simply sorting them by name. (Sadly Davinci Resolve Studio does not recognise the metadata of my files itself, at least not most of its values.)
Regarding the files, those are .mp4 files shot with a Canon EOS R5 Mark II (or Canon EOS R7) and the "User Rating" is a value between "00" and "50" in steps of 10. (In camera, this just looks like 1 to 5 Stars).
I've attached a 1 second FHD25 h265 4:2:2 10-bit mp4 shot in clog2 cinemagamut as an example, it has a User Rating of 40 equal to 4 Stars.
Does anyone have a suggestion on how I could solve this problem?
I know .batch files are often used for such tasks, but despite trying for a few hours over the last two weekends, I can't seem to make it work.
Best,
Klex
Try this:
exiftool -if '$userrating > 00' '-filename<${userrating}R_$filename' A_0014C750H250220_132137FE_AKLEE.MP4
it should rename your sample to: "40R_A_0014C750H250220_132137FE_AKLEE.MP4"
you can use this format to test the results without making changes:
exiftool -if '$userrating > 00' '-testname<${userrating}R_$filename' A_0014C750H250220_132137FE_AKLEE.MP4
Note that single quotes are for MacOS you might need to switch to double quotes on Windows.
If you'd rather change the rating to "4" rather than "40" then:
exiftool -if '$userrating > 0' '-filename<${userrating;s/(\d)0/$1/}R_$filename' A_0014C750H250220_132137FE_AKLEE.MP4
You can run it against multiple files once you are comfortable with the results.
{EDIT: Nvm, I found it out}
Works perfectly, thanks *so* much!!
Regarding running it against multiple files, i've read that Exiftool has batch processing capabilities which should be used directly instead of using an external scrips which runs (& stops) Exiftools for each file:
I've read in the documentation that there is a -r (recurse) function which I thought I could use for this - however it doesn't seem to do what I thought it does.
What would I need to do to run it against all files in a given directory/folder all at once (or rather sequentially I suppose)?
{EDIT: Nvm, I found out how to do it:
[Path to Exiftool.exe]\exiftool -if "$userrating > 0" "-filename<${userrating;s/(\d)0/$1/}R_$filename" [Path to folder / directory that is supposed to be scanned]
(For windows)}