Skip to main content
Inspiring
June 23, 2023
Question

metadata keyword: utility script pack VS exiftool

  • June 23, 2023
  • 2 replies
  • 239 views
 

 

goodmorning community,

I've installed and tested utility script pack on Adobe Bridge (macOS).
My goal is to tag INDD and PDF documents, adding keywords metadata to a lot of files.

This is the keyords structure I want to apply:

 

 

 

 

 

 

 

After applying keywords I want to create a document with a list of all files and the specific keyword applied.

To do this I've installed utility script pack on my Adobe Bridge (macos) and run Folder List Export script.

It seems this script always export every single keyword and also hierarchical structure. This is a little bit complicated to manage in Excel. This is the file generated by the script:

 

 

/011-Doc_Tec_Com/001-Inverter															
34 Items.															
															
Filename	Label	Keywords													
FILENALE01.PDF	Approvato	1PH	ENERGY|DOC|FL	ENERGY|LINGUA|ITA	ENERGY|PRD|Inverter	ENERGY|PRD|Inverter|1PH	ENERGY|PRD|Inverter|ONG	FL	ITA	Inverter	ONG				
FILENALE02.PDF	Approvato	1PH	ENERGY|DOC|FL	ENERGY|LINGUA|ITA	ENERGY|PRD|Inverter	ENERGY|PRD|Inverter|1PH	ENERGY|PRD|Inverter|ONG	FL	ITA	Inverter	ONG				
FILENALE03.PDF	Approvato	1PH	ENERGY|DOC|FL	ENERGY|LINGUA|ITA	ENERGY|PRD|Inverter	ENERGY|PRD|Inverter|1PH	ENERGY|PRD|Inverter|IBR	ENERGY|PRD|Inverter|OFG	ENERGY|PRD|Inverter|STR	FL	IBR	ITA	Inverter	OFG	STR
FILENALE04.PDF	Approvato	1PH	ENERGY|DOC|FL	ENERGY|LINGUA|ITA	ENERGY|PRD|Inverter	ENERGY|PRD|Inverter|1PH	ENERGY|PRD|Inverter|IBR	ENERGY|PRD|Inverter|OFG	ENERGY|PRD|Inverter|STR	FL	IBR	ITA	Inverter	OFG	STR
FILENALE05.PDF	Approvato	1PH	ENERGY|DOC|FL	ENERGY|LINGUA|ENG	ENERGY|PRD|Inverter	ENERGY|PRD|Inverter|1PH	ENERGY|PRD|Inverter|IBR	ENERGY|PRD|Inverter|OFG	ENERGY|PRD|Inverter|STR	ENG	FL	IBR	Inverter	OFG	STR
FILENALE06.PDF	Approvato	1PH	ENERGY|DOC|FL	ENERGY|LINGUA|ENG	ENERGY|PRD|Inverter	ENERGY|PRD|Inverter|1PH	ENERGY|PRD|Inverter|IBR	ENERGY|PRD|Inverter|OFG	ENERGY|PRD|Inverter|STR	ENG	FL	IBR	Inverter	OFG	STR
FILENALE07.PDF	Approvato	3PH	ENERGY|DOC|FL	ENERGY|LINGUA|ENG	ENERGY|PRD|Inverter	ENERGY|PRD|Inverter|3PH	ENERGY|PRD|Inverter|IBR	ENERGY|PRD|Inverter|OFG	ENERGY|PRD|Inverter|STR	ENG	FL	IBR	Inverter	OFG	STR
FILENALE08.PDF	Approvato	3PH	ENERGY|DOC|FL	ENERGY|LINGUA|ENG	ENERGY|PRD|Inverter	ENERGY|PRD|Inverter|3PH	ENERGY|PRD|Inverter|IBR	ENERGY|PRD|Inverter|OFG	ENERGY|PRD|Inverter|STR	ENG	FL	IBR	Inverter	OFG	STR
FILENALE09.PDF	Approvato	3PH	ENERGY|DOC|FL	ENERGY|LINGUA|ITA	ENERGY|PRD|Inverter	ENERGY|PRD|Inverter|3PH	ENERGY|PRD|Inverter|IBR	ENERGY|PRD|Inverter|OFG	ENERGY|PRD|Inverter|STR	FL	IBR	ITA	Inverter	OFG	STR
FILENALE10.PDF	Approvato	3PH	ENERGY|DOC|FL	ENERGY|LINGUA|ITA	ENERGY|PRD|Inverter	ENERGY|PRD|Inverter|3PH	ENERGY|PRD|Inverter|IBR	ENERGY|PRD|Inverter|OFG	ENERGY|PRD|Inverter|STR	FL	IBR	ITA	Inverter	OFG	STR
FILENALE11.PDF	Approvato	1PH	ENERGY|DOC|FL	ENERGY|LINGUA|ENG	ENERGY|PRD|Inverter	ENERGY|PRD|Inverter|1PH	ENERGY|PRD|Inverter|ONG	ENERGY|PRD|Inverter|STR	ENG	FL	Inverter	ONG	STR		
FILENALE12.PDF	Approvato	1PH	ENERGY|DOC|FL	ENERGY|LINGUA|ENG	ENERGY|PRD|Inverter	ENERGY|PRD|Inverter|1PH	ENERGY|PRD|Inverter|ONG	ENERGY|PRD|Inverter|STR	ENG	FL	Inverter	ONG	STR		
FILENALE13.PDF	Approvato	1PH	ENERGY|DOC|FL	ENERGY|LINGUA|ITA	ENERGY|PRD|Inverter	ENERGY|PRD|Inverter|1PH	ENERGY|PRD|Inverter|ONG	ENERGY|PRD|Inverter|STR	FL	ITA	Inverter	ONG	STR		

 

 

 

I dont know how to exclude the hierarchical structure information from the output of the Folder List Export script, keeping only keywords.

To solve the problem I have tested exiftool.
this tool assigns the names "subject" and "hierarchical subject" respectively to the keyword and to the hierarchical structure of the keywords.
the commandline output generate the list I need.
after a while I try with powershell.


what is your opinion about the Folder List Export script ?

thx

 

This topic has been closed for replies.

2 replies

Legend
July 17, 2023

Are you using the latest version of my scripts?

https://www.dropbox.com/sh/mg817g9a9ymbasi/AADTmXUVxmFfM58bcyYE7yiwa?dl=0

You can specify what data is exported by Folder List Export, if you want to get just keywords. There is also an option to concatenate keywords. The resulting CSV file can be opened in any spreadsheet app.

You can also use my EXIFTool scripts to run EXIFTool inside Bridge, if that gives you better results.

Finally, my scripts are Apache-licensed open source so you can modify them if you'd like, within the terms of the license.

Stephen Marsh
Community Expert
Community Expert
July 15, 2023

@milko259349307s4y wrote:
 

what is your opinion about the Folder List Export script ?


 

 

I'll tag in @Lumigraphics as the script creator is probably the best person to answer this...

 

P.S. Lumigraphics also made it possible to run ExifTool commands from Bridge!