How to Convert XML File to XSL File Using XSLT

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

How to Convert XML File to XSL File Using XSLT

Author

Topic

mohan123
Constraint Violating Yak Guru

252 Posts

Posted - 2014-01-30 : 01:46:23

Hi all,

need to convert an xml file that has an attribute(name).This xml file has to be converted using xsl into the XSLT file such that the tag should have the same structure along with it and its the tag-content also should be the value of the attribute.


<?xml version="1.0" encoding="utf-8"?>
<PatientUpdateRequest xmlns="http://medseek.com/ecoEnablement/Schemas">
  <General>
    <SendingApplication>SendingApplication1</SendingApplication>
    <SendingFacility>SendingFacility1</SendingFacility>
    <ReceivingApplication>ReceivingApplication1</ReceivingApplication>
    <ReceivingFacility>ReceivingFacility1</ReceivingFacility>
    <MsgDateTime>MsgDateTime1</MsgDateTime>
    <MessageType>
      <MsgType>MsgType1</MsgType>
      <Event>Event1</Event>
    </MessageType>
    <MessageControlId>MessageControlId1</MessageControlId>
    <ProcessingId>ProcessingId1</ProcessingId>
    <VersionId>VersionId1</VersionId>
    <SequenceNumber>SequenceNumber1</SequenceNumber>
    <EventDateTime>EventDateTime1</EventDateTime>
    <EventFacility>EventFacility1</EventFacility>
  </General>
  <Patient>
    <SetId>1</SetId>
    <PrimaryId>
      <Id></Id>
      <TypeCode>None</TypeCode>
      <AssigningFacility></AssigningFacility>
    </PrimaryId>
    <Identifiers>
      <Identifier>
        <Id></Id>
        <TypeCode>None</TypeCode>
        <AssigningFacility></AssigningFacility>
      </Identifier>
      <Identifier>
        <Id>Id1</Id>
        <TypeCode>AccountNumber</TypeCode>
        <AssigningFacility>AssigningFacility1</AssigningFacility>
      </Identifier>
      <Identifier>
        <Id>Id2</Id>
        <TypeCode>CitizenshipCard</TypeCode>
        <AssigningFacility>AssigningFacility2</AssigningFacility>
      </Identifier>
    </Identifiers>
    <PatientNames>
      <Name>
        <FamilyName></FamilyName>
        <GivenName></GivenName>
        <FurtherGivenName></FurtherGivenName>
        <Suffix></Suffix>
        <Prefix></Prefix>
      </Name>
    </PatientNames>
    <DateOfBirth>DateOfBirth1</DateOfBirth>
    <Sex>None</Sex>
    <Races>
      <Race>
        <OriginalNameCode>OriginalNameCode1</OriginalNameCode>
        <NameCode>NameCode1</NameCode>
      </Race>
      <Race>
        <OriginalNameCode>OriginalNameCode2</OriginalNameCode>
        <NameCode>NameCode2</NameCode>
      </Race>
      <Race>
        <OriginalNameCode>OriginalNameCode3</OriginalNameCode>
        <NameCode>NameCode3</NameCode>
      </Race>
    </Races>

suggest me the way to do it

P.V.P.MOhan

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-01-30 : 06:51:19

should be posted in some XSLT forums i guess . this is sql server forum.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources