EDI to XML component

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.

Configuration

The EDI to XML component has the following configuration options:

Property	Default value	Description
Segment	LB	Delimiter to identify different segments, the first is considered to be the header
Field	~	Delimiter to identify different fields
Component	^	Delimiter to identify different components
SubComponent	!	Delimiter to identify different sub-components

Remarks

• Within Segment the 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.

Example

When given the following input:

CUSJohn^Doe1901-01-07~john.doe@example.com

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>john.doe@example.com</field.3>
  </CUS>
</edi-message>