Database

Main Menu: File > Database
Keyboard: Ctrl-Alt-D
Toolbar button:

From this window you can open and create database for cataloguing your image files.

All the image types supported for measurements, with the exception of DICOM and Video files can be catalogued in the database.

The first time this window is opened, the files image.dbf, image.dbt and image.mdx are automatically created into the program folder. Any changes to the database are automatically saved when the windows is closed.

The database contains the Path, Filename, Date, Width, Height and size of any image included into it.

By double clicking on any image record, the related image is opened by Bersoft Image Measurement.

Right click on any field record title to sort records by that field, click again to invert the sorting order.

Image Database Toolbar

Open/Create Database button displays the Open/Create dialog, to opening or creating an image database.
To create a new Image Database: navigate to the location and write the filename you want to use.
To open an existent Image Database: select the database file.

Insert Database button opens a dialog box when you can select the database file to be inserted into the current database file. Both databases will be fully merged.

Add images menu button allows adding selected image files or folders to the current database.

If you select Files you will be able to select multiple files. If you select Folders the Inclusion Criteria window will be shown.

When adding images from folders, all image files inside the selected folder and all subfolders are going to be included, unless you specify some inclusion criteria to filter out some images.

You can filter out images by file extension, file size or file date.

The bottom text box allows filtering images by characters in the path or filename. When adding files, each image has an specific pathname, like c:\images\moon\meteor1.jpg. The full pathname is taken in account, so if you write some characters in the bottom text box only the files including such characters in the pathname are going to be included (it is not sensible to upper/lower case).

Refresh checks each file in the database and removes orphan records (in case the files were deleted). It also actualizes the file date and size (if Read size option is checked) fields.

Remove deleted records command removes permanently all records marked for deletion (the red ones). If you wish delete all records from your database opened, select Delete all records option.

Modify image location button opens a window for updating paths in the database, in case images have been moved from one folder or disk to another. In the example on the right side, the path of all images placed into the h:\image\brs\ will be modified to point to C:\brs\.

Database navigation buttons

	First: Goes to the first record.
	Prior: Goes to the previous record.
	Next: Goes to the next record.
	Last: Goes to the last record
	Delete: Marks the current record as deleted (red color) or undeleted. The record will be permanently removed from the database only after selecting Remove deleted records from Remove records button.
	Post: Writes changes in the current record to the database.
	Cancel: Cancels edits to the current record and restores the record display to its condition prior to starting edit (it works like undo). Records are automatically saved when moving from one to other or when clicking Post.

Setting a Filter using keywords

The keywords field is intended for writing keywords, separated by commas. A keyword can be a single or several words separated by spaces. Different keywords can be written into each record, in order to category your records

After each record has the proper keyword(s) assigned, you can set a filter to display a subset of the database records. After setting a filter, only the records that have the specified keyword or keywords will be shown.

Each time the Database window is opened, a keywords list is built. Clicking on the arrow at the right of the filter text box displays the list.

Example: If you wrote spring, fall in the filter box, as shown below, as soon the Set button is pressed, all records that doesn't include spring or fall in its keywords field, will be hidden.

The AND, OR buttons affect how records are filtered out. If OR is selected, records with either spring or fall in the keywords field will be shown, but if AND is selected, only records with both spring and fall words are going to be displayed.

Clicking on Clear cancels the filter and displays all records again.

Keywords are not sensible to upper or lower case.

Limitations

The keywords field can hold up to 100 characters (including spaces and commas).

The comments field can hold up to 32.000 characters.