Tuesday, May 01, 2012
Everyone knows that fixed length files can be a little tricky when mapping. SAP is one the ERP systems that exports the file in a fixed length format. As long as you are able to supply us with the metadata file from SAP, we have the ability to convert the fixed length file into an XML formatted file. The XML formatted file can help in multiple ways. XML makes your application file easier to read. Each field from the XML will have a name assigned to it. The name is called a node and that is what we would be using while creating the outbound EDI file.
When using the XML format for your application data, you will need to make sure you know what information is Header information and what the Detail information is. While mapping the outbound transactions, you will use the XPath Query function within the EDI/HQ Mapper. When mapping the EDI data, you will need to extract the nodes from the XML data. In order to pull the information you will need to start the XPath Query with the node name from the XML file. This will extract the node from the XML and place it in the correct location. When you are ready to move on to the Detail or Item information, you will change the way you pull this data out of the XML. You will need to make certain the SQLData/SQLRow is set up to determine a single loop iteration when you are setting up your properties for the item loop. Once that is setup correctly and you are able to see the loop iterations, you will simply use the XPath Query but only need SQLRow/(node name) to extract that data.
One very important thing is to make sure is when extracting from an XML application file everything is case and space sensitive. And, as always, your consultant is here to help you!