Accessing Windows Photo Gallery Metadata using Exiftool

With the demise of support to Windows Photo Gallery, it may be a good time to plan an app migration. I have seen various posts and comments on this, particularly after all the time and effort you may have spent tagging photos. The app which is meant to replace Windows Photo Gallery is the Windows Photos App. Unfortunately, the Windows Photos app does not support Captions, Descriptive Tags, People Tags nor GeoTags and to date I have not found any information which points that those features will be supported in the future.

So do not fret, as one of the pluses of using Windows Photo Gallery is that most of this information is stored into the image file and is accessible in Windows Explorer as well as any other apps which support photo metadata standards. Only in some instances this data is not stored to the file itself, such as “Flags” or if the image file in PNG or is set to “read-only”.

Understanding where the metadata is stored

Windows Photo Gallery stores much of this information as photo metadata using standards such as EXIF, IPTC IIM, and XMP (IPTC Core, IPTC Extension, Dublin Core and Microsoft Schemas) . I will not delve into the specifics of these standards but it is worth knowing to which fields the information is mapped to. In some occasions some information may be stored in multiple fields. For example, WPG captions information is stored in the XMP:Title, XMP:Description as well in other IPTC and EXIF fields.

The following table lists some of the photo information displayed in Windows Photo Gallery and the corresponding metadata fields from where the information is read and written to. I created this table from plain observation, if you find any other behavior let me know.

For reading and writing to these tags I highly recommend the excellent Exiftool command line utility. It may be daunting for some users to use the Windows Command line so I will try to be as specific as possible.Reading Windows Photo Gallery Metadata using Exiftool

Installing Exiftool

  1. (For Windows Users) Download the stand-alone Windows Executable from the Exiftool site.
  2. Unzip the exiftool(-k).exe and rename it exiftool.exe
  3. Copy the exiftool.exe to your c:\windows folder or to a folder contained in the PATH variable so it is accesible in any directory/folder.Detailed installation information can be found here.

Using Exiftool

  1. Open your command prompt in a folder containing photos either by running the Command Prompt shortcut in the Windows App Menu or by right mouse clicking on a folder while pressing the key  and selecting “Open Command Window here”.
  2. Confirm you have the current exiftool version by typing into the command prompt:exiftool -ver
  3. Pressing will return the version number.

Just typing the exiftool and the image file name will bring a host of information.

Exporting Windows Photo Gallery information to a File

This example will produce a file named “PhotoMeta.txt” which will contain a table with the filepath, filename, date and time photo was taken, camera maker, camera model, wpg caption, wpg descriptive tags, and wpg people tags contained in the current directory and its subdirectories.

Example:

exiftool -T -Directory -Filename -DateTimeOriginal -Make -Model  -xmp-dc:Title -xmp-dc:Description -xmp-dc:Subject -RegionPersonDisplayName -r *.jpg > PhotoMeta.txt

Using the “-T” option will output tab-delimited results. The “-r” option is used to include all the subdirectories contained within the specified “Pictures” directory. You can later open this table in Excel or import it to a database such a Microsoft Access for quick analysis.

Advertisements

3 thoughts on “Accessing Windows Photo Gallery Metadata using Exiftool

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s