Participant

Question

Importing exif data to Bridge issue

Forum|Forum|7 years ago
December 15, 2018
2 replies
1673 views

Hi y'all,

This question stems from my finding that when I take burst photos on my GH5 I create an Mp4. Unfortunately, the exif data isn't displayed in the metadata view for MP4's. I'm primarily interested in fnumber, ISO, white balance, and color profile (V-Log, Standard, Portrait etc.). I would actually like to keep using burst and would like to view exif data for photos I already have taken.

I was able to download and install Phil Harvey's ExifTool, and also successfully installed and used pyExifToolGUI to obtain the embedded exif data. Now I have this output csv that looks like it has everything I want. However, even after combing through these forums I'm having a hard time figuring out the best way to import these values.

I installed the VRA Core Metadata Script in an attempt to import metadata, but I can't see a field that reflects the aforementioned fstop/fnumber, ISO, white balance, and color profile values. Is there any way I can use the spreadsheet above to import values so they are reflected on my Bridge metadata quickview display? I'm thinking I might fundamentally misunderstand something here. I'm new to this, so thank you in advance for the hand holding.

Running on Mac OS.

This topic has been closed for replies.

Stephen Marsh

Community Expert

ExifTool offers the ability to copy tags directly from one image to another, so it may be possible to copy the required tags from a .jpg or .rw2 image to a batch of .mp4 images, bypassing the whole export/import process...

Example 1: Copy all tags from raw source image to destination jpeg image –

exiftool -tagsFromFile 'path/to file/source.rw2' 'path/to file/destination.jpg'

Example 2: Copy only the ISO tag from raw source image to destination jpeg image –

exiftool -tagsFromFile 'path/to file/source.rw2' -ExifIFD:ISO 'path/to file/destination.jpg'

Stephen Marsh

Community Expert

Metadata support for video files can be limited.

A hint on the VRA tool:

Re: Can you import metadata from an excel database to images (JPG, PSD, TIF) in bulk?

You first have to export to have the correct format for importing… The same concept applies to ExifTool, detailed here for exporting:

Re: Need a script to update keywords for 20000 images in Bridge

And here for importing:

Re: Need a script to update keywords for 20000 images in Bridge

adolby_surroundsoundAuthor

Participant

Hi Stephen,

Thank you so much for such a prompt response! Pretty amazing to me I can get such expertise so quickly.

It looks like I neglected to mention that I did export from VRA Core Metadata Script beforehand. It didn't (and on this second attempt still doesn't) provide the fields and values that I want/expect. I'm experiencing issues with the exiftool in Terminal, in the pyexiftoolGUI I mentioned, and using the VRA Core Metadata Script.

Using exiftool I inputted the below information to Terminal:

Nameredacted-Mac:~ usernameredacted$ exiftool -csv -r -subject /Users/usernameredacted/Desktop/test > /Users/usernameredacted/Desktop/test/meta_out.csv

1 directories scanned

1 image files read

Nameredacted-Mac:~ usernameredacted$

I received the resulting file in tab three of this Google sheet. Obviously I'm missing something, as it's only exporting the source file. So I'm not clear on how to progress to Part B. I used the below file, so I know it has the exif information I'm after.

I also exported the VRA Core Metadata with both custom and default fields. Results are in tab 2 of the previously linked Google sheet. However, in the case of the exiftool terminal approach and the VRA Core Metadata export I'm not seeing the fields that I'm looking for. Again, these are fnumber, shutter speed, ISO, and ideally profile (e.g. Natural, V-Log, Cine-D). I'm considering if this is due to not understanding the spec for this output format. However, since there are fstop, ISO, and other values in the file I used, I imagine I would recognize them in the exported file.

Tab 1 of the previously linked Google sheet is the export from pyexiftoolGUI, and it seems to give me everything I want (except profile). However I can't figure out how to either import the resulting file so these metadata fields are viewable in Bridge for MP4's, nor can I map to a VRA Core Metadata template.

Hopefully it's clear to you what I'm doing wrong here. Thanks in advance for your direction.

Stephen Marsh

Community Expert

To begin, the ExifTool command line example that you used was only exporting subject/keyword metadata, simply remove the -subject shorthand metadata tag argument in red:

Nameredacted-Mac:~ usernameredacted$ exiftool -csv -r -subject '/Users/usernameredacted/Desktop/test' > '/Users/usernameredacted/Desktop/test/meta_out.csv'

This will list “all known metadata” in the output file…

That being said, I personally would use a slightly different command to ensure that you have exactly what you need for the import. Note the addition of the three arguments in black, I would hold off on adding the -u or -unknown argument unless it was really required:

Nameredacted-Mac:~ usernameredacted$ exiftool -a -G1 -s -csv -r '/Users/usernameredacted/Desktop/test' > '/Users/usernameredacted/Desktop/test/meta_out.csv'

Also note that I am wrapping the input and output path names in straight single quotes for good form (NOTE: Win OS uses straight double quotes).

_________

To import the modifed CSV data:

exiftool -sep ',' -r -csv='/Users/usernameredacted/Desktop/test/meta_out.csv' '/Users/usernameredacted/Desktop/test' -r

P.S. I don’t have time to test, so I don’t know why I originally used two separate -r recursive commands, not sure if this was user error or if there was actually a good reason, it can’t hurt to double up, or you could test removing one or the other to see if it makes a difference.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded