Extract IPTC Field, such as Headline

Started by exwul, April 19, 2013, 04:47:39 AM

Previous topic - Next topic

exwul

Newbie question

ExifToolGUI: Right now all available information is extracted (export/import->extract metadata into..)
I don't think it is not possible to select just one (or more fields), like
IPTC->Headline IPTC->Caption-Abstract EXIF->Image Description EXIF->User Comment
and export those.

I still tried to accomplish this by:
- selecting a number of files
- following in the 'Exiftool Direct'box

exiftool -csv -headline > out.csv
but that ended with

File not found: exiftool
Error opening directory >
File not found: out.csv
    3 image files read
    2 files could not be read
<-END-

I added the paths to the commandline, like

F:\Exiftool\exiftool -csv -headline > F:\Temp\out.csv

same error.
On screen it displayed the headlines alright, but not written to .csv file.

What am doing wrong?
Or maybe, what I want isn't possible at all.

TIA
=


Phil Harvey

You can't redirect the console output with ">" in ExifToolGUI.  Instead, you can do something like -w+ F:\Temp\out.csv%0f (ExifTool 9.24 or later requried for the -w+).

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

exwul

Thanks!

It'll then be:

exiftool -csv -headline -w+ F:\Temp\out.csv%0f

??

running latest versions of both.

thanks again.
=

Phil Harvey

I believe that this should work when used in the ExifTool Direct feature of ExifToolGUI.

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

exwul

Many thanks indeed, I'll give it a try.

exwul

Regret, it did not work, one way or the other I keept on getting the same error.

On https://exiftool.org/examples.html I saw an example: "exiftool -r -w .txt -common pictures"
So I got this working : "exiftool -r .txt -headline canon -w+ F:\Temp\out.csv%0f"

Wonder whether it would be possible to extract the following
headline, exif, modified date (and,   if possible, filename)
data ";" separated, so I can import the data into an Excelsheet.

TIA
=



Phil Harvey

There are a few problems with your ExifTool direct arguments:

1) you don't need to specify "exiftool"

2) You should remove the ".txt".

3) What are you trying to do with "canon"?  Did you mean "-canon"?

- 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

There are a few problems with your ExifTool direct arguments:

1) you don't need to specify "exiftool"

2) You should remove the ".txt".

3) What are you trying to do with "canon"?  Did you mean "-canon"?

Also, exporting a CSV file from the GUI is problematic.  This is better done from the command line.

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

exwul

"Canon" is the rootfolder containining subfolders with the images.
The csv is correctly generated. That went fine, so I guess the commandline works fine.

Will try with
exiftool -r  -headline canon -w+ F:\Temp\out.txt%0f


Still I wonder whether it would be possible to extract the following
headline, exif, modified date (and,   if possible, filename)
data ";" separated, so I can import the data into an Excelsheet.

Phil Harvey

You can use the -p option to format the output like this if you want.  See FAQ number 12 for examples.

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

exwul

Many thanks sofar. Really donot want to sound 'harsh', nasty, whatever.
But am sorry to say, I give up. Have spent a lot of time in trying to figure this out. All in vain.
Don't get upset or so, it definitely is not your tool, but it's me being unable to combine
the right set of parameters. Forget it.

Anyway, thanks again.
=

exwul

still, cud not give up.. ;)

finally got the things I want  now:
from the command prompt

exiftool -f -r -p "$headline, $DateTimeDigitized, $Description" n:\photos\canon > out.csv

it is FAQ alright, I agree, but I initially overlooked the issue with double quotes that i have to use for windows.
:-[
=