Some XMP-iptcExt fields not importing

Started by famhist, May 11, 2022, 05:53:46 PM

Previous topic - Next topic

famhist

Hi --

I'm getting a decent handle on exiftool, but am running into some issues importing data from a CSV to a series of photos. The following is the header of my CSV file:

SourceFile   MasterDocumentID   Headline   DateCreated   Sub-location   PersonInImage      ArtworkPhysicalDescription      ArtworkSource            ArtworkCircaDateCreated   Caption-Abstract   ArtworkContentDescription

When I run the following on the command line:

exiftool -csvDelim "\t" -sep "," -csv=photos.tsv -G1 -v2 -o ./outputdir2 .

It imports most of the data, but skips the following IPTC-Extensions: ArtworkPhysicalDescription, ArtworkSource, ArtworkCircaDateCreated, Caption-Abstract, ArtworkContentDescription

Interestingly, it imports PersonInImage just fine.

I've spent the last couple hours searching for what I might be missing, but fear I'm making a pretty rookie mistake somewhere along the line.

StarGeek

You have the -v2 option on that command.  Did you look closely at the output to see if something was showing up there?

I don't have any problems here
C:\Programs\My_Stuff>type temp.txt
SourceFile MasterDocumentID Headline DateCreated Sub-location PersonInImage ArtworkPhysicalDescription ArtworkSource ArtworkCircaDateCreated Caption-Abstract ArtworkContentDescription
y:\!temp\Test4.jpg MDID Headline 2022:05:11 12:00:00 SubLoc PinIm ArtPhyDesc ArtSour ArtCirca CapAb ArtContDesc

C:\Programs\My_Stuff>exiftool -csvDelim "\t" -sep "," -csv=temp.txt -v2 -o Y:\!temp\ccc\  y:\!temp\Test4.jpg
Reading CSV file temp.txt
Imported entry for 'y:/!temp/Test4.jpg' (full path: 'y:/!temp/test4.jpg')
======== y:/!temp/Test4.jpg
Setting new values from CSV database
Writing XMP-iptcExt:ArtworkCircaDateCreated
Writing XMP-iptcExt:ArtworkContentDescription
Writing XMP-iptcExt:ArtworkPhysicalDescription
Writing XMP-iptcExt:ArtworkSource
Writing IPTC:Caption-Abstract
Writing XMP-photoshop:DateCreated if tag exists
Writing IPTC:DateCreated
Writing XMP-iptcExt:Headline if tag exists
Writing XMP-photoshop:Headline if tag exists
Writing IPTC:Headline
Writing IPTC:MasterDocumentID
Writing XMP-iptcExt:PersonInImage
Writing IPTC:Sub-location
'y:/!temp/Test4.jpg' --> 'Y:/!temp/ccc/Test4.jpg'
Rewriting y:/!temp/Test4.jpg...
  Editing tags in: APP1 APP13 IPTC Photoshop XMP
  Creating tags in: APP1 APP13 IPTC Photoshop XMP
Creating APP13:
  Creating Photoshop
  Creating IPTC
    + IPTC:DateCreated = '20220511'
    + IPTC:Sub-location = 'SubLoc'
    + IPTC:Headline = 'Headline'
    + IPTC:Caption-Abstract = 'CapAb'
    + IPTC:MasterDocumentID = 'MDID'
    + IPTC:ApplicationRecordVersion = '4' (mandatory)
Creating APP1:
  Creating XMP
    + XMP-iptcExt:ArtworkCircaDateCreated = 'ArtCirca'
    + XMP-iptcExt:ArtworkContentDescription = 'ArtContDesc'
    + XMP-iptcExt:ArtworkPhysicalDescription = 'ArtPhyDesc'
    + XMP-iptcExt:ArtworkSource = 'ArtSour'
    + XMP-iptcExt:PersonInImage = 'PinIm'
JPEG DQT (65 bytes):
JPEG DQT (65 bytes):
JPEG SOF0:
JPEG DHT (28 bytes):
JPEG DHT (90 bytes):
JPEG DHT (26 bytes):
JPEG DHT (65 bytes):
JPEG SOS
    1 image files created

