The Connector Rules table (afm_conn_rule_cat) lists the available rules that can be applied to the data during the transfer between systems. A common example is formatting a date string from two disparate systems.
The Connectors ship with over 20 rules. Each rule has a Rule Name (Rule Code), a description that describes the behavior of the rule, and the name of the Java Class that implements the described behavior.
Define your own rules using the System Administration / ARCHIBUS System Administration / System Administrator / Define Connector Rules task. For information, see Define Connector Rules.
| Rule Code | Description | Parameters |
|---|---|---|
| CONCATENATE | Appends values of multiple fields and specified text, and assigns the result to the field on which the rule is specified. | |
| CONVERT ENUMERATION LIST VALUE | Replaces the value with the description from the enum_list column of afm_flds on export, and reverses the operation on import. | None. |
| CONVERT TO DATE | Indicates how to interpret a textual date, when converting it into a date field in the database, or when writing a database date to a text field. | The format for the date as specified by SimpleDateFormat* |
| LOOKUP VALUE |
Replaces the value of the field with the description from a validating table, and attempts to reverse the operation on import (assuming the description is unique). |
Validating Table** The field on the Validating Table to use in place of the foreign key field. |
| NONE | Performs no translation to the field's value. | None. |
| POPULATE TABLE |
Add or update a record in a validating table when this transaction is imported. The validating table is the one specified, or if not specified, then the referenced table on afm_flds. The fields for this record are foreign key fields or those specified in parameters. |
|
| SET CURRENT DATE | Sets the value of the field to a textual representation of the current date (web server) in the specified format. If no format is specified, passes along a database compatible date. | The format for the date as specified by SimpleDateFormat* |
| SET CURRENT TIME | Sets the value of the field to a textual representation of the current time (web server) in the specified format. If no format is specified, passes along a database compatible time. | The format for the time as specified by SimpleDateFormat* |
| SET RECORD NUMBER | Sets the value of the field to the ordinal of the current transaction. The record number begins with 1 and is incremented even if the transaction is skipped. | None. |
| SET VALUE | Sets the value of the field to the textual value specified in the parameters. | The value to assign to the field. |
| SET VALUE IF NULL | Same as SET VALUE, but only if the value is null or empty. | The value to assign to the field. |
| SKIP FIELD | Do not extract, and if found remove the field from the transaction. | None. |
| SKIP IF NOT UNIQUE | Set the field on the transaction to the value specified in parameters when no field with the IDENTITY rule assigned has changed. | The value to assign to the field. |
| SKIP RECORD IF NULL OR EQUALS | Do not process the transaction if this field's value is one of the listed value or if it's null. | A pipe ("|") delimited list of field values. |
| VALIDATE - ADD | Same as POPULATE TABLE, but only if the record does not already exist in the validating table. | See POPULATE TABLE |
| VALIDATE - SKIP |
Removes the field from the transaction if it does not exist in the validating table. If SkipRecord is set as a parameter, skips the transaction instead of removing the field. |
Validating Table** "SkipRecord" |
* In some cases SimpleDateFormat features are java version dependent, based on the version of Java running the application server.
** If validating table is specified, the specified table will be used, but must be referenced by another field on the ARCHIBUS table.
| Copyright © 1984-2015, ARCHIBUS, Inc. All rights reserved. |