Windows Metadata Comments to Adobe Lightroom Sync

exif_comment_to_lightroom.py

#!/usr/bin/env python2
#
# exif_comment_to_lightroom.py
# 
# Windows Metadata Comments => Adobe Lightroom Sync
# 
# This script will decode and copy the comment field from the Windows metadata details
# (when you right-click on an image and go to details in Windows Explorer) into the 
# Adobe Lightroom compatible IPTC XMP caption field.  After running, select all affected
# images and select Metadata -> Read Metadata from File.
# 
# Note that although this worked fine for me, your milage may vary.  Also, this may overwrite
# your Lightroom metadata, although it is supposed to only alter the caption field.
# 
# To use this script, first install Python 2.x, then run:
#   pip install piexif
#   pip install IPTCInfo
# 
# Then update the images_dir and run this script.  All files that can be read will be updated.
#
# Author: Steve Kamerman, 2016
# 

from os import listdir
from os.path import isfile, join
from iptcinfo import IPTCInfo
import piexif

images_dir = "c:/Users/My User/Pictures"
filenames = [f for f in listdir(images_dir) if isfile(join(images_dir, f))]

for filename in filenames:
    image_path = join(images_dir, filename)

    try:
        exif = piexif.load(image_path)
    except:
        print "Unable to open %s" % filename
        continue

    if piexif.ImageIFD.XPComment not in exif["0th"]:
        #print "Error: No comment"
        continue

    comment_bytes = exif["0th"][piexif.ImageIFD.XPComment]
    comment_bytes = [a for a in comment_bytes if a != 0]
    comment = "".join(map(chr, comment_bytes))

    try:
        iptc = IPTCInfo(image_path, force=True)
    except:
        print "Error initializing IPTC data"
        continue;

    if comment != iptc.data['caption/abstract']:
        print "=> Updating file '%s' with comment: \n%s" % (filename, comment)
        iptc.data['caption/abstract'] = comment
        iptc.save()