C:\Programs\My_Stuff>exiftool -G1 -a -s -e --file:all Y:\!temp\ccc\Test4.jpg
[ExifTool]      ExifToolVersion                 : 12.41
[IPTC]          DateCreated                     : 2022:05:11
[IPTC]          Sub-location                    : SubLoc
[IPTC]          Headline                        : Headline
[IPTC]          Caption-Abstract                : CapAb
[IPTC]          MasterDocumentID                : MDID
[IPTC]          ApplicationRecordVersion        : 4
[XMP-x]         XMPToolkit                      : Image::ExifTool 12.41
[XMP-iptcExt]   ArtworkCircaDateCreated         : ArtCirca
[XMP-iptcExt]   ArtworkContentDescription       : ArtContDesc
[XMP-iptcExt]   ArtworkPhysicalDescription      : ArtPhyDesc
[XMP-iptcExt]   ArtworkSource                   : ArtSour
[XMP-iptcExt]   PersonInImage                   : PinIm[/cdoe]
* 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).

famhist

#2
(edited to add: I think I may have found the problem... it seems the CSV export may not be correct and dropping some extra tabs in... going to clean up the data and confirm)

Ah, yes, should have shared that info. Here's the one of two test images' response (and there was an entry in the CSV for every field, but you'll see those I initially noted didn't come over.):

./0546.tif
Setting new values from CSV database
Writing XMP-photoshop:DateCreated if tag exists
Writing IPTC:DateCreated
Writing XMP-iptcExt:Headline if tag exists
Writing XMP-photoshop:Headline if tag exists
Writing IPTC:Headline
Writing IPTC:MasterDocumentID
Writing XMP-iptcExt:PersonInImage
Writing IPTC:Sub-location
'./0546.tif' --> './outputdir2/0546.tif'
Rewriting ./0546.tif...
  Editing tags in: IFD0 IPTC TIFF XMP
  Creating tags in: IFD0 IPTC TIFF XMP
  FileType = TIFF
  FileTypeExtension = TIF
  MIMEType = image/tiff
  Rewriting IFD0
  Rewriting XMP
    - XMP-iptcExt:PersonInImage = '41'
    - XMP-iptcExt:PersonInImage = '42'
    + XMP-iptcExt:PersonInImage = '41'
    + XMP-iptcExt:PersonInImage = '42'
    + XMP-iptcExt:PersonInImage = '45'
    + XMP-iptcExt:PersonInImage = '46'
    + XMP-iptcExt:PersonInImage = '48'
    + XMP-iptcExt:PersonInImage = '47'
  Rewriting IPTC
    - IPTC:DateCreated = '19060000'
    + IPTC:DateCreated = '19060000'
    - IPTC:Headline = 'Approximately 1906'
    + IPTC:Headline = 'Approximately 1906'
    - IPTC:MasterDocumentID = '0546'
    + IPTC:MasterDocumentID = '0546'
    + IPTC:Sub-location = 'Kaunas, Lithuania'
  Rewriting ICC_Profile
  Copying 7818 image data blocks

StarGeek

That output shows it's not finding the missing tag names in the column headers or something like that.  In my output you see
Writing XMP-iptcExt:ArtworkCircaDateCreated
Writing XMP-iptcExt:ArtworkContentDescription
Writing XMP-iptcExt:ArtworkPhysicalDescription
Writing XMP-iptcExt:ArtworkSource


which doesn't appear in your -v2 output.

Without having access to the files, all I can suggest is make sure your CSV file actually has tabs and the column headers are spelled correctly.  Though testing both of those should throw an error. 

Also, what version of exiftool
exiftool -ver

Are you able to directly set those tags on the command line?
* 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).

famhist

So, I did confirm that the CSV (well, tsv) had syntax errors... I had hidden columns in the original spreadsheet and that threw things off (combined with some manual tweaking of the file afterwards).

Sorry about that - I really did think I'd ruled out data issues yesterday, but the light of a new day proved me wrong. Thanks for the prompt response, StarGeek! I've confirmed all is working well now.

StarGeek

* 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).