How to extract labelled raw images in a CSV?

Started by Marie, December 11, 2019, 10:23:35 AM

Previous topic - Next topic

Marie

I try to extract all labelled images in a CSV file, but I have a problem to list RAW images. Instead of extracting CR2 raw files themselves in the CSV file, I only have the XMP sidecar files in my list (with all non-raw image files listed such as jpg etc).
Does anyone have an idea of how I can extract all labelled RAW images with ExifTool (and not just the XMP sidecar) without converting them in DNG format?

Phil Harvey

If you show me the command you are using I can show you how to modify it to use the sidecar files.

- 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 ($).

Marie

Sure. The command is:

exiftool -if "$XMP:Label eq 'Sélectionner'" -csv -r -L -charset FileName=LATIN -G -File:Filename -XMP:Label -EXIF:CreateDate -XMP:Creator "Répertoire" >Nomdunouveaufichier.csv


Phil Harvey

Hi Marie,

Thanks for the reminder.  Somehow I dropped the ball on this.

The command you provided extract information from both RAW images and XMP sidecars.  Of course, the RAW images which have sidecar XMP files probably don't have embedded XMP themselves, so you will get the XMP files listed in the CSV output instead of the RAW files.  Is this the problem?  I don't see an easy work-around for this.

- 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 ($).