Append Extracted EXIF (csv) to image dataset

Started by reubencash, March 21, 2022, 02:56:49 PM

Previous topic - Next topic

reubencash

Hello all,

Total newb here.  I have a series of UAS images that have been altered in Davinci Resolve that I would like to append original EXIF data to since the alteration stripped parameters like camera type, lat/long/etc.  There are three folders I'm working with, all in my C:/ drive - original images (MakahOG), altered images (Makah_Davinci), and a folder with the csv of original EXIF data (Makah_CSV).  Images are named in both datasets as "Makah (1)", "Makah (2)", and so on.  I've exported the original EXIF to csv, verified existence of and correct formatting for timedatecreate and sourcefile tags in the csv, and am attempting to append using the following code:

exiftool -csv="C:\Makah_CSV/makah.csv" "C:\Makah_Davinci"

This command returns this error for all items in the folder:

No SourceFile 'C:/Makah_Davinci/Makah (1).jpg' in imported CSV database

Any guidance on how to achieve my objective?  Thanks for your help!

Reuben


Phil Harvey

Hi Reuben,

The first column of the CSV file must be labeled "SourceFile" and must have the names of the files as formatted in the error messages you are seeing.

But if you can't figure it out, post the first couple of lines of the CSV file and we can help more.

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

reubencash

Hi Phil,

Ahah, I see my mistake, just replace the paths to the original imagery in the SourceFile column of the extracted CSV with the paths to the altered dataset needing EXIF data.  That worked like a charm, appreciate the guiding hand and the fantastic tool!

Reuben