Parsing tags from custom data

Post Reply
Username
Posts: 160
Joined: 18 Feb 18 22:21

Parsing tags from custom data

Post by Username » 25 Aug 19 20:23

I have an archive of film clips shot with my Blackmagic Micro Cinema.
Mostly clips in high bitrate Apple ProRes 422HQ codec.

PSu imports and manages these without problem but I'm not able to find a way to parse, tag and show information about the files regarding codecs, frame rate, bitrate, camera make etc in the "Custom Thumb Info"
Even though exiftool is able to extract it from the files.

Can these custom tag/fields be parsed and displayed in Thumb Info?
PSUServer 4 & Postgres 10 on macOS 10.13
- I'm the user

Hert
Posts: 15912
Joined: 13 Sep 03 7:24

Re: Parsing tags from custom data

Post by Hert » 26 Aug 19 9:03

If you have ExifTool installed then you can use the %exiftool macro command;

e.g.
%exiftool:YCbCrSubSampling

Tag names for ExifTool can be found on the ExifTool website;
https://sno.phy.queensu.ca/~phil/exiftool/TagNames/
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

Username
Posts: 160
Joined: 18 Feb 18 22:21

Re: Parsing tags from custom data

Post by Username » 28 Aug 19 5:47

Yes I do have the exiftool install on my Mac in /usr/local/bin
But I believe you meant %exif and not %exiftool, right?

Anyway, I'm unable to extract and display any of these data in PSu although exiftool can parse and export them when running it by itself.
I've tried exif, exifmakernote etc. and I can then extract and present ordinary data from my jpegs and raws but I'm unable to find a way of extracting these Blackmagic tags from within PSu.


ExifTool Version Number : 11.24
File Name : xx
Directory : /Users/
File Size : 135 MB
File Modification Date/Time : 2019:07:27 07:29:25+02:00
File Access Date/Time : 2019:07:29 23:35:18+02:00
File Inode Change Date/Time : 2019:07:28 14:16:09+02:00
File Permissions : rw-r--r--
File Type : MOV
File Type Extension : mov
MIME Type : video/quicktime
Movie Data Size : 141320176
Movie Data Offset : 16
Com Apple Proapps Manufacturer : Blackmagic Design
Com Apple Proapps Camera Name : CAM1
Com Apple Proapps Is Good : 0
Com Apple Proapps Customgamma : com.blackmagic-design.cinemacamera.filmlog
Com Blackmagic-design Cinemacamera Uuid: ****
Com Blackmagic-design White Balance Kelvin: 5200
Com Blackmagic-design Iso : 800
Com Blackmagic-design Shutter Angle: 17280
Com Blackmagic-design Shutter Mode: Rolling
Com Blackmagic-design Project FPS: 24
Com Blackmagic-design Camera Type: Blackmagic Micro Cinema Camera
Com Blackmagic-design Aperture : 8.7
Com Blackmagic-design Firmware : 4.7.1
Com Blackmagic-design Lens Focal Length: 14mm
Com Blackmagic-design Date Recorded: 20190727
Movie Header Version : 0
Create Date : 2019:07:27 05:29:25
Modify Date : 2019:07:27 05:29:25
Time Scale : 2400
Duration : 6.33 s
Preferred Rate : 1
Preferred Volume : 100.00%
Preview Time : 0 s
Preview Duration : 0 s
Poster Time : 0 s
Selection Time : 0 s
Selection Duration : 0 s
Current Time : 0 s
Next Track ID : 4
Track Header Version : 0
Track Create Date : 2019:07:27 05:29:25
Track Modify Date : 2019:07:27 05:29:25
Track ID : 3
Track Duration : 6.33 s
Track Layer : 0
Track Volume : 0.00%
Image Width : 1920
Image Height : 20
Gen Media Version : 0
Gen Flags : 0 0 0
Gen Graphics Mode : ditherCopy
Gen Op Color : 32768 32768 32768
Gen Balance : 0
Text Font : System
Text Face : Plain
Text Size : 12
Text Color : 0 0 0
Background Color : 65535 65535 65535
Font Name : Lucida Grande
Other Format : tmcd
Graphics Mode : ditherCopy
Op Color : 32768 32768 32768
Compressor ID : apch
Vendor ID : Apple
Source Image Width : 1920
Source Image Height : 1080
X Resolution : 72
Y Resolution : 72
Compressor Name : Apple ProRes 422 HQ
Bit Depth : 24
Video Frame Rate : 24
Matrix Structure : 1 0 0 0 1 0 0 0 1
Time Code : 3
Media Header Version : 0
Media Create Date : 2019:07:27 05:29:25
Media Modify Date : 2019:07:27 05:29:25
Media Time Scale : 48000
Media Duration : 6.37 s
Balance : 0
Handler Class : Data Handler
Handler Type : Alias Data
Handler Vendor ID : Apple
Handler Description : Apple Alias Data Handler
Audio Format : in24
Audio Channels : 2
Audio Bits Per Sample : 16
Audio Sample Rate : 48000
Purchase File Format : in24
Avg Bitrate : 179 Mbps
Image Size : 1920x20
Megapixels : 0.038
Rotation : 0
PSUServer 4 & Postgres 10 on macOS 10.13
- I'm the user

