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:
|
| 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:
|
| Record Exists | Specifies the action to take when detecting an existing record to update. The following values are available:
|
| Field Exists | Specifies the action to take for a field when detecting an existing record to update. The following values are available:
|
| Use Suffix | Use a suffix on the primary key. Only used with Record Exists option Duplicate |
Need more help with this?
Product page