Exporting Metadata from Picture Files to csv file


  1. briancy
    Posts : 1
    Windows 10
       New #1

    Exporting Metadata from Picture Files to csv file


    I am working to catalogue almost 20K images in my collection, and I've built a database that will store elements like image size, ISO, fstop, filename, focal length, etc. Instead of going to each image and right clicking to launch the properties dialog box, I'd like to leverage a tool (or the cmd prompt) to identify the fields I'd like to capture, and then in bulk, extract and export those to a comma separated values file so I can work with the data in Excel before processing the import to my database. Anyone have any ideas? I've downloaded tools such as Exiftool but none of the free ware seems to work as it has all constantly timed out on me thus far. I am currently running Windows 10 Home edition, version 21H1.
    Thanks!
      My Computer
    Quote Quote

  3. KeithM
    Posts : 989
    Microsoft Windows 10 Home
       New #2

    This could be accomplished with PowerShell utilizing the Shell.Application COM object.

    About to go to bed, so this is pretty much a "placeholder", but I will edit and expound.

    There are two methods available that can retrieve metadata from files:


    GetDetailsOf is simpler, the integer values for the columns (properties) can be obtained from self-contained code. The primary drawback is that all properties are returned as strings, so conversion to integers, dates. etc. must be coded by you.

    ExtendedProperty is slightly more complex. Though it can access some propeties by name, many can only be retrieved if the FMTID/PID pair that identifies the property is known, so you need a "dictionary" associating property names with their associated FMTID/PID pair. The advantage of this method is that properties are returned in the type appropriate for the data.

    ...to be continued...
      My Computer
    Quote Quote

  4. JD4x4
    Posts : 1
    Win10
       New #3

    KeithM said:
    ...to be continued...
    Any progress on examples?
    I'm new to using PowerShell so I need a good bit of hand-holding.
    I simply can't believe that it's this difficult to print a list or table of Win file property details since it's so easy to <see> them in File Explorer!
      My Computer
    Quote Quote

 

  Related Discussions
When viewing by details, you can choose to add various columns of metadata to the folder to sort files by, such as album or genre. How do you edit any of this data, for any file type? Right now my TV shows are sorted by season on my PC, but in...
I tried every possible way to solve the problem you can see here: 252537 I reset icon and thumbnail cache, I reset file associations, I reset photos but the problem is still there. The thing is when you are in icon view they normally show the...
I'm in the process of trying to organise and categorise my media files using file properties/metadata. When I go to the properties of, for example, an .mp4 file, I can edit the 'details' such as Title, Subtitle, Rating, Contributing Artists, Genre,...
Hello. I'm using File Metadata to add custom values in file attributes to a some text files. I have this: 230043 See the comment: this is custom.
As a keen flickr member I have a lot of photographs on my computer. These are all neatly allocated to different files, depending upon a variety of variables. So far....all is well. Yesterday my neighbour kindly upgraded me to Windows 10. ...
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 05:20.
Find Us




Windows 10 Forums