Merge 2 xml into 1 xml[Answered] RSS

• • Reply
  micnie2020

  Member

  124 Points

  786 Posts

  Merge 2 xml into 1 xml

  Apr 02, 2013 11:06 PM|micnie2020|LINK

  Hi All,

   

  How can i merge 2 xml into 1 xml:-

  tests3a.xml

  <?xml version="1.0" encoding="utf-8"?>
  <Items>
  <Item>
     <name> Item1 </name>
     <value> 20   </value>
  </Item>
  <Item>
     <name> Item2 </name>
     <value> 20   </value>
  </Item>
  <Item>
     <name> Item4 </name>
     <value> 50   </value>
  </Item>
  </Items>

  tests3b.xml

  <?xml version="1.0" encoding="utf-8"?>
  <Items>
  <Item>
     <name> Item1 </name>
     <value> 10   </value>
  </Item>
  <Item>
     <name> Item2 </name>
     <value> 20   </value>
  </Item>
  <Item>
     <name> Item3 </name>
     <value> 30   </value>
  </Item>
  </Items>
  

  I need the Output  as below, how can i used html & .xls to transform below output and save result as output_<<ddmmyy>>.xml :-
  <?xml version="1.0" encoding="utf-8"?>
  <Items>
          <Item>   
                <name>Item 1<name/>    
                <value before="20" after="10"/>
          </Item>
          <Item>    
                <name>Item 2</name/>    
                <value before="20" after="20"/> 
           </Item> 
           <Item>                
                 <name> Item3 </name>                
                  <value before="none" after="30"/>       
           </Item>
           <Item>   
               <name> Item4 </name>   
               <value before="50" after="none"/>  
           </Item>        
  </Items>

  Please advise.

   

  Thank you.

  Regards,

  Micheale

  
  
  

• • Reply
  thirumaran00...

  Contributor

  4954 Points

  1726 Posts

  Re: Merge 2 xml into 1 xml

  Apr 02, 2013 11:12 PM|thirumaran007|LINK

  yes , you cad do with xmlDocument Class, please have a look into this post

  http://forums.asp.net/t/1780270.aspx/1

  Please remember to click "Mark as Answer" on this post if it helped you
  
  With Friendly,
  Thirumaran
• • Reply
  micnie2020

  Member

  124 Points

  786 Posts

  Re: Merge 2 xml into 1 xml

  Apr 02, 2013 11:22 PM|micnie2020|LINK

  Hi,

   

  Any chance to do that purely using .xsl & html & javascript? I had using Linq to get the differences of 2 xml. But my superior insist me only used .xslt, .xsl, html or javascript to do that. I am cracking my head for past few week. Last choice, is to get hlp from asp.net forum.

   

  Please advise.

   

  Regards,

  Micheale

• • Reply
  thirumaran00...

  Contributor

  4954 Points

  1726 Posts

  Re: Merge 2 xml into 1 xml

  Apr 02, 2013 11:26 PM|thirumaran007|LINK

  you can try with jquery something like this..

  var files = ['tests3a.xml','tests3b.xml']
  var xmlResult, temp = "";
  
  loadMyXMLFiles(){
      $.each(files, function(index,value) {
        $.ajax({
            url: value,
            cache: true,
            async: false, //This is crucial!
            success: function(data){
              temp += data;
              if (index == files.length-1) {
                  xmlResult = temp; temp = null;
              }
            }
        });
    });
  }

  
  
  

  Please remember to click "Mark as Answer" on this post if it helped you
  
  With Friendly,
  Thirumaran
• • Reply
  micnie2020

  Member

  124 Points

  786 Posts

  Re: Merge 2 xml into 1 xml

  Apr 02, 2013 11:30 PM|micnie2020|LINK

  Hi,

  Thanks.
  Will give a try using Jquery.

   

  Regards,
  Micheale