Dovetail can integrate with external systems that use custom EDI files to represent data.
The EDI to XML component offers an XML representation of the content of EDI files, when configured with the appropriate delimiters used by the EDI file.
The EDI to XML component has the following configuration options:
|LB||Delimiter to identify different segments, the first is considered to be the header|
|~||Delimiter to identify different fields|
|^||Delimiter to identify different components|
|!||Delimiter to identify different sub-components|
Segmentthe LB delimiter is a special keyword that is interpreted as a line break. It is only available as a segment delimiter. If used, each row in the EDI file will be considered a segment.
- The XML representation of an EDI file includes an element describing the delimiters used during the transformation.
When given the following input:
The EDI to XML component will yield the following output:
<edi-message> <delimiters segment="LB" field="~" component="^" sub-component="!" /> <CUS> <field.1> <component.1>John</component.1> <component.2>Doe</component.2> </field.1> <field.2>1901-01-07</field.2> <field.3>email@example.com</field.3> </CUS> </edi-message>