ExifTool Forum

ExifTool => Developers => Topic started by: berliner_ffm on April 06, 2020, 02:18:14 PM

Title: Making an ExifTool GUI in Excel
Post by: berliner_ffm on April 06, 2020, 02:18:14 PM
Hello,

over the past weeks I tried to work my way through the most important functions in ExifTool and although I just scratched the surface I already found out that I need something that helps me creating the Commands I want. Thats when I startet to build a Excel-Workbook that helps me define the parameters for ExifTool.
After some work a first alpha version is now ready and I wanted to see what you think about it.

Beware that this is a first version and it might still have some bugs in it. I am planning to make it Donation Ware at some point but for know I will only provide it here, seeking for Feedback, Bug Report and Feature Suggestions. Also suggestions in Terms of Usability are valued.

The Workbook contains 3 Sheets:

The config sheet sections can be expanded by the "+" sign on the side.
The last "+" in the config sheet reveals the created exifTool statement and the button "Run ExifTool" will execute the statement in the windows commandline (I have only a windows system, so I cannot speak for Mac).
To make it work make sure to enter your exifTool path and filename in the "ExifTool Configuration" area.

So far the sheet contains the most basic functions, like
-reading Metadata
-write Metadata to file
-change Metadata
-Rename/Copy and Move Files

I am planning to extend functionalities once these things are working stable.

Ok, I that's enough for now. I hope you like it!
Title: Re: Making an ExifTool GUI in Excel
Post by: Phil Harvey on April 06, 2020, 03:26:52 PM
Very interesting.  I didn't know you could do that sort of thing in Excel.

- Phil
Title: Re: Making an ExifTool GUI in Excel
Post by: berliner_ffm on April 07, 2020, 03:05:49 PM
New Version
  -fixed 2 value lists
  -added output option for binary data (e.g. thumbnail extraction)
Title: Re: Making an ExifTool GUI in Excel
Post by: berliner_ffm on April 13, 2020, 03:04:25 PM
Over the past days I threw away my approach of making the userinterface a spreadsheet. Instead I went with a userform.
Also I added some more functions:
-Criterias (if-Tag)
-User defined parameters
-%c and %C-Option when renaming files
-Reading Tags from csv-files (-csv-Option)
-json-format for output
-Execution in Powershell instead of Commandline (which gives more options for future expansions)
-Save Command (inkl. Userprompts) into a powershell script
-Save Settings as Templates for future use

Also I fixed some bugfixes and explored with possibilities of combining ExifTool with Google's Cloud Vision API (Auto-keywording) and Google-Translate API. Both will be part of later updates.

Beware that this still a very early version, so bugs may still appear here and there.
Thanks for any feedback!
Jens