Extracting multiple fields to a txt file.

Started by I3ordo, May 30, 2022, 11:09:51 AM

Previous topic - Next topic

I3ordo

  Hi, I have previously asked various questions regarding writing metadata to images and we did what we wanted finally.
here is a sample of what the processed image looks like.
https://slack-files.com/TSS4RSSUA-F03HWRA543B-0b86cd7ee2

So this image has various fields like:
Title, authors, tags, copyright, camera maker, camera model have all the necessary info.

As time goes by, new ideas emerge and currently i am looking for ways to extract this data to a txt file.

So check the reference pages and saw this exiftool -htmldump -w tmp/%f_%e.html t/images - Generate HTML pages from a hex dump of EXIF information in all images from the C directory. The output HTML files are written to the C directory (which is created if it didn't exist), with names of the form "FILENAME_EXT.html"."

I am already familiar with W:\test\exiftool.exe "-subject+<${filename;s/\.[^.]*$//}" W:\test so the reference cmd line that ends with t/images is the path to directory of images?

how can i extract multiple fields to a single txt file i am wondering...


StarGeek

Moving thread as it is about an exiftool command, not a metadata discussion

There are examples for extract specific tags under Reading Examples in the docs.

Your basic command would be something like
exiftool -Title -Creator -Subject -Rights -Make -Model /path/to/files/ >Output.txt

Though you should check your files with the command in FAQ #3 to figure out the actual tags you want to list.

You might also look into the -csv option, which will create a CSV file you can load into a spreadsheet such as Excel or LibreOffice.

You almost certainly don't want the -htmlDump option as that shows detailed listing of the internals of the file, which looks like this.
* Did you read FAQ #3 and use the command listed there?
* Please use the Code button for exiftool code/output.
 
* Please include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).

I3ordo

Hi! your message was very helpful and i got me started and running:

had to modify exiftool -Title -Creator -Subject -Rights -Make -Model /path/to/files/ >Output.txt
into exiftool -Title -Artist -Subject -Make -Model W:\!!_3dskyTagged\!_OFM\ >W:\!!_3dskyTagged\!_OFM\Output.txt
as my jpg file field "Authors" required "-Artist" instead of "-Creator".

Still there is  one field missing and it was the "Comments" section.

so i ran the command that lists everything
exiftool -a -u -g1 "path to files >"path to files\Output.txt"
and saw that the comments info was listed in "XP Comment" but adding a "-XP Comment" does not seem to work....i also tried "-XP:Comment"
i actually tired all these -Title -XMP:Comment -comment -XP:Comment -XP Comment none of them yielded any results...

StarGeek

Quote from: I3ordo on June 01, 2022, 06:56:41 PM
so i ran the command that lists everything
exiftool -a -u -g1 "path to files >"path to files\Output.txt"
and saw that the comments info was listed in "XP Comment" but adding a "-XP Comment" does not seem to work....i also tried "-XP:Comment"
i actually tired all these -Title -XMP:Comment -comment -XP:Comment -XP Comment none of them yielded any results...

See FAQ #2 and FAQ #3.  You're looking at tag descriptions, not tag names (FAQ #2).  Use the command in FAQ #3 to see the actual tag names.
* Did you read FAQ #3 and use the command listed there?
* Please use the Code button for exiftool code/output.
 
* Please include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).