Hert
Posts: 15912
Joined: 13 Sep 03 7:24

Re: Parsing tags from custom data

Post by Hert » 28 Aug 19 7:07

I mean %exiftool:, not %exif:

Use the tag name as mentioned on the ExifTool website.
The sample I provided above should work for JPG files. If that works then you know ExifTool is found. Also check if you can use right click -> Run script from repository -> Metadata -> ExifTool Metadata Output
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

Hert
Posts: 15912
Joined: 13 Sep 03 7:24

Re: Parsing tags from custom data

Post by Hert » 28 Aug 19 11:53

I just tried it here on some MOV files and this gives me the bitrate;

%exiftool:AvgBitrate
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

Username
Posts: 160
Joined: 18 Feb 18 22:21

Re: Parsing tags from custom data

Post by Username » 28 Aug 19 15:54

When I from within PSu Run script from repository -> Metadata -> ExifTool Metadata Output
I get the same information as when I run the exiftool myself via the terminal.
This works.

But the custom thumbnail info using %exiftool
do not work and generate an error:

Executable not found: "exiftool"

Which paths does PSu look for when using the Thumbnail info as it do find the exiftool when running the script?
PSUServer 4 & Postgres 10 on macOS 10.13
- I'm the user

Hert
Posts: 15912
Joined: 13 Sep 03 7:24

Re: Parsing tags from custom data

Post by Hert » 28 Aug 19 23:41

On macOS, run this script in Tools -> Scripter to fix the file name for ExifTool:

Code: Select all

WriteToRegistry('', 'ExifToolFileName', '/usr/local/bin/exiftool');
Say('Done. Please restart Photo Supreme');
After running the script, restart PSU.
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

Username
Posts: 160
Joined: 18 Feb 18 22:21

Re: Parsing tags from custom data

Post by Username » 29 Aug 19 6:00

That worked out perfect.
Thank you a lot Hert. :)

Now I just need to dig around on how to extract the specific tags by name/id.
PSUServer 4 & Postgres 10 on macOS 10.13
- I'm the user

Hert
Posts: 15912
Joined: 13 Sep 03 7:24

Re: Parsing tags from custom data

Post by Hert » 29 Aug 19 7:08

That’s great.
Tip, in the ExifTool Output script you can switch to short names. The first column is then what you should use after %exiftool:
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

Username
Posts: 160
Joined: 18 Feb 18 22:21

Re: Parsing tags from custom data

Post by Username » 29 Aug 19 15:33

Cool. Thank you.
PSUServer 4 & Postgres 10 on macOS 10.13
- I'm the user

Post Reply