Search found 6 matches

by Glorious1
Tue Sep 24, 2024 2:36 pm
Forum: MP - General Support
Topic: import data from excel/csv file into IPTC/XMP caption fields
Replies: 9
Views: 1946

Re: import data from excel/csv file into IPTC/XMP caption fields

On the exiftool forum I discovered the error of my ways. I thought that the SourceFile column in the csv tells exiftool what files to process and where they are. No - you need to tell exiftool on the commandline where to look for source files, then it checks it against the SourceFile list. Not very ...
by Glorious1
Fri Sep 20, 2024 1:44 pm
Forum: MP - General Support
Topic: import data from excel/csv file into IPTC/XMP caption fields
Replies: 9
Views: 1946

Re: import data from excel/csv file into IPTC/XMP caption fields


csv file without quotes :

SourceFile,IPTC:Caption-Abstract,IPTC:Keywords,XMP-dc:Description,XMP-dc:Subject
/Users/jim/Documents/family_history/slides/Slide 01.jpg,My caption,1960-1965,My caption,1960-1965


Thank you. A problem with that is that many of the actual captions contain commas, so ...
by Glorious1
Wed Sep 18, 2024 9:21 pm
Forum: MP - General Support
Topic: import data from excel/csv file into IPTC/XMP caption fields
Replies: 9
Views: 1946

Re: import data from excel/csv file into IPTC/XMP caption fields

Thank you Michel. Yes, I have only one Category per photo. I can't get it to work.

In Terminal, I cd into the directory that contains my csv ("exiftool.csv") and the destination directory ("exifslides/").

The csv looks like this:
SourceFile,IPTC:Caption-Abstract,IPTC:Keywords,XMP-dc:Description ...
by Glorious1
Mon Sep 16, 2024 10:14 pm
Forum: MP - General Support
Topic: import data from excel/csv file into IPTC/XMP caption fields
Replies: 9
Views: 1946

Re: import data from excel/csv file into IPTC/XMP caption fields

Thank you very much for that helpful reply, Michel. May I ask two followup questions?

1. I don't really have Headlines/titles. The second bit of metadata I would like to add is actually Categories, which I think in IPTC are called Keywords? What would the appropriate column heading be for that in ...
by Glorious1
Sun Sep 15, 2024 8:53 pm
Forum: MP - General Support
Topic: import data from excel/csv file into IPTC/XMP caption fields
Replies: 9
Views: 1946

import data from excel/csv file into IPTC/XMP caption fields

I have 100 JPG images and an Excel file with detailed caption/description information for each. I'm hoping to automate pasting of the metadata into the image files.

I've read some posts talking about using exiftool for automatic metadata manipulations, but none that covered this goal. I managed to ...
by Glorious1
Tue May 10, 2022 4:01 pm
Forum: New
Topic: Filename placeholders incorrect output in Batch Convert
Replies: 1
Views: 748

Filename placeholders incorrect output in Batch Convert

Using Batch Convert, outputting a WEBP file, I'm trying to get the filename to have the OUTPUT width x height.

Using this: {Filename}_{DstWidth}x{DstHeight}_{Width}x{Height}
both sets of placeholders give the same dimensions, the dimensions of the ORIGINAL file. Neither has the dimensions of the ...