Adding new element on top of XML data via XSLT

Question

I am new to XML and XSLT so I need little bit of help. I have this kind of XML:

<Catalogue>
     <App id="1">
         <Car>BMW</Car>
         <BodyType>Sedan</BodyType>
         <PartType>Wiper</PartType>
         <PartNumber>1234</PartNumber>
     </App>
     <App id="2">
         <Car>Dodge</Car>
         <DriveType>FWD</DriveType>
         <PartType>Wiper</PartType>
         <PartNumber>5678</PartNumber>
     </App>
     <App id="3">
         <Car>Chevrolet</Car>
         <EngineVIN>G</EngineVIN>
         <PartType>Wiper</PartType>
         <PartNumber>9012</PartNumber>
     </App>
     <App id="4">
         <Car>VW</Car>
         <PartType>Wiper</PartType>
         <PartNumber>3456</PartNumber>
     </App>
</Catalogue>

I can't figure out how to write a XSLT to add top App with id=0 so it would look like this:

<Catalogue>
     <App id="0">
         <Car></Car>
         <BodyType></BodyType>
         <DriveType></DriveType>
         <EngineVIN></EngineVIN>
         <PartType></PartType>
         <PartNumber></PartNumber>
     </App>
     <App id="1">
         <Car>BMW</Car>
         <BodyType>Sedan</BodyType>
         <PartType>Wiper</PartType>
         <PartNumber>1234</PartNumber>
     </App>
     <App id="2">
         <Car>Dodge</Car>
         <DriveType>FWD</DriveType>
         <PartType>Wiper</PartType>
         <PartNumber>5678</PartNumber>
     </App>
     <App id="3">
         <Car>Chevrolet</Car>
         <EngineVIN>G</EngineVIN>
         <PartType>Wiper</PartType>
         <PartNumber>9012</PartNumber>
     </App>
     <App id="4">
         <Car>VW</Car>
         <PartType>Wiper</PartType>
         <PartNumber>3456</PartNumber>
     </App>
</Catalogue>

I am trying for couple of days now with no luck, so any help would be appreciated. I need this because when I want to import this XML into Access, for some reason if in first "App" all fields aren't defined (which occur in other "App"-s), they don't get imported.

Thank you!

Is the set of the tags under <App id="0"> fixed or is this supposed to be a dynamic union of all tags used under the other <App> tags? — Marcus Rickert
– Marcus Rickert, Commented Oct 13, 2014 at 11:19
Well, it is dynamic depending of a XML i receive, but my idea is to add them fixed. Because I am a beginner with XSLT I was thinking to add all tags possible regardless of the XML I receive. I have no idea how I would do it dynamically. Also I don't know if I can use XSLT 2.0, I don't know does Access 2007 work with XSLT 2.0. — Skaki
– Skaki, Commented Oct 13, 2014 at 11:24

Marcus Rickert · Accepted Answer · 2014-10-13 11:59:41Z

1

If you are satisfied with a fixed set of tags it can be done in XSLT 1.0 quite easily as follows:

<xsl:template match="/Catalogue">
  <Catalogue>

    <App id="0">
      <Car></Car>
      <BodyType></BodyType>
      <DriveType></DriveType>
      <EngineVIN></EngineVIN>
      <PartType></PartType>
      <PartNumber></PartNumber>
    </App>

    <xsl:copy-of select="App"/>

  </Catalogue>
</xsl:template>

Note that I added closing tags for <App>. These were missing in your XML file.

edited Oct 13, 2014 at 11:59

answered Oct 13, 2014 at 11:32

Marcus Rickert

4,2463 gold badges26 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Skaki Over a year ago

@Marcus Rickert: Can I kindly ask you for little bit more help? Answer you posted here works, but I need to integrate it into another problem which is on this link. Anyway I need to add this <App id="0"> to a more complex XML than I posted here.

Skaki Over a year ago

@michael.hor257k: Can you please take a look at my other question on this link. Thank you!

Collectives™ on Stack Overflow

Adding new element on top of XML data via XSLT

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related