Java Mapping - Sort , Change header XML tag , add ...

Former Member · ‎08-16-2016

Hi Experts ,

I am facing some issues for one of my developments . I need to do the following with my input XML data -

1.Sort the data

2.Group all the data under a common header (<MT_Test_Output>) .

3.Add a node ( <Name>) after the common header for each group of data .

Note : The Input header tag <MT_Test> needs to be replaced by <MT_Test_Output> in the output .

Its pretty similar to one of my earlier posts mentioned below on Java Mapping only the Input header tag needs to be modified and a New node needs to be added .

Input :

<?xml version="1.0" encoding="UTF-8"?>

<ns0:Messages xmlns:ns0="http://sap.com/xi/XI/SplitAndMerge">

<ns0:Message1>

<ns1:MT_Test xmlns:ns1="http://test.com/xi/TEST">

<row>

<Seller_ID>1234</Seller_ID>

<Slave_Code>Slave_Code</Slave_Code>

<Quantity>Quantity</Quantity>

</row>

<row>

<Seller_ID>1234</Seller_ID>

<Slave_Code>Slave_Code2</Slave_Code>

<Quantity>Quantity</Quantity>

</row>

<row>

<Seller_ID>4567</Seller_ID>

<SKU/>

<Slave_Code/>

</row>

<row>

<Seller_ID>4568</Seller_ID>

<SKU/>

<Slave_Code/>

</row>

<row>

<Seller_ID>4568</Seller_ID>

<SKU/>

<Slave_Code/>

</row>

<row>

<Seller_ID>1234</Seller_ID>

<SKU/>

<Slave_Code/>

</row>

</ns1:MT_Test>

</ns0:Message1>

</ns0:Messages>

-------------------------------------------------------------------------------

Expected Output :

<?xml version="1.0" encoding="UTF-8"?>

<ns0:Messages xmlns:ns0="http://sap.com/xi/XI/SplitAndMerge">

<ns0:Message1>

<ns1:MT_Test_Output xmlns:ns1="http://test.com/xi/TEST">

<row>

<Seller_ID>1234</Seller_ID>

<Slave_Code>Slave_Code</Slave_Code>

<Quantity>Quantity</Quantity>

</row>

<row>

<Seller_ID>1234</Seller_ID>

<Slave_Code>Slave_Code2</Slave_Code>

<Quantity>Quantity</Quantity>

</row>

<row>

<Seller_ID>1234</Seller_ID>

<SKU/>

<Slave_Code/>

</row>

</ns1:MT_Test_Output>

<ns1:MT_Test_Output xmlns:ns1="http://test.com/xi/TEST">

<row>

<Seller_ID>4567</Seller_ID>

<SKU/>

<Slave_Code/>

</row>

</ns1:MT_Test_Output>

<ns1:MT_Test_Output xmlns:ns1="http://test.com/xi/TEST">

<row>

<Seller_ID>4568</Seller_ID>

<SKU/>

<Slave_Code/>

</row>

<row>

<Seller_ID>4568</Seller_ID>

<SKU/>

<Slave_Code/>

</row>

</ns1:MT_Test_Output>

</ns0:Message1>

</ns0:Messages>

Regards

Abhishek

anupam_ghosh2 · ‎08-17-2016

Hi Abhishek,

Please try this code


import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;




import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;


import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.NamedNodeMap;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;


import com.sap.aii.mapping.api.AbstractTransformation;
import com.sap.aii.mapping.api.StreamTransformationException;
import com.sap.aii.mapping.api.TransformationInput;
import com.sap.aii.mapping.api.TransformationOutput;




public class RepeatNode1 extends AbstractTransformation{


  Document docOut;
  NodeList row=null;
  Element r;
  public void transform(TransformationInput arg0, TransformationOutput arg1)
  throws StreamTransformationException {
  // TODO Auto-generated method stub
  try {  
   execute(arg0.getInputPayload().getInputStream(),arg1.getOutputPayload().getOutputStream());  
  } catch (Exception e) {  
   e.printStackTrace();  
   throw new StreamTransformationException(e.getMessage());  
   // TODO Auto-generated catch block  
  }  
  }
   
