XML To EDI - DataStage TX Map

The Howes-IT-Going XML To EDI DataStage TX Map is an IBM/Ascential DataStage TX EDI Map Conversion process which converts an XML based Purchase Order to EDI X12 850 ver 4010. I really enjoy doing all types of Data Conversions -- and this is an example of BOTH XML AND EDI Mapping done TOGETHER in the SAME PROCESS!

As with all DataStage TX Mapping - You need to have DTD, Document/Data Type Definition files - also known as Type Trees. The Input Type Tree was po_XML.mtt and the Output Type Tree was po4010.mtt

Howes-IT-Going XML To EDI DataStage TX Map Input Type Tree po_XML.mtt

Howes-IT-Going XML To EDI DataStage TX Map Input File Settings

poin.xml Input Data File Used in HIGxml2edi Example <?xml version="1.0"?> <!DOCTYPE PO SYSTEM "POData.dtd"> <PO> <Header> <PONumber>hig081015</PONumber> <PODate>20081015</PODate> <Contact Name="Steve" Phone="314-426-0485"/> <Instruction Type="BillTo"> <Addressee>Howes-IT-Going</Addressee> <AddressLine>B1</AddressLine> <AddressLine>P.O. Box 274</AddressLine> <City>Saint Ann</City> <State>MO</State> <Zip>63074</Zip> </Instruction> <Instruction Type="ShipTo"> <Addressee>Howes-IT-Going</Addressee> <AddressLine>P.O. Box 274</AddressLine> <City>Saint Ann</City> <State>MO</State> <Zip>63074-0274</Zip> </Instruction> <GenDate Qual="ReqDelivery">20081031</GenDate> <CommentText>This is a PO</CommentText> <CommentText>Needed for Halloween</CommentText> </Header> <LineItem Seq="1"> <QtyOrdered>500</QtyOrdered> <UOM>EA</UOM> <UnitPrice>45.26</UnitPrice> <CatalogUPC Qual="IN">800-ABT1</CatalogUPC> <CommentText>Please paint this black & trim in orange</CommentText> </LineItem> <LineItem Seq="1A"> <QtyOrdered>1000</QtyOrdered> <UOM>EA</UOM> <UnitPrice>22.12</UnitPrice> <CatalogUPC Qual="IN">900-ABT1</CatalogUPC> <CommentText>Please print this message</CommentText> </LineItem> </PO>

Howes-IT-Going XML To EDI DataStage TX Map Output Type Tree

Howes-IT-Going XML To EDI DataStage TX Map Output File Settings

Howes-IT-Going XML To EDI DataStage TX Map HIGxml2edi Map Settings

Howes-IT-Going XML To EDI DataStage TX Map HIGxml2edi Map Execution

HIGxml2edi Map Run Log Used in HIGxml2edi Example <MapAudit StartTime="13:23:22 October 15, 2008"> <Platform> Command Server for Windows - Version 7.5(119)</Platform> <Burst count="1"> <ExecutionLog burstreturn="0" ElapsedSec="0.0108"> <inputstatus card="1" bytes="1288" adapterreturn="0" contentreturn="0"/> <outputstatus card="1" bytes="619" adapterreturn="0" contentreturn="0"/> </ExecutionLog> </Burst> <ExecutionSummary MapStatus="Valid" mapreturn="0" ElapsedSec="0.0190" BurstRestartCount="0"> <Message>Map completed successfully</Message> <CommandLine>'C:\Howes-IT-Going\xml\HIGxml2edi.mmc'</CommandLine> <ObjectsFound>262</ObjectsFound> <ObjectsBuilt>137</ObjectsBuilt> <SourceReport card="1" adapter="File" bytes="1288" adapterreturn="0"> <Message>Data read successfully</Message> <Settings>C:\Howes-IT-Going\xml\poin.xml</Settings> <TimeStamp>13:23:00 October 15, 2008</TimeStamp> </SourceReport> <TargetReport card="1" adapter="File" bytes="619" adapterreturn="0"> <Message>Data written successfully</Message> <Settings>C:\Howes-IT-Going\xml\x12po.dat</Settings> <TimeStamp>13:23:22 October 15, 2008</TimeStamp> </TargetReport> <WorkArea type="File"> <inputarea card="1" Path="C:\Howes-IT-Going\xml\HIGxml2edi.I01" TimeStamp="13:23:22 October 15, 2008" bytes="70432"/> <outputarea card="1" Path="C:\Howes-IT-Going\xml\HIGxml2edi.O01" TimeStamp="13:23:22 October 15, 2008" bytes="65536"/> </WorkArea> </ExecutionSummary> </MapAudit>