Posted on

PowerShell: Querying, Formatting and Exporting Tags on Picture Files

One of the many Sisyphean tasks my wife performs is keeping the all the metadata tags of our digital photographs up to date.  She meticulously keeps tabs on the tags she’s used but with the sheer number of photos, new photos being added and the children starting to take photos too it’s a pretty time-consuming task.

So;  what she needs is a list of all the tags used on each picture file (including ones missing with tags) in an easily sortable format.

Being the caring husband that I am I started spending some time solving that problem with PowerShell.

Of course, she might have been happier with me doing all the ironing for a week so she can focus fully on sorting the pictures out but this is a)  more efficient and b) a solution that she can re-use (teach a woman to (photograph) fish etc) and so is a better use of our time.

At least, that’s my excuse and I’m sticking to it. Continue reading “PowerShell: Querying, Formatting and Exporting Tags on Picture Files”

Posted on

PowerShell : Getting All File Metadata from a Folder

I noticed my wife going through some photos manually tracking which tags were used to classify different subjects so I wondered if I could write a little PowerShell that could return all the file metadata on a set of files (or the contents of a folder).  That would enable me to list out all the tags we’ve used on our photo collection, filter them and generally get an idea about the organisation.

After a quick Google I found a great script here from Microsoft but there were a few additional things I wanted it to do;

  • Return the information in a stream of objects so I can use the pipeline.
  • Accept input from the pipeline.
  • Use either a path to a file or a path to a folder;  if the latter is provided recurse through all the sub-directories.
  • Get more than 266 file properties.  In fact, assume we don’t know how many file properties are going to be listed on the file and get them all.

Updated script and explanation follows! Continue reading “PowerShell : Getting All File Metadata from a Folder”