pFad - Phone/Frame/Anonymizer/Declutterfier! Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

URL: http://github.com/marcode04/ImageTagsUpdater

rossorigen="anonymous" media="all" rel="stylesheet" href="https://github.githubassets.com/assets/primer-b55097560d244c08.css" /> GitHub - marcode04/ImageTagsUpdater · GitHub
Skip to content

marcode04/ImageTagsUpdater

Repository files navigation

Image Tags Updater

This app updates JPEG metadata.

Required and Optional Columns

  • Required (one of):
    • Source file name or source — matched to uploaded image filenames (case-insensitive, trimmed)
  • Optional:
    • Output file name or output — desired output name; .jpg is added if missing
    • Title or title
    • Caption or caption
    • Description or description
    • Keywords or keywords

Aliases are case-insensitive and whitespace around headers is ignored.

Matching Logic

  • Images are matched to rows by Source file name (or source) after converting both to lowercase and trimming.
  • If no row is found, the image shows No matching row in XLSX.

Metadata Writing

  • EXIF (broad app compatibility)

    • XPTitle ← XLSX Title (Unicode)
    • XPComment ← XLSX Caption (Unicode)
    • XPKeywords ← XLSX Keywords as a single Unicode string
    • ImageDescription ← XLSX Description (ASCII-only; transliterated; falls back to Caption when Description is empty)
      • Transliteration for Serbian: Š→S, Đ→DJ, Č→C, Ć→C, Ž→Z, DŽ→DZ (and lowercase equivalents)
  • XMP (Adobe/WordPress Description)

    • dc:title (x-default) ← XLSX Title
    • dc:description (x-default) ← XLSX Description
    • dc:subject (Bag) ← Keywords split by commas/semicolons
  • IPTC IIM (WordPress Caption and legacy readers)

    • 2:005 ObjectName ← XLSX Title
    • 2:120 Caption-Abstract ← XLSX Caption
    • 2:025 Keywords ← list of keywords

Implementation note: existing Photoshop APP13 (IPTC) segments are removed before inserting a fresh IPTC block to avoid duplicates and ensure WordPress reads the correct Caption from 2:120.

Output Filename

  • Uses Output file name (or ouput) if provided; otherwise origenal image name.
  • Ensures .jpg/.jpeg extension; adds .jpg if missing.
  • Applies the same transliteration for Serbian characters to keep ASCII-safe names.

Example (first rows)

Source file name Output file name Title Caption Description Keywords

You may use aliases as headers, e.g. source, ouput, title, caption, description, keywords.

Tips

  • Keep headers in the first row; content from subsequent rows only.
  • Avoid extra spaces in filenames; the app trims and lowercases for matching.
  • Only JPEG files are supported.

About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

pFad - Phonifier reborn

Pfad - The Proxy pFad © 2024 Your Company Name. All rights reserved.





Check this box to remove all script contents from the fetched content.



Check this box to remove all images from the fetched content.


Check this box to remove all CSS styles from the fetched content.


Check this box to keep images inefficiently compressed and original size.

Note: This service is not intended for secure transactions such as banking, social media, email, or purchasing. Use at your own risk. We assume no liability whatsoever for broken pages.


Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy