how to Modify of a existing XML file... how to?

[sugarferret]

H i , I have few xml files with this format: it contains supplier info and a list of products.... but the products are not numbered (such as #1, #2, #3, etc)

  <Item>
     <Quantity>12</Quantity>
     <Code>20001318</Code>
     <TotalPrice>27.12</TotalPrice>
  </Item>

How can (or if is there a good tool to do that) batch number each item of the xml file? the result xml i wish to have is some like:

<Items>
   <Item>
      <ItemNumber>1</ItemNumber>
      <Quantity>12</Quantity>
      <Code>20001318</Code>
      <TotalPrice>27.12</TotalPrice>
   </Item>
   <Item>
      <ItemNumber>2</ItemNumber>
      <Quantity>2</Quantity>
      <Code>77701318</Code>
      <TotalPrice>27.12</TotalPrice>
   </Item>
   <Item>
      <ItemNumber>3</ItemNumber>
      <Quantity>1</Quantity>
      <Code>11111318</Code>
      <TotalPrice>27.12</TotalPrice>
   </Item>
</Items>

Thanks in advance

Live as a tortoise.
and rate my mullet:

http://www.ratemymullet.com/

 

[tsuji]

That might not be a very good idea to have a data xml with element referencing specifically with the number of entries of itself. That would impose a rigid constraint on the xml when later the file be updated or changed.

One way to do it is this.
[tt]
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="

http://www.w3.org/1999/XSL/Transform">

<xslutput method="xml" indent="yes" encoding="utf-8" />
<xsl:template match="@*|node()">
<xsl:if test="local-name(.) = 'Quantity'">
<xsl:element name="ItemNumber">
<xsl:value-of select="count(parent::*/preceding-sibling::*)" />
</xsl:element>
</xsl:if>
<xsl:copy>
<xsl:apply-templates select="@*|node()" />
</xsl:copy>
</xsl:template>
</xsl:stylesheet>
[/tt]

 

[tsuji]

Further note:
If you make numbering 1-based, then modify the corresponding line.
[tt] <xsl:value-of select="count(parent::*/preceding-sibling::*)[blue]+1[/blue]" />
[/tt]

 

[JontyMC]

I agree with tsuji(!). What is the point of numbering the Items? They inherently have numbering already - the position in the nodeset.

Jon

"I don't regret this, but I both rue and lament it.

 

[sugarferret]

I think any of the solutiuons can help me, the tsuji's one and the inherits tip of JontyMC, in any case how can I run the xsl code in order to modify the xml file?

or how can I call the inherited node numbers?



Live as a tortoise.
and rate my mullet:

http://www.ratemymullet.com/

 

[tsuji]

>I think any of the solutiuons can help me, the tsuji's one and ...
That only means you are not prepared yourself to get help.

 

[JontyMC]

I depends. How do you want to modify the xml file?

Say you want to select the 3rd item, simply use: item[3]

Jon

"I don't regret this, but I both rue and lament it.

 

[sugarferret]

well... finally the problem was solved using xsl styling

thaks guys!

Live as a tortoise.
and rate my mullet:

http://www.ratemymullet.com/