Help importing data from a CSV to JPG images.

[webuxer]

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.

[wywh]

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

[StarGeek]

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.

Are you checking with exiftool or some other program.

Your command works correctly here, but you are mixing XMP tags with IPTC tags.

Code Select Expand

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