With an update task, you can add info fields to a DAT-file and rename the DAT file on the basis of the data available in a database. To store the processed data file, you must define a target directory.
To use the update task, you need the ibaDatCoordinator-Update Data Task license, see Licenses.
The task-specific settings are explained below. For all other settings, see General task settings.
Database info
In this section you can configure the connection to the database.
Database provider
If database connections have already been configured in the Settings navigation menu, you can select a database connection from the list here. See Settings – Databases.
If no database connection has been configured yet, select Create database connection from the drop-down list. You will be taken to the dialog for configuring a database connection.
Other documentation |
|
|---|---|
 |
A detailed description of the database connection configuration can be found in the ibaAnalyzer documentation, Part 4 "Database Interface." |
To edit an existing connection, select the connection from the list and then click the <Edit> button.
You can delete a selected connection using the <Remove> button.
Table name
Enter the name of the database table containing the data for the update task here.
Information about the database table
The database table must contain the following columns:
-
ID_REF (string data type) The original name of the DAT file without path and extension
-
ID_NEW (string data type) The new name of the DAT file without path and extension.
-
CREATED (time/date) Date and time can only be used for debugging.
-
READY_TO_PROCESS (Boolean / short integer) This bit notifies ibaDatCoordinator if a file can be processed or not. If the cell contains a 0 (FALSE), ibaDatCoordinator does not process the file. If the cell contains a 1 (TRUE), ibaDatCoordinator processes the file.
-
PROCESSED (Boolean / short integer) The status of this field is changed by ibaDatCoordinator when the file is being processed. Status = 1 (TRUE) on successful processing
All other columns are added to the DAT file as info fields. If an info field of the string data type contains one or more "newline" characters (line break), these are replaced by blanks before being written into the DAT file.
If an info field contains the value NULL, this info field is not generated.