Video-Tutorial

How to create a converter for incoming EDIFACT messages

Page 5 of 5

5 Mapping

The process of translating the data to the required output format is named "Mapping". In TransdatiX the mapping is done by a XSL transformation.

5.1 Creating the XSLT

Any desired editor can be used to write the XSLT. The TransdatiX.Editor for example is automatically installed with TransdatiX. It is also possible to place the XSLT directly into a text box in the XSL transformation window of TransdatiX, but that is only in case of very small transformations useful.

C# Scripts can be embedded into the XSLT to expand the functionality of XSLT. Those scripts are executed by TransdatiX.

5.2 Completing the interface

In TransdatiX a XSL transformation must be defined. The data provider is the already defined reader and the XSL is stored in the previous created XSLT file. The transformation can be tested directly by clicking the Execute buton. Than a further XML file connection and a XML writer is needed to write the translated data into a XML file. A general interface links reader, transformation and writer.

Video:

You need to install the Macromedia Flash Player to view the video.

EDIFACT sample file:

UNB+UNOA:3+8888888888888:14+9999999999999:14+070221:1009+123456789++ORDERS++++1'
UNH+1+ORDERS:D:96A:UN:EAN008'
BGM+220+ORDERNUMBER1'
DTM+137:20070221:102'
DTM+2:20070223:102'
NAD+BY+8888888888888::9'
NAD+SU+9999999999999::9'
NAD+DP+8888888888888::9'
LIN+1++1111111111111:EN'
QTY+21:25'
LIN+2++2222222222222:EN'
QTY+21:2:KGM'
UNT+12+1'
UNZ+1+123456789'

XML output sample:

<?xml version="1.0" encoding="ISO-8859-1"?>
<Root>
  <Message MessageID="1">
    <Envelope MessageID="1">
      <SenderId>8888888888888</SenderId>
      <RecipientId>9999999999999</RecipientId>
      <TransmissionId>123456789</TransmissionId>
      <TestFlag>1</TestFlag>
    </Envelope>
    <Order MessageID="1" OrderID="1.1">
      <Number>ORDERNUMBER1</Number>
      <Date>2007-02-21T00:00:00.0000000+01:00</Date>
      <BuyerGLN>8888888888888</BuyerGLN>
      <SupplierGLN>9999999999999</SupplierGLN>
      <DeliveryGLN>8888888888888</DeliveryGLN>
      <OrderPos MessageID="1" OrderID="1.1">
        <Number>1</Number>
        <ItemEANCustomer>1111111111111</ItemEANCustomer>
        <Quantity>25</Quantity>
        <Unit>
        </Unit>
      </OrderPos>
      <OrderPos MessageID="1" OrderID="1.1">
        <Number>2</Number>
        <ItemEANCustomer>2222222222222</ItemEANCustomer>
        <Quantity>2</Quantity>
        <Unit>KGM</Unit>
      </OrderPos>
    </Order>
  </Message>
</Root>

Page 5 of 5

Back to Introduction | Go to Top | Show Video-Tutorial Index

© 2002 - 2007 TransdatiX Software