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
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

Need more help with this?
Product page

Thanks for your feedback.