    void sortandCreateNode(NodeList a,Element grandParent) throws  StreamTransformationException
    {
    try
    {
      Element arr[]=new Element[a.getLength()];
       
      
      for (int i = 0; i < arr.length; i++)
         {
           arr[i]=(Element) a.item(i);  
         }
      for (int i = 0; i < arr.length - 1; i++)
         {
             int index = i;
             for (int j = i + 1; j < arr.length; j++)
             {
                 if (arr[j].getElementsByTagName("Seller_ID").item(0).getTextContent().compareTo(arr[index].getElementsByTagName("Seller_ID").item(0).getTextContent())<0)
                     index = j;
             }    
             String smallerNumber = arr[index].getElementsByTagName("Seller_ID").item(0).getTextContent(); 
             arr[index].getElementsByTagName("Seller_ID").item(0).setTextContent(arr[i].getElementsByTagName("Seller_ID").item(0).getTextContent());
             arr[i].getElementsByTagName("Seller_ID").item(0).setTextContent(smallerNumber);
         }
      Element newParent=null;
     
      for(int i=0;i<arr.length;++i)
      {
      Node parentNode=arr[i].getParentNode();  
       
     
      if(i==0 || arr[i].getElementsByTagName("Seller_ID").item(0).getTextContent().compareToIgnoreCase(arr[i-1].getElementsByTagName("Seller_ID").item(0).getTextContent())!=0)
      {
      String val=arr[i].getElementsByTagName("Seller_ID").item(0).getTextContent()+"_20160610";
      Node newNode=docOut.createElement("name");
      newNode.setTextContent(val);
     
      newParent=docOut.createElement(parentNode.getNodeName().replaceAll("MT_Test", "MT_Test_Output"));
      NamedNodeMap attributes = parentNode.getAttributes();  
       
          for (int a1 = 0; a1 < attributes.getLength(); a1++) {  
          Node theAttribute = attributes.item(a1);  
          System.out.println(theAttribute.getNodeName() + "=" + theAttribute.getNodeValue());  
          newParent.setAttribute(theAttribute.getNodeName(), theAttribute.getNodeValue());  
          }
          newParent.appendChild(newNode);
      }
      Node rowVal=docOut.importNode(arr[i], true);
      newParent.appendChild(rowVal);
      grandParent.appendChild(newParent);
     
      }
    }
    catch(Exception e)
        {
            System.out.print(e.getClass().getName());
            String error = "Probabbly missing  Seller_ID node value";
            if(e.getClass().getName().indexOf("NullPointerException")<0)
            {
            error="";
            }
            throw new StreamTransformationException(e.getMessage()+" error: "+e.getClass().getName()+" "+error);
        }
   
  return;
    }
  private void execute(InputStream in,
  OutputStream out) throws StreamTransformationException{
  // TODO Auto-generated method stub
  try
  {
  DocumentBuilderFactory docFactory = DocumentBuilderFactory.newInstance();
    DocumentBuilder docBuilder = docFactory.newDocumentBuilder();
    Document doc = docBuilder.parse(in);
    docOut = docBuilder.newDocument();
    Node SourceRootNode=doc.getDocumentElement();
    Element targetRootNode=docOut.createElement(SourceRootNode.getNodeName()); 
    NamedNodeMap attributes = SourceRootNode.getAttributes();  
     
    for (int a1 = 0; a1 < attributes.getLength(); a1++) {  
    Node theAttribute = attributes.item(a1);  
    System.out.println(theAttribute.getNodeName() + "=" + theAttribute.getNodeValue());  
    targetRootNode.setAttribute(theAttribute.getNodeName(), theAttribute.getNodeValue());  
    }


    docOut.appendChild(targetRootNode);
   
    NodeList MT_Test=doc.getElementsByTagName("ns1:MT_Test");
   
    for(int k=0;k<MT_Test.getLength();++k)
    {
    Element temp1=(Element) MT_Test.item(k);
   
    Element grandParent=docOut.createElement(temp1.getParentNode().getNodeName()); 
        attributes = temp1.getParentNode().getAttributes();  
         
        for (int a1 = 0; a1 < attributes.getLength(); a1++) {  
        Node theAttribute = attributes.item(a1);  
        System.out.println(theAttribute.getNodeName() + "=" + theAttribute.getNodeValue());  
        grandParent.setAttribute(theAttribute.getNodeName(), theAttribute.getNodeValue());  
        }
        targetRootNode.appendChild(grandParent);
    row=temp1.getElementsByTagName("row");
    sortandCreateNode(row,grandParent);
   
    }
    TransformerFactory transformerFactory = TransformerFactory.newInstance();
    Transformer transformer = transformerFactory.newTransformer();
    DOMSource source = new DOMSource(docOut);
    StreamResult result = new StreamResult(out);


    // Output to console for testing
    // StreamResult result = new StreamResult(System.out);


    transformer.transform(source, result);


           
     in.close();
     out.close();
     return ;
  }//try
  catch (Exception e) {  
   e.printStackTrace();  
   throw new StreamTransformationException(e.getMessage());  
   // TODO Auto-generated catch block  
  }  

  }



}

Regards

Anupam

Java Mapping - Sort , Change header XML tag , add new nodes

Accepted Solutions (0)

Answers (1)

Answers (1)

Re: Not able to delete SAP Business One License

Re: Timer showing while sending the mails from SAP

Re: SAP PI - Determine the receiver based on Sourc...

How to quantify memory usage of an ABAP instance v...

Re: How to add Create Git-enabled change link in c...