Hello. Want to see if anyone reading might have an idea on this. I am planning to use a program to help add a bunch of tags to thousands of images. I am not going to want to type al those tags in a spreadsheet either so I been trying to find a way to get them from Command Prompt or Powershell (where most attempts were made), or from a tool called ExifTool.
I have manually added some tags into photos. In properties, I see my tags.
I have tried a dozen ways off the Internet, but I am getting empty entries if I try commands like:
Get-ChildItem "C:\path\to\folder" | Select-Object Name, Attributes | Export-Csv "I:\pic\file_metadata.csv" -NoTypeInformation
Get-ChildItem "C:\path\to\your\folder" | Select-Object Name, @{Name='Tags';Expression={(Get-ItemProperty $_.FullName).Tags}} | Export-Csv "C:\temp\pic.csv" -NoTypeInformation
Get-ChildItem -File | Select-Object Name, @{Name='Tags'; Expression={(Get-ItemProperty -Path $_.FullName).Tags}}, @{Name='Rating'; Expression={(Get-ItemProperty -Path $_.FullName).Rating}}, @{Name='DateCreated'; Expression={$_.CreationTime}}, @{Name='DateModified'; Expression={$_.LastWriteTime}} | Format-Table -AutoSize
Get-ChildItem | Select-Object Name, @{Name='Tags';Expression={(Get-ItemProperty $_.FullName).Tags}} | Format-Table -AutoSize
Entries always show blank in my test files like:
Name Tags
---- ----
20200905.jpg
20230618 posted by 02.jpg
IMG_20230129_133733_01.jpg
fam.jpg
I was using the command line methods to get information from ExifTool:
C:\Users\main\Desktop\exiftool-12.92_64>"exiftool(-k).exe" I:\_backups\albums_from_d\19xx\20200905.jpg
In that file, it showed the tags under XP Keywords:
XP Keywords : tagtest
I tried that in Powershell and got nothing:
Keywords
--------
Then I pulled all metadata using similar command, and it does not even show it at all. Other info, but not the tags, or even author (which I added as aaaa).
PSPath : Microsoft.PowerShell.Core\FileSystem::I:\_backups\albums_from_d\19xx\20200905.jpg
PSParentPath : Microsoft.PowerShell.Core\FileSystem::I:\_backups\albums_from_d\19xx
PSChildName : 20200905.jpg
PSDrive : I
PSProvider : Microsoft.PowerShell.Core\FileSystem
Mode : -a----
VersionInfo : File: I:\_backups\albums_from_d\19xx\20200905.jpg
InternalName:
OriginalFilename:
FileVersion:
FileDescription:
Product:
ProductVersion:
Debug: False
Patched: False
PreRelease: False
PrivateBuild: False
SpecialBuild: False
Language:
BaseName : 20200905
Target : {}
LinkType :
Name : 20200905.jpg
Length : 3403538
DirectoryName : I:\_backups\albums_from_d\19xx
Directory : I:\_backups\albums_from_d\19xx
IsReadOnly : False
Exists : True
FullName : I:\_backups\albums_from_d\19xx\20200905.jpg
Extension : .jpg
CreationTime : 10/2/2024 10:31:56 PM
CreationTimeUtc : 10/3/2024 2:31:56 AM
LastAccessTime : 10/4/2024 7:00:40 AM
LastAccessTimeUtc : 10/4/2024 11:00:40 AM
LastWriteTime : 10/2/2024 10:35:46 PM
LastWriteTimeUtc : 10/3/2024 2:35:46 AM
Attributes : Archive
So, here I am. Tired of trying here and there for two weeks and figured maybe someone who knows about extracting this information can help.
I just want to get file names, tags, creation date, modification date (and any other info I deem later form properties), exported easily into a CSV spreadsheet.
I feel I am going about this very wrong. Am not good with Powershell and using info from the 'net.
And if I show tags as a column in Window$ Explorer, or my preferred FreeCommander, it lists all the tags.
Any thoughts on getting that tag info to display and be exported? If you got something that works for you, but the command does not for me, then at least I know it could be some sort of thing with my OS (Window$ 11 Pro).
Thank you.