Connector Fields table

Use the Connector Fields table (afm_conn_flds) to map connections between the source and destination fields of ARCHIBUS and the remote system. Access this table from the Fields tab on the System Administration / ARCHIBUS System Administration / System Administrator / Configure Connectors task.

Property Name

Description

Value

Connector Code

(connector)

Uniquely identifies the connector

String

Position

(position)

Orders the fields. This is a required .  Enter consecutive integers starting with 0.  The position is critical for text and XLS file imports. 

Integer

Source Field

(field)

For an export OUT OF ARCHIBUS, the Source Field is the field within the ARCHIBUS schema (afm_flds.field_name).

For an import INTO ARCHIBUS, the Source Field is the field name in the Remote system.

String

Destination Field

(destination)

For an import INTO ARCHIBUS, the Destination Field is the field within the ARCHIBUS schema (afm_flds.field_name).

For an export OUT OF ARCHIBUS, the Destination Field is the field name in the Remote system; in the case of a text or Excel file, the Destination Field represents column header for that field.

String

Rule Code

(rule)

Rules that describe the behavior of the mapping.  The rule definitions are stored in the afm_conn_rule_cat table.

There are many type of rules available and each is described in Connector Custom Rules. 

String - Select Value

Parameters

(parameter)

Many of rules require further parameters to control their behavior; this field holds the parameter values for each field/rule combination.

String, non-validated

Validating Table

(validating_table)

The system currently ignores this property. Use the reference table from afm_flds.

String, validated on afm_tbls

Is Schema (Source) Field?

(is_schema_field)

The system currently ignores this property. Rules determine whether or not a value is expected.

Boolean (Yes/No)

Cache Validating Table

(cache)

This will be implemented in a future release.

For very long-running imports for which a lot of validation is required, the connector can cache in memory the contents of the Validating Table to reduce the number of required database queries.  Care should be taken for very large validating tables.

Boolean

Field Width

(result)

Fields are automatically truncated, zero-padded to the left (numbers), or space-padded to the right (text).

Integer or text
Copyright © 1984-2015, ARCHIBUS, Inc. All rights reserved.