Properties for a Field on a Dataport Data Item

The following table lists properties that you can set for a field on a data item in a dataport.

Property

Description

Defines if the field is enabled or disabled. A field that is disabled is imported from the external file, but will not be inserted into the record.

SourceExpr Property

The source expression of the field. When you are importing, this could be the name of the database table field where the value that is read from the external file should be stored, but it can be any valid C/AL variable. When you are exporting, this could be the value that is exported to the external file, such as the name of a database table field, but it can be any valid C/AL expression.

Caption Property

The caption in the currently selected language.

The value is taken from the CaptionML Property if this property is set. For example, the default value in English (United States) is the same as the name of the field.

CaptionML Property

The list of all the translations of the field’s caption

StartPos Property

If the FileFormat Property for the dataport itself is set to Fixed, this field defines the starting position of the data item field. Positions are numbered starting at 1.

Width Property (Dataport field)

If the FileFormat Property for the dataport itself is set to Fixed, this field defines the width of the field.

The following table describes the default values for the Width Property (Dataport field) for each field data type.

Field data type	Width assigned
Code	If actual length > 10, actual length is used, otherwise 10.
Text	If actual length > 30, actual length is used, otherwise 30
Date	11
Time	10
Option	10
Decimal	12
Integer	7
Boolean	10

CallFieldValidate Property

Defines if the OnValidate (Fields) Trigger is executed when the field is imported.

Format Property

Determines how the field is formatted during exportation. For example, you can determine the number of decimal places.

AutoCalcField Property

Defines if the field is a FlowField that must be automatically calculated.

When fields are exported, the data they contain is converted to text before being exported. If the format is fixed and the width is smaller than the actual width of the data after conversion, the contents are truncated from the right until it has the defined width. That is, a number is not rounded or truncated as a number, but as text, from the right.

You get a warning at design-time if you have defined fields with starting positions and widths that could cause these fields to overlap. The error makes it impossible to compile (and subsequently execute) the dataport.

During import, a value that is too large for the data type or defined width of the database table field where it is to be inserted causes an error and execution stops. Because the whole dataport is within a transaction, no traces will be left of the failed run in the database.

Reference

Properties for a Dataport
Properties for a Data Item in a Dataport

Concepts

Designing Dataports
Triggers on Dataports Overview

Properties for a Data Item Field

Remarks

See Also

Reference

Concepts