Do you know how to export image tags?
Do you know how to export image tags?
Hello. I'm looking for suggestions from anyone who might have insights on this. I'm planning to utilize a tool to add numerous tags to thousands of images. I don't want to manually input the tags into a spreadsheet, so I've been exploring options using Command Prompt or PowerShell (where most efforts were made), or the ExifTool utility.
I've added tags manually in the photo properties. In the settings, my tags appear. I've experimented with several methods online, but I'm encountering empty results when running 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
However, my test files consistently display blank rows like:
Name Tags
I added tags manually in photos. In properties, I see them listed.
How did this happen? For example, I opened the image, then went to File Properties, Details tab, and clicked Tags.
Typing "dad, mom, sister" and clicking Apply worked?
When I revisited and checked the tags, were they present—including commas?
The issue might be caused by commas in the tags, possibly treating them as delimiters like CSV.
Note: https://woshub.com/export-csv-file-...rvices.CSV
NoTypeInformation -Encoding UTF8
If commas are present, the delimiter should be changed.
The export should still work if the data is handled correctly.
As always, use test data.
Post accordingly.
Thanks for the suggestion. I attempted it but couldn't access my files. It seems your advice helped, and I'm using http://www.br-software.com/extracter.html now. I'll add Meta-extractor to my backups for now. Thank you for your reply.
"How was that done? For example, opening the photograph, then > File Properties > Details tab > Tags?"
No. Right clicking them and going into details and adding in the tags.
"And you clicked "Apply" when finished?"
You do not do that?
"Then, if you go back and check the 'Tags' words (dad, mom, sister) are there - correct? With the commas?"
No, semi colons, and not in alphabetical order which I found out is not an automatic thing.
Example as how I copied them from the property's details tab:
tagtest; wheretags
people; family; mom
"What may be causing the export problem is the commas in the tags. Possibly being treated as delimiters - CSV."
I can not even get them to display correctly. And if they not display, they not going to export.
"As always, use test data."
Common sense.
"Post accordingly."
Yes, you did okay.
But using information from the previous poster, I stumbled upon a program that does what I need right now.
Thanks for replying.
I wasn't able to include example images, so I've uploaded three instead.
Links: https://www.mediafire.com/folder/773dbpe...Fextracter
Displays files with random tags, program settings, and the CSV output of those tags.