Attributes source structure

Attributes for nodes (source structure)


Attribute

Description

Name

Name of the node and optional description (multi-line). See also section Naming conventions for nodes and fields.

Description

Can be used freely.

Delimiter Column/Row

The delimiter between the individual columns of a data record. Used for document types "CSV", "Excel" and "Database". The representation of nonprintable delimiters is supported. Note: If you are using a nested CSV structure, please ensure that only nodes at the lowest hierarchy level contain the delimiter. With larger files, this can otherwise lead to a memory overflow. Example: One parent node "Root" with two sub nodes "Header" and "Lines". Only use a delimiter for nodes "Header" and "Lines" but not for "Root".

Minimum

The minimum number of occurrences of the node in the source tree.

Maximum

The maximum number of occurrences of the node in the source tree.

Inactive

An inactive node receives no data during the parsing.

Advanced settings


You can access the advanced settings via checkbox "All".


Attribute

Description

DataCockpit/Portal control

Localization key

Data profile

Only relevant for the add-on module Forms and for web services (WSDL) .

Sub nodes are alternative

This settings is only relevant for document type "XML" and is described there.

Fix record field delimiter

A field delimiter entered here is automatically removed from the source tree when reading fixed-length data records. The field delimiters can also be entered in hexadecimal notation (e.g. 0x3b for a semicolon ;).

Path

Obsolete setting that only exists for reasons of backwards compatibility. Can be ignored.

New record after

This attribute should no longer be used, it is only available for compatibility reasons and is no longer supported.

Create new record

This attribute should no longer be used, it is only available for compatibility reasons and is no longer supported.

Attributes for fields (source structure)


Attribute

Description

Name

Description

Name of the field. See also section Naming conventions for nodes and fields. In addition, an optional description (multi-line) can be given.

New record if value changes

See the appropriate subsection in section When does the parser start a new record? A list of fields with this property can be found on page "Advanced (Phase 2)". There you can also decide how this property is logically linked if it is set in multiple fields. In the structure, this is represented by the icon images/download/attachments/164333019/Wertaenderung-version-1-modificationdate-1734668794331-api-v2.png . See also section Search and find.

Data type

Data type of the field.

Length

For data with the document type "Fixed-length", the value entered here corresponds to the length of the field. For data with the document type "CSV", the content of the field is shortened to the length entered here. If the attribute has the value 0, the value of the field is taken over unabridged.

Template

Specifies the format of the input values. This allows different formats for dates or floating-point numbers to be converted into the internal format. An example of a format specification: dd.MM.yy. The format specification Nx.y is intended to convert numerical data in fixed-length files into decimal numbers. Only the number behind the dot (y part) is used, the length of the field is determined by the length specification (4). Example: If the originally read in field value is 0003077, the format specification is N1.2 and the data type is Float, the value 30.77 will be entered into the field.

See also section Format templates for dates and times.

Minimum

Maximum

Minimum/maximum number of occurrences of the field in the source tree.

Advanced settings


You can access the advanced settings via checkbox "All".


Attribute

Description

DataCockpit/Portal control

Localization key

Data event

Show in list

Allowed values

Only relevant for the add-on module Forms and for web services (WSDL) .

Default value

Is relevant in connection with attribute New record if value changes. See the appropriate subsection in section When does the parser start a new record?