Re: Re-arranging an XML file (long)

Hello everyone,

My apologies for not being more clear. Here is what I'm trying to do:

This is a snippet of the XML file I have:

<?xml version="1.0" encoding="UTF-8"?>
<wc:COLLECTION xmlns:wc="http://www.ptc.com/infoengine/1.0">
<DeletedECN NAME="DeletedECN" TYPE="Unknown" STATUS="0">
</DeletedECN>
<AddedECN NAME="AddedECN" TYPE="Unknown" STATUS="0">
</AddedECN>
<ChangedECN NAME="ChangedECN" TYPE="Unknown" STATUS="0">
</ChangedECN>
<UnchangedECN NAME="UnchangedECN" TYPE="Unknown" STATUS="0">
</UnchangedECN>
<DeletedParts NAME="DeletedParts" TYPE="Unknown" STATUS="0">
</DeletedParts>
<AddedParts NAME="AddedParts" TYPE="Unknown" STATUS="0">
<Part>
    <ObjectID>VR:wt.part.WTPart:18143:218293167-1229069940134-27856363-57-10-168-192@xxxxxxxxxxxxxxxxxxxxx</ObjectID>
    <Class>com.ptc.windchill.esi.Part</Class>
    <LastChangedBy>demo</LastChangedBy>
    <Number>0000000017</Number>
    <StartEffectivity></StartEffectivity>
    <EndEffectivity></EndEffectivity>
    <StartSerialNumberEffectivity></StartSerialNumberEffectivity>
    <EndSerialNumberEffectivity></EndSerialNumberEffectivity>
    <StartLotNumberEffectivity></StartLotNumberEffectivity>
    <EndLotNumberEffectivity></EndLotNumberEffectivity>
    <SerialNumberEffectivityCxtPartNumber></SerialNumberEffectivityCxtPartNumber>
    <LotNumberEffectivityCxtPartNumber></LotNumberEffectivityCxtPartNumber>
    <DefaultUnit>ea</DefaultUnit>
    <Name>1ZBA183001-M</Name>
    <PartType>separable</PartType>
    <Source>make</Source>
    <Version>A</Version>
    <Iteration>2</Iteration>
    <WO>W0761000</WO>
    <ItemNo>178</ItemNo>
    <Length>70.000000000000</Length>
    <Width>15.500000000000</Width>
    <Thickness>35.000000000000</Thickness>
    <Qty1>1.0000000000000</Qty1>
    <EndItem></EndItem>
    <TargetID>DT01</TargetID>
</Part>
<Part>
    <ObjectID>VR:wt.part.WTPart:18167:218293167-1229069940134-27856363-57-10-168-192@xxxxxxxxxxxxxxxxxxxxx</ObjectID>
    <Class>com.ptc.windchill.esi.Part</Class>
    <LastChangedBy>demo</LastChangedBy>
    <Number>0000000019</Number>
    <StartEffectivity></StartEffectivity>
    <EndEffectivity></EndEffectivity>
    <StartSerialNumberEffectivity></StartSerialNumberEffectivity>
    <EndSerialNumberEffectivity></EndSerialNumberEffectivity>
    <StartLotNumberEffectivity></StartLotNumberEffectivity>
    <EndLotNumberEffectivity></EndLotNumberEffectivity>
    <SerialNumberEffectivityCxtPartNumber></SerialNumberEffectivityCxtPartNumber>
    <LotNumberEffectivityCxtPartNumber></LotNumberEffectivityCxtPartNumber>
    <DefaultUnit>ea</DefaultUnit>
    <Name>1ZXX463114-BRB</Name>
    <PartType>separable</PartType>
    <Source>make</Source>
    <Version>A</Version>
    <Iteration>2</Iteration>
    <WO>W0761000</WO>
    <ItemNo>169</ItemNo>
    <Length>70.000000000000</Length>
    <Width>15.500000000000</Width>
    <Thickness>35.000000000000</Thickness>
    <Qty1>1.0000000000000</Qty1>
    <EndItem></EndItem>
    <TargetID>DT01</TargetID>
