Reading EXIF - Splitting output to multiple CSVs based on Make / Model

Started by Bloggz, April 13, 2018, 06:51:10 PM

Previous topic - Next topic

Bloggz

Firstly, would like to say, great bit of software! I got put onto ExifTool recently by a friend and I'm really impressed with it, thanks for writing it!

I'm happily reading tags and outputting them to CSV, but hoping to split the output based on Make/Model of device to create multiple CSVs as I go, e.g.

Output-Google-Pixel.csv
Output-Apple-iPhone-6.csv
Output-%Make%-%Model%.csv
Etc

I've been able to answer most queries using the extensive documentation thus far but got stuck with this one... I guess my question is, is it possible already or could it be possible in the future?

Phil Harvey

You're asking for a feature to use tag values in the -w argument.  Hmm.  Interesting.

This would in theory be possible.  Let me think about it.

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


Phil Harvey

I've looked into this.  It won't be a feature that will be added soon because it will be a fair bit of work, especially if you want it to work with the -csv option.  The -W option is starting down this road (it supports tag names, but not values, in the output file names), but even this option doesn't yet support -csv

There are other complications too, not the least of which is trying to come up with a command-line syntax that allows this without breaking backward compatibility for older commands.

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

StarGeek

In the meantime, you might look into CSVKit.  It's complex and requires python, but I think CSVGrep might do what you want by splitting up a exiftool CSV dump.
"It didn't work" isn't helpful. What was the exact command used and the output.
Read FAQ #3 and use that cmd
Please use the Code button for exiftool output

Please include your OS/Exiftool version/filetype

Bloggz

I imagined it would be fairly complex, thanks for looking it though.

I'd wondered if there was an argument similar to -@ to supply a config or format file to specify CSV options...

But not to worry, I can split the files manually for now and if I get time I'll botch together a script to separate them out as a post process ;)

Thanks for your time guys!