ConnectIT 365

Definition Lines (Import)

On the Import Definition card page, the Definition Lines can be configured. These lines are used to read the content of the import.

Field

Description

Field

Description

External Property Name

 

Type

Specifies the line type. The following values are available:

  • Data Item

  • Helper

  • Field

  • Attribute Only used for data format XML

  • Namespace Declaration Only used for data format XML

Namespace Prefix

Specifies which namespace prefix should be used for the tag. Used only for data format XML.

No.

Specifies the table number or field number, depending on the selected line type (Data Item or Field). Not used for other line types.

Caption

Specifies the caption of the table or field, depending on the selected line type.

Functions

Counts the number of functions used for the definition line. Click on the number to see the function list.

Filters

Counts the number of filters used for the definition line. Click on the number to see the filter list. Only used for line type Data Item and Helper to filter the node.

External Identifier

Specifies an identifier to use instead of the primary key fields for the record to import.

Validate

Specifies if the field should be validated. This will execute the OnValidate() trigger in the table object for the field.

Run Trigger

Specifies if the OnInsert() or OnModify() trigger should be executed for the table object when updating the field value.

New Record

Specifies the action to take when detecting a new record to insert. The following values are available:

  • Create

  • Do Nothing

Record Exists

Specifies the action to take when detecting an existing record to update. The following values are available:

  • Update

  • Do Nothing

  • Recreate

  • Duplicate

  • Delete

Field Exists

Specifies the action to take for a field when detecting an existing record to update. The following values are available:

  • Update

  • Do Nothing

  • Add Only used for fields with data type Media Set

Use Suffix

Use a suffix on the primary key. Only used with Record Exists option Duplicate

IDYN 2024