</Part>
</AddedParts>
<ChangedParts NAME="ChangedParts" TYPE="Unknown" STATUS="0">
</ChangedParts>
<UnchangedParts NAME="UnchangedParts" TYPE="Unknown" STATUS="0">
</UnchangedParts>
<DeletedAlternateLinks NAME="DeletedAlternateLinks" TYPE="Unknown" STATUS="0">
</DeletedAlternateLinks>
<AddedAlternateLinks NAME="AddedAlternateLinks" TYPE="Unknown" STATUS="0">
</AddedAlternateLinks>
<DeletedDocuments NAME="DeletedDocuments" TYPE="Unknown" STATUS="0">
</DeletedDocuments>
<AddedDocuments NAME="AddedDocuments" TYPE="Unknown" STATUS="0">
</AddedDocuments>
<ChangedDocuments NAME="ChangedDocuments" TYPE="Unknown" STATUS="0">
</ChangedDocuments>
<UnchangedDocuments NAME="UnchangedDocuments" TYPE="Unknown" STATUS="0">
</UnchangedDocuments>
<DeletedDocumentLinks NAME="DeletedDocumentLinks" TYPE="Unknown" STATUS="0">
</DeletedDocumentLinks>
<AddedDocumentLinks NAME="AddedDocumentLinks" TYPE="Unknown" STATUS="0">
</AddedDocumentLinks>
<DeletedBOMs NAME="DeletedBOMs" TYPE="Unknown" STATUS="0">
</DeletedBOMs>
<AddedBOMs NAME="AddedBOMs" TYPE="Unknown" STATUS="0">
<BOMHeader>
    <ObjectID>VR:wt.part.WTPart:17791:218293167-1229069940134-27856363-57-10-168-192@xxxxxxxxxxxxxxxxxxxxx</ObjectID>
    <Class>com.ptc.windchill.esi.BOMHeader</Class>
    <LastChangedBy>demo</LastChangedBy>
    <Number>1ZXX463003-BRB</Number>
    <StartEffectivity></StartEffectivity>
    <EndEffectivity></EndEffectivity>
    <StartSerialNumberEffectivity></StartSerialNumberEffectivity>
    <EndSerialNumberEffectivity></EndSerialNumberEffectivity>
    <StartLotNumberEffectivity></StartLotNumberEffectivity>
    <EndLotNumberEffectivity></EndLotNumberEffectivity>
    <SerialNumberEffectivityCxtPartNumber></SerialNumberEffectivityCxtPartNumber>
    <LotNumberEffectivityCxtPartNumber></LotNumberEffectivityCxtPartNumber>
    <Version>A</Version>
    <Iteration>3</Iteration>
    <TargetID>DT01</TargetID>
</BOMHeader>
</AddedBOMs>
<ChangedBOMs NAME="ChangedBOMs" TYPE="Unknown" STATUS="0">
</ChangedBOMs>
<UnchangedBOMs NAME="UnchangedBOMs" TYPE="Unknown" STATUS="0">
</UnchangedBOMs>
<DeletedBOMComponents NAME="DeletedBOMComponents" TYPE="Unknown" STATUS="0">
</DeletedBOMComponents>
<AddedBOMComponents NAME="AddedBOMComponents" TYPE="Unknown" STATUS="0">
<BOMComponent>
    <ObjectID>OR:wt.part.WTPartMaster:18165:218293167-1229069940134-27856363-57-10-168-192@xxxxxxxxxxxxxxxxxxxxx</ObjectID>
    <Class>com.ptc.windchill.esi.BOMComponent</Class>
    <PartNumber>0000000019</PartNumber>
    <AssemblyPartNumber>1ZXX463003-BRB</AssemblyPartNumber>
    <Quantity>1</Quantity>
    <Unit>each</Unit>
    <LineNumber></LineNumber>
    <FindNumber></FindNumber>
    <AlternateItemGroup></AlternateItemGroup>
    <StartSerialNumberEffectivity></StartSerialNumberEffectivity>
    <EndSerialNumberEffectivity></EndSerialNumberEffectivity>
    <StartLotNumberEffectivity></StartLotNumberEffectivity>
    <EndLotNumberEffectivity></EndLotNumberEffectivity>
    <EndItem>false</EndItem>
    <TargetID>DT01</TargetID>
