Link to home
Create AccountLog in
Avatar of mynetquestions
mynetquestions

asked on

XML TO XML WITH XSLT

I have been receiving one file like this

<?xml version="1.0" encoding="utf-8"?>
<StudentDocument xmlns:sdtc="urn:sl7-org:sdtc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:hvhs="urn:hvhs:student-extensions" xmlns="urn:student-org:v3">
  <recordTarget>
    <StudentRole>
      <id root="22" extension="65478" />
    <id root="23" extension="777-22-333" />
    <id root="24" extension="33333333" />
        <addr use="RT">
        <streetAddressLine>Address1</streetAddressLine>
        <city>City</city>
        <state>ST</state>
        <postalCode>55555</postalCode>
        <country>XT</country>
      </addr>
        <telecom use="TE" value="tel:+17248468200" />
      <Student>
        <name>
          <family>john</family>
              <given>katey</given>
        </name>
      </Student>
      </StudentRoleRole>
</recordTarget>
</StudentDocument>

I want to generate formatted XML like the below by using XSLT. How do i write it in visual studio 2013?

<StudentResultData>
      <ROLLNUMBER>777-22-333</ROLLNUMBER>
      <Phone>7248468200</Phone>
      <firstname>John</firstname>
      <lastname>katey</lastname>
      <address1>Address1</address1>
      <city>City<city>
      <zip>55555</zip>
      <state>ST</state>
      <country>XT</country>
</StudentResultData>
Avatar of zc2
zc2
Flag of United States of America image

Supposedly you have the XML stored in a file, then go to File menu->New->File, Choose "XSLT File".
Create your XSLT script in the new opened window.
To test the XSLT transformation, go to the XML manu, choose "Start XSLT debugging" or press Alt+F5
Avatar of mynetquestions
mynetquestions

ASKER

I know how to open XSLT file in visual studio 2013. I am looking for XSLT code to generate from the given to required XML format
ASKER CERTIFIED SOLUTION
Avatar of zc2
zc2
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
It was really helpful and written my own XSLT files for other XML files based on this solution.