The DB Sync task is used to synchronize the database and file system and is only available if the "DBSync" plugin is installed. You will find the installation file on the "iba Software & Manuals" data medium in the following directory:

…\01_iba_Software\ibaDatCoordinator\02_Plugins\DBSyncPlugin

The task type is designed for use in a scheduled job.

When extracting values from a data file into a database using ibaAnalyzer, an entry is created for each data file in the index table (ibaFile table). In addition to the user-defined values for info fields and evaluated columns, this record contains a number of other bits of information for each data file, such as the file name with full file path.

The file name is used by ibaAnalyzer or ibaDaVIS as a reference for the drill-down into the high-resolution raw data.

A file reference may become invalid if the original file is moved to another folder or completely removed from the system, e.g., by a cleanup task.

Each time it is executed or synchronized, the plugin checks the validity of the file references in the database index table by verifying the existence of the corresponding data file. The result of this check of the validity of the reference can be registered in an additional column of the index table. The status “1” for a record of this column will indicate that the file reference is valid and “0” indicates that the file could not be found at the referenced file path.

An option in the plugin allows you to delete entries for which no data file could be found.

For information on the general settings of the task, see General task settings.

For a description of how to configure the task, see Configuring a DB sync task.