</BOMComponent>
<BOMComponent>
    <ObjectID>OR:wt.part.WTPartMaster:18141:218293167-1229069940134-27856363-57-10-168-192@xxxxxxxxxxxxxxxxxxxxx</ObjectID>
    <Class>com.ptc.windchill.esi.BOMComponent</Class>
    <PartNumber>0000000017</PartNumber>
    <AssemblyPartNumber>1ZXX463003-BRB</AssemblyPartNumber>
    <Quantity>1</Quantity>
    <Unit>each</Unit>
    <LineNumber></LineNumber>
    <FindNumber></FindNumber>
    <AlternateItemGroup></AlternateItemGroup>
    <StartSerialNumberEffectivity></StartSerialNumberEffectivity>
    <EndSerialNumberEffectivity></EndSerialNumberEffectivity>
    <StartLotNumberEffectivity></StartLotNumberEffectivity>
    <EndLotNumberEffectivity></EndLotNumberEffectivity>
    <EndItem>false</EndItem>
    <TargetID>DT01</TargetID>
</BOMComponent>
</AddedBOMComponents>
<ChangedBOMComponents NAME="ChangedBOMComponents" TYPE="Unknown" STATUS="0">
</ChangedBOMComponents>
<UnchangedBOMComponents NAME="UnchangedBOMComponents" TYPE="Unknown" STATUS="0">
</UnchangedBOMComponents>
<DeletedSubstitutes NAME="DeletedSubstitutes" TYPE="Unknown" STATUS="0">
</DeletedSubstitutes>
<AddedSubstitutes NAME="AddedSubstitutes" TYPE="Unknown" STATUS="0">
</AddedSubstitutes>
<DeletedReferenceDesignators NAME="DeletedReferenceDesignators"
TYPE="Unknown" STATUS="0">
</DeletedReferenceDesignators>
<AddedReferenceDesignators NAME="AddedReferenceDesignators"
TYPE="Unknown" STATUS="0">
</AddedReferenceDesignators>
<Transactions NAME="Transactions" TYPE="Unknown" STATUS="0">
<Transaction>
    <TargetID>DT01</TargetID>
    <TransactionID>1</TransactionID>
    <WaitingEventID>VR:wt.part.WTPart:17791:218293167-1229069940134-27856363-57-10-168-192@xxxxxxxxxxxxxxxxxxxxx</WaitingEventID>
    <Object>1ZXX463003-BRB, A.3 (Design)</Object>
    <ObjectID>VR:wt.part.WTPart:17791:218293167-1229069940134-27856363-57-10-168-192@xxxxxxxxxxxxxxxxxxxxx</ObjectID>
    <PublishedBy>Administrator</PublishedBy>
    <PublishedDate>2009/01/22 7:44:08 AM</PublishedDate>
    <Type>com.ptc.windchill.esi.BOM</Type>
    <Locale>en_GB</Locale>
</Transaction>
</Transactions>
</wc:COLLECTION>

I need to know how to get selected items from the <Part> section and
the <AssemblyPartNumber> item from the <BOMComponent> section into an
XML file, and then to change that into a CSV file (*phew*). I'm going
through w3schools at the moment and will tackle more of it over the
weekend. This is really fascinating stuff! One day I'm going to ask
how to split the XML above into 3 seperate XML files: 1 for Parts, 1
for the BOMHeader and the 3rd for BOMComponents... but I think I'll
leave that for another day...

Many Thanks and Kind Regards,

Mike in SA