|If you have a large
photo collection, you may struggle to find a particular
image when you need it. If you have taken the time to tag
your photos with FastPhotoTagger or some other tool, or if
camera-created metadata is the key to finding the image
then you will benefit from FastPhotoTagger's database and
These are the steps for setting up a database and then searching it
o Choose metadata for database
o Choose photo repositories
o Create the database
o Understand search terms
o Perform a simple search
o View search results
o Perform more complicated searches
o Copy search results
Choose Metadata for Database
You have already chosen metadata to work with. Those items appear with text entry boxes on the main application window. All those metadata items will be in the database. In addition, you may choose other metadata for the database that will not have text entry boxes. Typically, these are items you want to search for but never change. Some examples: file creation date, file path, image size, camera settings, GPS data. Specify this metadata on the Settings/Metadata window with a Size = "none".
Choose Photo Repositories and Create Database
Specify the folders whose image metadata is to be in the database. Typically, these are top-level folders where photos are stored. (These folders will be searched recursively so images in all subfolders will be included.) To add a folder, on the Settings/Repositories window, right-click and select "Add Folder". Alternatively, you can simply drag a folder onto this panel. (This does not actually move or change that folder.)
Once you have specified the photo repositories, right-click and select "Update Database". This will create the database by locating every image file in every photo repository and writing your selected metadata to the database. If this takes a long time because of a large number of photos, you can interrupt the process by pressing "Cancel" and later resume where you left off. You must rerun "Update Database" whenever any files in the photo repositories change.
Expect database creation to take one minute for every 1000 images, depending on computer speed and image size. Expect the database to consume 500KB for every 1000 images, depending on the size of the metadata values. The database will be created in the .fastphototagger folder in your user folder.
Please read the notes at the bottom of this page.
Understand search terms
FastPhotoTagger searches are constructed from building blocks called "search terms". To see a search term, click "Search Metadata" on the main application window. A search panel with a blank search term will appear.
A search term has three parts:
1) A metadata selector. Select the metadata tag you wish to use in a search.
2) An operation selector. Select the operation to be applied to the selected metadata tags.
3) A value. Enter the value to be compared to database values using the operation.
For example, if you want to search for images whose metadata tag "Title" contains the word "Vacation", you would select:
The metadata selector contains your chosen metadata tags plus two tags created by FastPhotoTagger:
You may use these tags in your searches.
The operation selector contains these operations:
Very important notes:
1. If both the metadata item and the value are numeric then a numeric comparison is done. So, for example, "40" is less than "100". If either the metadata tag or the value is non-numeric then a text comparison is done. Alphabetical or "dictionary" order determines the result of a text comparison. So, "alligator" is less than "apricot" because it appears earlier in alphabetical order. Also, "100" is less than "40x" because "100" appears earlier in alphabetical or dictionary order.
2. The "Descriptive metadata values" setting is ignored by the database. The database will always contain numeric versions of metadata. So, for example, a GPS Latitude will appear in the database as 20 rather than 20 deg 0' 0.00" N.
3. Except for FPTFILEPATH, all comparisons are case insensitive. So, for the search shown above, Titles containing Vacation, VACATION, and VaCaTioN, etc. will all match. FPTFILEPATH is case sensitive.
4. You can leave the value empty and use the = and <> operators to locate images where the metadata tag is empty or not empty. Except for these cases, leaving value empty is ambiguous and not recommended.
Perform a simple search and view search results
Click "Search Metadata" on the main application window. A search panel with a blank search term will open. Select metadata, select an operation, enter a value. Press the "Search Metadata" button on the search panel. If images were found you may click the "Yes" button to view them in the main application window.
More complicated searches
To perform more complicated searches, you must create more search terms and move them around. Use a search term control button to create search terms. Use the mouse to select search terms and move them around.
Here is a slightly more complicated search.
Search terms in a row are connected by the logical AND. This means that only images satisfying all the search terms on the row will be found.
Adding one more search term:
Note that the middle search term doesn't say "year is greater than 2010". It says that alphabetically, the date must be greater than "2010". So, "2010:01:01 00:00:00" and all the other dates and times in 2010 satisfy the search term.
Here is a search with two rows of search terms.
Entire rows of search terms are connected by the logical INCLUSIVE OR. This means that each row is treated as a separate search and the results of all the separate searches are combined.
Copying Search Results
Once you've found your photos of interest, you can copy them to a file explorer window. Select one or more images and either issue the keyboard copy command (^C) or drag the images to a file explorer window. (Some file explorers may offer you the option of moving the files, however FastPhotoTagger is not designed to support moves. Do not move files from the main application window).
You may also copy your photos of interest as a captioned slideshow. Set the slideshow options using Settings/Slideshow then copy the slides to the filesystem using Settings/Other/Export Slideshow.
Saving Search Definitions to a File
Click "Save to a Search File" to write a search definition to a file for later use. The search definition will be saved in a text file in XML format. Click "Open a Search File" to load the saved search definition.
Exploring the Metadata Database
The bottom area of the Search Metadata window contains a simple explorer for viewing metadata values in the database.
The explorer has three parts:
1) A metadata selector. Select the metadata tag whose values you wish to view.
2) Filter text. Optionally enter text. The filter acts similar to the "contains" operation in a search term. Metadata values that have the filter string within them will be displayed.
3) The Metadata values for the chosen metadata tag and filter text. Metadata values are presented as words (with some punctuation removed) that are present somewhere in the database for the chosen tag and filter. This does not tell you which or how many images have the words. But it does tell you which words are present so you may use them as values in search terms.
The metadata database does not include information about files added or changed since the last "Update Database" command. This includes files changed by FastPhotoTagger that are in the Pending Changes list. You must rerun "Update Database" whenever the contents of the photo repositories change.
When you add metadata to "Program Settings / Metadata" you must rerun the "Update Database" command. All files in all photo repositories will have to be processed.
When you add or change files in the photo repositories you must rerun the "Update Database" command. Only the new and changed files will have to be processed.
The metadata database is accessible by only one FastPhotoTagger program. A second, simultaneously running FastPhotoTagger program will not be able to access the database.