Author Topic: From Docx table to meta in image?  (Read 875 times)

roganett

  • Newbie
  • *
  • Posts: 1
From Docx table to meta in image?
« on: March 19, 2018, 02:43:24 PM »
I recieved a gallery from a client with 16.000 pictures. And he has *docx file(s) with a table inside that he grabbed the meta from before. (Not sure how)
The table contains 3 coloums. First is a number that refers to the filename from pictures (exept jpg extension)- second is the title, and third is the description.

He had this on a webpage before as a gallery, and the webpage grabbed the meta from these *docx documents. (Not sure how)

I now want to make a new gallery for him in wordpress or similar. Is there a way I can do that, or a way exiftools can help me write this meta directly to the images?

Not so great at commandline so I might need detailed instructions.

Thanks in advance

Attached screenshot of the table

Phil Harvey

  • ExifTool Author
  • Administrator
  • ExifTool Freak
  • *****
  • Posts: 17499
    • ExifTool Home Page
Re: From Docx table to meta in image?
« Reply #1 on: March 19, 2018, 05:47:51 PM »
I don't know if ExifTool will be able to do what you want, but I can tell you more if you post a small docx file with an example of what you want to extract.

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

StarGeek

  • Global Moderator
  • ExifTool Freak
  • *****
  • Posts: 4456
Re: From Docx table to meta in image?
« Reply #2 on: March 19, 2018, 07:22:12 PM »
It might be easier to copy / paste the table to the spreadsheet and then save that as a CSV file.  Then, possibly with some modifications, exiftool could then be used to read the CSV file.
Troubleshooting hints:
* When posting, include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).
* Double all percent signs (%) in a Windows batch file.
* If your GPS coords are negative, make sure and set the GpsLatitudeRef and GpsLongitudeRef tags correctly.

Phil Harvey

  • ExifTool Author
  • Administrator
  • ExifTool Freak
  • *****
  • Posts: 17499
    • ExifTool Home Page
Re: From Docx table to meta in image?
« Reply #3 on: March 19, 2018, 08:21:01 PM »
Good point.  This would be much easier if there is only a single docx file.  I was heading off in the wrong direction.

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).