heevicsspeacy
New Member
i have a source.xml file\[code\]<?xml version="1.0" encoding="utf-8" ?><Studentdatabase> <Student> <id>0001</id> <Fname>SOMEX</Fname> <Mname>Y</Mname> <Lname>Z</Lname> <DOB>1992-05-26T00:00:00+05:30</DOB> <fathersname>XYZ</fathersname> <cls>I</cls> <gen>M</gen> <add>kadapa</add> </Student> <Student> <id>0002</id> <Fname>SOMEA</Fname> <Mname>B</Mname> <Lname>C</Lname> <DOB>1991-04-6T00:00:00+05:30</DOB> <fathersname>ABC</fathersname> <cls>II</cls> <gen>F</gen> <add>PUNE</add> </Student> <Student> <id>0003</id> <Fname>SOMED</Fname> <Mname>E</Mname> <Lname>F</Lname> <DOB>1990-08-2T00:00:00+05:30</DOB> <fathersname>DEF</fathersname> <cls>III</cls> <gen>M</gen> <add>JMD</add> </Student></Studentdatabase>\[/code\]and a destination.xml file\[code\]<?xml version="1.0" standalone="yes"?><MyDB> <tableName> <studentid>1</studentid> <Firstname>chaithanya</Firstname> <middlename>babu</middlename> <lastname>satyala</lastname> <Dateofbirth>1991-05-26T00:00:00+05:30</Dateofbirth> <fathersname>babu</fathersname> <class>I</class> <gender>M</gender> <address>kadapa</address> </tableName> <tableName> <studentid>2</studentid> <Firstname>charan</Firstname> <middlename>kumar</middlename> <lastname>palla</lastname> <Dateofbirth>1990-10-05T00:00:00+05:30</Dateofbirth> <fathersname>krishnaiah</fathersname> <class>I</class> <gender>M</gender> <address>hyderabad</address> </tableName> <tableName> <studentid>3</studentid> <Firstname>kondaiah</Firstname> <middlename /> <lastname>dasari</lastname> <Dateofbirth>1985-06-05T00:00:00+05:30</Dateofbirth> <fathersname>dasari</fathersname> <class>II</class> <gender>M</gender> <address>porumamilla</address> </tableName> <tableName> <studentid>4</studentid> <Firstname>dheeraj</Firstname> <middlename>reddy</middlename> <lastname>polimera</lastname> <Dateofbirth>1991-05-16T00:00:00+05:30</Dateofbirth> <fathersname>krishna reddy</fathersname> <class>II</class> <gender>M</gender> <address>pulivendula</address> </tableName> <tableName> <studentid>5</studentid> <Firstname>shabaz</Firstname> <middlename>banu</middlename> <lastname>noormohammad</lastname> <Dateofbirth>1991-06-16T00:00:00+05:30</Dateofbirth> <fathersname>noor ahmed</fathersname> <class>III</class> <gender>F</gender> <address>jmd</address> </tableName> <tableName> <studentid>6</studentid> <Firstname>khairuna</Firstname> <middlename>begum</middlename> <lastname>taticherla</lastname> <Dateofbirth>2002-02-02T00:00:00+05:30</Dateofbirth> <fathersname>kullay</fathersname> <class>III</class> <gender>F</gender> <address>gugudu</address> </tableName> <tableName> <studentid>7</studentid> <Firstname>chandrakala</Firstname> <middlename /> <lastname>kummera</lastname> <Dateofbirth>1991-06-03T00:00:00+05:30</Dateofbirth> <fathersname>lingreddy</fathersname> <class>IV</class> <gender>F</gender> <address>anantapur</address> </tableName></MyDB>\[/code\]Now the issue is i need to insert the data from source file to destination file by changing the names of the elements and tags with reference to destination file... i.e., for example \[code\]<Fname>\[/code\] in the source file must be changed to \[code\]<FirstName>\[/code\] in destination fileCan any one help me on this?