Participant

Question

Import EXIF title, description from XML file?

Forum|Forum|8 years ago
March 19, 2018
4 replies
1123 views

A client have a huge gallery of 13.000 pics. He have all the description, title etc connected to a word docx XML file.

The table on the document has 3 coloums. Filename, Photgrapher, description.

Is there a way to import this to all of those images and write the meta as exif to the file? Or similar option?

This topic has been closed for replies.

R

RoganettAuthor

Participant

May I ask a noob question??
How would you put this?
The first row of the table is a header/title..

johnrellis

Legend

Which program is that from?

I'm guessing you should check Quote All Text Cells, but not knowing the particular program, I can't say for sure.

R

RoganettAuthor

Participant

Tried this solution with a few images. But it gave error hven the caption had " , " in the text. SO then I am back to start. Cant edit so many cells.

The thing is that these tables was delivering metadata to a web gallery before. But nobody knows how :-D

L

Lumigraphics

Legend

You can't use commas in a .csv file because comma delimits the fields. You may be able to use an Excel macro to change or escape the commas, not sure.

There are also Adobe Bridge and exiftool scripts to import metadata. i would look into doing it that way if LR won't work.

R

RoganettAuthor

Participant

Not sure if this helps. But here is a screenshot of the table in the *docx file. First coloumn is filenumber(name), second is Title, third is description.

The LR Transporter plugin might work. But the trial is only 10 pics in one operation, because some forum says you never get the license since it has not been developed for years. Even theyre twitter account is not updated for years. (But havent tried it yet)

johnrellis

Legend

You can select that table in Word, do copy, paste it into an Excel spreadsheet, then save the spreadsheet in CSV format.

dj_paige

Legend

Lightroom can read XMP files, but not XML files. So the task is to convert your XML to valid XMP files. Perhaps the freeware ExifTool can do this; if not, you could probably write a simple program in whatever programming language you know to convert the XML file into 13,000 XMP files.

johnrellis

Legend

Another approach is to to convert the document to CSV format and then import it into LR using the LR/Transporter plugin. I'm pretty sure you can convert to CSV using Excel, but there are likely many other tools out there that could do it.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded