We help IT Professionals succeed at work.

XML TO XML WITH XSLT

mynetquestions
on
181 Views
Last Modified: 2015-07-03
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>
Comment
Watch Question

zc2
CERTIFIED EXPERT

Commented:
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

Author

Commented:
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
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
It was really helpful and written my own XSLT files for other XML files based on this solution.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.