Hello,
I need help from the experts. I have a csv formatted as follows;
Column 1 = Sourcefile - It has the full path of the images (jpg)
Column 2 = Title
Column 3 = Headline
Column 4 = SupplementalCategories
Column 5 = Description
Im running the following command:
exiftool -csv=C\sample-out.csv -ext jpg C:\users\username\desktop\testing-images\
The command results;
1 directories scanned
8 image files updated
Seems to be working but after checking the metadata the information description is missing from all the files. All the other information gets added to the images except the description. Any idea why is not importing the data from the column description to the images?
I've attached the CSV I'm using for testing purposes.
The .csv Description goes to XMP-dc:Description.
So maybe you should edit the .csv headline as IPTC:Caption-Abstract so it goes to IPTC instead XMP. I currently use both IPTC and the corresponding XMP.
- Matti
Quote from: webuxer on May 25, 2023, 12:18:30 PMSeems to be working but after checking the metadata the information description is missing from all the files. All the other information gets added to the images except the description.
Are you checking with exiftool or some other program.
Your command works correctly here, but you are mixing XMP tags with IPTC tags.
C:\>type Y:\!temp\aaaaa\sample-out.csv
SourceFile,Title,Headline,SupplementalCategories,Description
Y:\!temp\aaaaa\photo1.jpg,Photo 1,Vehicle,Red,Red Vehicle
Y:\!temp\aaaaa\photo2.jpg,Photo 2,Motorcicle,Black,Black Motorcicle
Y:\!temp\aaaaa\photo3.jpg,Photo 3,Vehicle,White,White Vehicle
Y:\!temp\aaaaa\photo4.jpg,Photo 4,Motorcicle,Black,Black Motorcicle
Y:\!temp\aaaaa\photo5.jpg,Photo 5,Vehicle,Blue,Blue Vehicle
Y:\!temp\aaaaa\photo6.jpg,Photo 6,Motorcicle,Silver,Silver Motorcicle
Y:\!temp\aaaaa\photo7.jpg,Photo 7,Vehicle,Blue,Blue Vehicle
Y:\!temp\aaaaa\photo8.jpg,Photo 8,Motorcicle,White,White Motorcicle
C:\>exiftool -P -overwrite_original -csv=Y:\!temp\aaaaa\sample-out.csv Y:\!temp\aaaaa\
1 directories scanned
8 image files updated
C:\>exiftool -G1 -a -s -ext jpg -Title -Headline -SupplementalCategories -Description Y:\!temp\aaaaa
======== Y:/!temp/aaaaa/photo1.jpg
[XMP-dc] Title : Photo 1
[IPTC] Headline : Vehicle
[IPTC] SupplementalCategories : Red
[XMP-dc] Description : Red Vehicle
======== Y:/!temp/aaaaa/photo2.jpg
[XMP-dc] Title : Photo 2
[IPTC] Headline : Motorcicle
[IPTC] SupplementalCategories : Black
[XMP-dc] Description : Black Motorcicle
======== Y:/!temp/aaaaa/photo3.jpg
[XMP-dc] Title : Photo 3
[IPTC] Headline : Vehicle
[IPTC] SupplementalCategories : White
[XMP-dc] Description : White Vehicle
======== Y:/!temp/aaaaa/photo4.jpg
[XMP-dc] Title : Photo 4
[IPTC] Headline : Motorcicle
[IPTC] SupplementalCategories : Black
[XMP-dc] Description : Black Motorcicle
======== Y:/!temp/aaaaa/photo5.jpg
[XMP-dc] Title : Photo 5
[IPTC] Headline : Vehicle
[IPTC] SupplementalCategories : Blue
[XMP-dc] Description : Blue Vehicle
======== Y:/!temp/aaaaa/photo6.jpg
[XMP-dc] Title : Photo 6
[IPTC] Headline : Motorcicle
[IPTC] SupplementalCategories : Silver
[XMP-dc] Description : Silver Motorcicle
======== Y:/!temp/aaaaa/photo7.jpg
[XMP-dc] Title : Photo 7
[IPTC] Headline : Vehicle
[IPTC] SupplementalCategories : Blue
[XMP-dc] Description : Blue Vehicle
======== Y:/!temp/aaaaa/photo8.jpg
[XMP-dc] Title : Photo 8
[IPTC] Headline : Motorcicle
[IPTC] SupplementalCategories : White
[XMP-dc] Description : White Motorcicle
1 directories scanned
8 image files read