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